Naming Worksheets; Gouping & Hiding Columns & Rows;Grouping Workbooks

Excel Worksheet Management

Default Worksheet Names

  • Excel names its worksheets by default as:

    • Sheet one

    • Sheet two

    • Sheet three

Renaming Worksheets

  • Shortcut: To rename a worksheet, use the keyboard shortcut:

    • Press Alt + H + O + R

  • Steps:

    1. Press the shortcut keys to highlight the current name of the worksheet.

    2. Type in the new name (e.g., "income statement").

    3. Press Enter to confirm the new name.

Adding and Deleting Worksheets

  • Adding a New Worksheet:

    • Shortcut: Press Alt + H + I + S.

    • Outcome: A new worksheet will be added with a default name (e.g., "sheet four").

  • Deleting a Worksheet:

    • Shortcut: Press Alt + E + L.

    • Outcome: The currently active worksheet will be deleted.

Grouping Columns and Rows

Purpose of Grouping

  • Grouping is used to hide rows or columns for

    • Formatting and presentation purposes.

    • Managing old or irrelevant data that does not need to be shown constantly.

Grouping Columns

  • Steps:

    1. Select the desired columns by hitting Ctrl + Space Bar.

    2. Create the group using Shift + Alt + Right Arrow Key.

    3. Hide the columns: Press Alt + A + H.

    4. Unhide the columns: Press Alt + A + J.

    5. Remove the grouping: Press Shift + Alt + Left Arrow Key.

Grouping Rows

  • Steps:

    1. Select the desired row(s) by hitting Shift + Space Bar.

    2. Follow the same steps as above for grouping columns.

Caveats of Hiding Data

  • Using the grouping function as described is preferred over Excel's hiding function.

  • Reason: Grouping provides clear indications (e.g., plus or minus signs) that data is hidden, whereas hidden columns or rows have no visual cues.

Hiding Rows and Columns

  • Alternate Hiding Method:

    • Hiding Rows: Alt + H + O + U + R

    • Hiding Columns: Alt + H + O + U + C

  • Note: This method is not recommended for regular use due to lack of indicators for hidden data.

Grouping Worksheets

Benefits of Grouping Worksheets

  • Useful for consistent formatting or data entry across multiple sheets.

  • Allows simultaneous changes in multiple worksheets, which is effective for large data sets.

Steps for Grouping Worksheets

  • Control of Grouping:

    1. Hold Ctrl + Shift.

    2. Press Page Up or Page Down to select contiguous worksheets.

    3. Confirm that the sheets are grouped by a distinct shading on the tabs.

    4. A group indicator appears on the title of the workbook.

Entering Data in Grouped Worksheets

  • Example: To input the title "income statement" into cell A1 of all grouped worksheets.

  • Steps:

    1. Type "income statement" into cell A1.

    2. Use formatting (e.g., bold) if desired.

Ungrouping Worksheets

  • To ungroup the worksheets:

    • Use Ctrl + Page Up or Ctrl + Page Down.

  • Caution: Failure to ungroup may result in accidental changes that affect all grouped sheets. For instance, typing a new entry will overwrite existing data across all grouped worksheets, which could disrupt calculations or analysis.