When you view a worksheet that contains a large amount of columns and/or rows, you may want to 'Freeze' some of the panes so they remain in view when you scroll through the worksheet. This can be done with a few clicks of the mouse. This process works the same in Excel 2007 and Excel 2010.
You can quickly add pre-formatted headers to your worksheets in Excel using the 'Page-layout' tab. This tutorial is applicable to Excel 2010.
You can quickly add pre-formatted headers to your worksheets in Excel using the 'Page-layout' tab. This tutorial is applicable to Excel 2007.
There are time you may want to hide an entire worksheet within a workbook. In Excel 2007 & Excel 2010 this can be easily accomplished with a few clicks of the mouse.
There are a couple different ways you can Increase/Decrease the font size in an entire worksheet, or just selected cells. This video works the same in Excel 2007 & Excel 2010.