Microsoft Office Productivity

There are times you may have hidden data in a spreadsheet. If you use the ‘Sum’ function, you will receive a total based on all the information, including hidden cells. If you would like to see a ‘Sum’ that only includes the visible data, you will need to use a special formula with "Subtotal".
 

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.

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.