Setting the Print Area on an Excel spreadsheet

Obviously, you can have a multitude of rows and columns in an Excel spreadsheet spread out over numerous worksheets. However, if you want to print out just part of the information, you may think you have to print out everything just to get the part you want. In reality, you can set the Print Area of your spreadsheet to only print out the area that you need, saving paper and time in the process. Here’s how you do that…

Changing your user initials in Office programs

A colleague pointed out this option to me the other day, and it’s a good one to share. In Office programs like Word or OneNote, the system often uses your initials to note who made changes. But perhaps you need to change your initials for some reason (duplicate of someone else, you don’t like them, etc.). Here’s how you do that…

Working with the Excel Fill Handle

One of the cool things about working with Excel is the ability to click on the Fill Handle in the lower right corner of a cell, and then drag it to auto-fill values based on what’s in the original cell. However, it can be frustrating to figure out whether it’s going to copy the value or auto-fill based on the next value in the sequence. Here’s a brief overview on how you can get it to copy or fill based on what you need, regardless of what Excel wants to do for you automagically…

Selecting all the content in your Excel spreadsheet

Not being an Excel guru, I tend to do things manually instead of using features that can make things a LOT faster… such as selecting all the data in an Excel spreadsheet. I’ve been known to do a lot of scrolling to find the end points and dragging to select everything. It’s a lot easier just to use the CTRL-A keyboard shortcut!