5Project 2B Key Points

  1. It is often convenient to have more than one worksheet in a workbook (Excel file). By default these are named Sheet1, Sheet2, etc. You will generally want to rename them to more descriptive names. You can rename a worksheet by double clicking its tab (or by right clicking the tab) and then typing a new name. You can change the color of the tab by right-clicking the tab and choose Tab Color.
  2. Dates can be entered in a variety of formats - m/d/yy, d-mmm, d-mmm-yy, mmm-yy. A two-digit year value of 30 through 99 is interpreted by the Windows operating system as the four digit years 1930 through 1999. All other two-digit year values are assumed to be in the 21st century. You can always type a 4 digit year to force Excel to interpret the date as you intended.
  3. Ctrl + semicolon enters the current date. This value is static; it does not change when the spreadsheet is opened at a later date. This is in contrast to TODAY() which enters the current date or NOW() which enters the current date and time, both of which recalculate when a spreadsheet is opened and thus are termed dynamic - see https://support.office.com/en-us/article/insert-the-current-date-and-time-in-a-cell-b5663451-10b0-40ab-9e71-6b0ce5768138
  4. A cell has contents and may have formats applied. You can choose to delete or clear the contents, the format, or both. You can clear the contents by clicking the cell, and then in the editing group, click Clear>Clear Contents. Alternatively you can click the cell and then press the Delete key on the keyboard. To clear formats, in the Editing group, click Clear>Clear Formats.
  5. Copy and Paste by Using the Paste Options Gallery - You can select one or more cells, right click on the selection and then click Copy. This places a copy of the cells on the Clipboard. You can then point to a cell in the same worksheet, or another worksheet, right-click and under Paste Options, point to the first button, Paste. Live Preview displays how the copied cells will be placed if you click the Paste button. When pasting to a range of cells, you need only point to or select the cell in the upper left corner of the paste area.
  6. Edit and Format Multiple Worksheets at the Same Time - Right click on a sheet tab and then click Select All Sheets. At the top of your screen, notice that [Group] displays in the title bar. Data and formatting you enter in one sheet will be entered on all the selected sheets in the same place. You can also enter a formula and have it distributed across worksheets. To cancel the group, click on the sheet tab for one of the sheets in the group.
  7. Create a Summary Sheet - A summary sheet is a worksheet where totals from other worksheets are displayed and summarized. You can insert a worksheet by clicking the plus sign in the sheet tab line. To construct a formula that refers to another sheet, type an = sign and then click the sheet tab of the sheet you want to reference and then click the desired cell and then press Enter. Subsequent changes in the detail sheets will be reflected in the summary sheet.
  8. Format and Print Multiple Worksheets in a Workbook - You can change the order of sheets in a workbook by just dragging the sheet tab. By grouping the sheets, you can then apply formatting across all sheets and use common margins and footers across all sheets. Selecting File>Print enables you to print just the active sheet (the default) or Print the entire workbook.

revised: 9/14/21. Comments to Bill Pegram, wpegram@nvcc.edu