Microsoft Office Productivity

Sometimes you may want to insert hyperlinks to another worksheet inside of your workbook.  In this example we are going to take a quote for supplies for a fictitious hospital.  We are going to link the departments on the front page to the sheet for that department in the workbook.  We are also going to insert a hyperlink on each worksheet that will take us back to the main page of the quote.  This will work the same in Excel 2010 and Excel 2007.
 

Instead of using the Copy and Paste function to copy worksheets into a new workbook, you can use the "Move and Copy" function to simplify the process.  This can be a great time saving shortcut.  This works the same in Excel 2010, Excel 2007 and Excel 2003.

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.