Protect Cell Formats
- Comments Off
I received a comment from a reader the other day asking this question: How can I protect the formatting of a sheet without preventing changes to the cell contents? In other words, she wanted to the sheet’s users to be able to be able to type in numbers, but not mess up her border, fonts […]
Quickly Select Entire Sheet
- Comments Off
I’ve talk to several people the last few days that weren’t aware of this simple trick. Instead of using your mouse to select all the cells on your spreadsheet, Excel has a built-in way of quick selecting everything. By clicking in the top-left square, above the row numbers and left of the column letters, you […]
Excel Keyboard Shortcuts
Using these Microsoft Excel shortcuts will greatly decrease your time spent doing simple operations. This is not an exhaustive list of available shortcuts, only commands that I have found useful through my experiences. I’ve found that the best way to see if any of them will work for me, is to try a couple at […]
Print Column Headers On Each Page
- Comments Off
Have you ever wanted to print the column headers at the top of each page to make reading the document easier. Well Excel provides an easy way to accomplish this task in only a few steps. To have Excel show column headers at the beginning of each page during a print job: