Start the Microsoft Excel application and then load the old year's workbook into the application's workspace as the source needed for the rolled-over numbers.

Open your Excel workbook and right-click on a sheet. Select Hide. Now you are all set to share your workbook with your boss and employees.

Named ranges aren't just for formulas. Here are two ways you can use named ranges to create shortcuts for quick navigation in a Microsoft Excel workbook.