Microsoft Office Productivity

If you find that you are typing the same list of data over and over in Excel, there is a way to create a custom list to make entering this data much faster in the future.

Changing this setting will allow you to print column and row headers on every sheet you print out. If you do not select to “Print Titles” your column and row headers will ONLY appear on the first page of your print out.
 

If you need to make changes to a worksheet that contains a lot of formulas, or complex formulas, you may need to know what cells will affect these formulas. You can trace formula ‘Precedents’ and ‘Dependents’ with the click of a button.
 

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.