Tip # 2 Format all the worksheets in a workbook

If you need to format all the worksheets in a workbook the same way, you can hold down the Shift or Control button and select the worksheets. Now that you have the worksheets selected, you can change things like cell or page properties that will apply to all the worksheets selected. After you're done, click on an inactive worksheet (if you've selected all the worksheets) or click on an unselected worksheet (if you did not select all the worksheets) to release the hold.

Tip # 1 The Great F4

The 'F4' is easily the most useful shortcut key in Excel. Basically it repeats your last command.
So say you changed the color of a font in a cell. Now click in a new cell and hit 'F4' and it will change the font in the new cell to the same color.Wonderful, right? Well what's great about this is that it works for nearly everything else in Excel too.Highlight a row, right-click and choose 'Delete'. Now highlight another row and hit 'F4'. It deletes that row.Whatever you did last, Excel will attempt to repeat the same command until you do something else. This works great for things that require you to go to the menus or right-click and make choices or click buttons that bring up more dialogs. It can be huge time saver once you get used to using it. As the help says, it doesn't work in every situation but most times 'F4' works great.