Then using the down-arrow highlight the appropriate fringe category, hit ENTER or the SPACEBAR to select. To ease in data entry, you may use ALT+ the down-arrow to pop up the list. When you pick a category, that fringe category is listed in the cell and the appropriate rate is entered into the Fringe Rate column. The pull-down box contains all of the fringe benefit categories in alphabetical order. For example, on the Salary & Wage sheets the "Fringe Category" contains a list from the Fringe Rates page. These pull-down boxes list the valid range of data which can be included in that cell. Some cells in the Salary & Wages pages contain "pull-down" boxes to aid in preparing your budget. The ENTER key will move to the next row in the worksheet. The TAB key will move the cursor to the next editable cell. You may use the TAB key and ENTER keys to move around the worksheet. To edit a cell, use your mouse to click within that cell. This was designed to prevent calculation errors. Most of the calculated fields are locked and cannot be changed. This means that you can change only the editable cells. NOTE: if using a Mac it may be necessary to adjust the print size to 80% in order to print each worksheet on one page only.Īll worksheets are "protected". The "printer" icon on the tool bar will also print the active worksheet. You can also use this to print only the active page. Then under the "Print What" section, select 'Entire Workbook'. To PRINT a workbook: select PRINT from the File menu. To SAVE the workbook: Use "Save As." under the File menu option to save the Standard Budget workbook under a different name. If you cannot see the worksheet you wish to work on, use the arrow buttons in the lower left corner of the screen. For example, to move to the page for "Salary & Wage Year 1", click on that tab located on the bottom of the Excel screen. To move to a different sheet, click on the tab for that sheet. ![]() This page is in the required formatįor more complete definitions of each budget
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |