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
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:
Create a Drop Down Menu in a Cell
I recently received an email from a reader asking how to add a hidden drop down menu inside a cell. I was unable to respond back to the reader (email address was invalid), but I thought it was a great question and wanted to add it to Excel Hints. In just a couple steps, you’ll [...]
Add Comments to Your Spreadsheet
Excel offers an easy way to include some documentation within the spreadsheet you are working on. A few reasons for including comments in your work may be to explain a complex formula, note possible future changes or to remind you that you have some hidden columns you might want to come back to. Adding comments [...]
