Monday April 18, 2011 at 2:40pm
When you are dealing with a spreadsheet that you didn’t create yourself, it can be useful to locate the cells that hold formulas, particularly if you are checking for errors. Normally, you only see the formula contained in a cell when you select that cell: it appears in the Formula Bar. On Excel 2007 and 2010, to show all the formulas, you can select the Formulas tab and click onto the Show Formulas button, which is in the Formula Auditing group. On Excel 2003, select Tools from the menu b....
Monday March 7, 2011 at 9:43am
Excel has shortcut keys for practically everything but it’s hard to remember them all.
A few useful ones are: CTRL + 'copies the data from the cell above
CTRL + ; inserts today’s date (as a fixed value)
CTRL+SHIFT+$ formats the cell as currency CTRL+SHIFT+% formats the cell as a percentage
CTRL+SHIFT++ (CTRL and plus)inserts cells or rows (depending on what you have selected)
CTRL+- (CTRL and minus)deletes cells or rows (depending on what you have selected)....
Tuesday January 4, 2011 at 9:36am
Don’t just insert a blank sheet and copy and paste the information you need… copy the whole Worksheet by dragging the sheet tab to where you want the new sheet to be and holding the CTRL key while you release the mouse button. Then you can adjust the new sheet as you wish. This way, everything about the existing Worksheet is copied, including column widths, filter settings, page setup, headers and footers and so on. Oh, and by the way, you can even drag the Worksheet to a different ....