Oct 21 2008

Protect Cell Formats

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 […]

Oct 10 2008

Quickly Select Entire Sheet

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 […]

Oct 8 2008

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 […]

Oct 7 2008

Print Column Headers On Each Page

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:


Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks