Skip to content
Tutorials Center
My learning

Topics

Lesson 4 of 93 ยท Getting Started

Workbooks, Worksheets and Navigation

Manage worksheets (add, rename, move, copy, group, hide), freeze panes and split windows, and move quickly through big sheets with Ctrl+Arrow and Go To.

A single workbook can hold dozens of sheets and each sheet can hold hundreds of thousands of rows. Working comfortably means organizing sheets sensibly and moving around without dragging scroll bars. This lesson covers both: the everyday sheet operations, the tools that keep headings in view, and the keyboard moves that take you to the end of a big table in a split second.

Excel cannot run inside this page, so the commands below are described in text. Two JavaScript stand-ins model the logic behind them: a workbook that can add, rename, move and copy sheets, and the famous Ctrl+Arrow jump. They show what happens, not how Excel is built internally.

Sheet housekeeping

Add The plus button or Shift+F11.
Rename Double-click the tab.
Move or copy Drag; hold Ctrl to copy.
Hide Right-click, then Hide.
1 / 2

Working with worksheets

All sheet commands live on the sheet tabs at the bottom of the window, usually through a right-click menu.

  • Add a sheet with the + button, Shift+F11, or right-click a tab โ†’ Insert. The new sheet is named Sheet2, Sheet3, and so on.
  • Rename by double-clicking the tab (or right-click โ†’ Rename, or Alt+H, O, R). Names can have up to 31 characters and may not contain : \ / ? * [ ]. Short, descriptive names such as Data, Lookups and Summary make formulas readable, because a formula that points at another sheet includes the name: =Data!B2*Lookups!B1. If the name has spaces, Excel wraps it in apostrophes: ='Sales 2025'!B2. Avoiding spaces keeps formulas shorter.
  • Move a sheet by dragging its tab left or right. A small black triangle shows the drop position.
  • Copy a sheet by holding Ctrl while dragging (a plus sign appears on the pointer). Excel names the copy with a number in parentheses, like Data (2). Right-click โ†’ Move or Copy... also lets you send a sheet to another open workbook.
  • Delete with right-click โ†’ Delete. Deleted sheets cannot be restored with Undo, so save first when unsure. Formulas that pointed to the removed sheet show #REF! (see Formula Errors).
  • Tab colors (right-click โ†’ Tab Color) help you spot input sheets versus report sheets.

Hiding sheets

Right-click a tab โ†’ Hide hides a sheet without deleting it; Unhide brings it back from a list. A sheet can also be very hidden, which only the VBA editor can toggle, so Unhide will not list it. Hiding is not security: anyone can unhide a normal hidden sheet, and the data is still in the file. Use protection (see Saving, File Formats and Sharing) for access control.

Grouping sheets

Click one tab, hold Shift and click another to select a range of tabs, or hold Ctrl to pick separate tabs. The title bar then shows [Group]. Whatever you now type or format on the active sheet is applied to all grouped sheets at the same addresses. This is very useful for twelve identical monthly sheets, and dangerous when forgotten: always right-click a tab and choose Ungroup Sheets (or just click a tab outside the group) when you are done.

A workbook model

This stand-in stores sheets in an ordered list and offers the operations above, including Excel's naming of copies and the rule that you cannot delete the last visible sheet.

JS Workbook stand-in: add, rename, move, copy

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Watch the error cases: duplicate names are rejected even when the capitalization differs, because Excel treats sheet names as case-insensitive.

Freeze panes and split

When you scroll down a long table, the column headings disappear and you forget which column is which. Freeze Panes (View โ†’ Freeze Panes) pins rows or columns so they stay visible:

  • Freeze Top Row pins row 1.
  • Freeze First Column pins column A.
  • Freeze Panes (the first option) pins everything above and to the left of the active cell. Select B2 first to freeze both row 1 and column A; select A3 to freeze the top two rows.

A thin line marks the frozen edge. Choose Unfreeze Panes to remove it. Note that frozen rows must start at the top of the window; if you scrolled before freezing, rows above the window get hidden, which confuses people, so press Ctrl+Home first.

Split (View โ†’ Split) divides the window into two or four independently scrolling panes of the same sheet at the active cell. It is useful when you want to compare row 5 with row 5,000 without leaving either view. Drag the split bars to resize them, and click Split again to remove them. Excel also offers View Side by Side and New Window for comparing different sheets or workbooks.

Scrolling with the mouse is slow for large data. Learn these moves:

Shortcut Result
Ctrl+Arrow Jump to the edge of the current block of data
Ctrl+Shift+Arrow Select from here to the edge of the block
Ctrl+Home / Ctrl+End Go to A1 / go to the last used cell
Home Go to the start of the row
Page Down / Page Up One screen down / up
Alt+Page Down One screen to the right
Ctrl+Page Down / Ctrl+Page Up Next / previous worksheet
F5 or Ctrl+G Go To dialog: type an address or choose a named range
Ctrl+F Find

Ctrl+Arrow follows a precise rule. If the active cell and its neighbor in that direction are both filled, you jump to the last filled cell of that run. If the neighbor is empty (or the current cell is empty), you jump to the next filled cell, or to the sheet's edge if none exists. Press Ctrl+Down repeatedly and you hop from block to block.

The Ctrl+Arrow rule in code

JS Ctrl+Down stand-in on a column with gaps

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Starting at row 1, the jumps go 4, 7, 9, 12 and then the very last row of the sheet. This is why Ctrl+Down is unreliable for finding the end of a table that contains blank cells: it stops at the first gap. Ctrl+End finds the last used cell, but Excel's idea of "used" can include cells you cleared formatting from, so the cursor may land far below your data.

To select a whole table quickly, click any cell inside it and press Ctrl+A (or Ctrl+* on some keyboards). Excel selects the current region: the block of cells surrounded by blank rows and columns. Keep your tables free of fully blank rows and columns so this works.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. You want row 1 and column A to stay visible while scrolling. Which cell should be active before you choose Freeze Panes?

    Freeze Panes pins everything above and to the left of the active cell. With B2 active, row 1 and column A are frozen.
  2. 2. What does it mean when the title bar shows [Group]?

    Grouped sheets receive the same entries and formatting at the same addresses. Ungroup before continuing normal work.
  3. 3. Which statement about hidden sheets is true?

    Hiding only removes the tab from view. Use protection or remove sensitive data to actually restrict access.
  4. 4. You press Ctrl+Down on a filled cell whose lower neighbor is empty. Where do you land?

    Ctrl+Arrow jumps to the next filled cell across a gap. Without further data it goes to the sheet edge.

Summary

  • Sheets are managed from the tabs: add, rename (31 characters, no : \ / ? * [ ]), move, copy with Ctrl-drag, hide and color.
  • Grouped sheets share edits: always ungroup afterwards. Hidden is not secure.
  • Freeze Panes pins rows above and columns left of the active cell; Split gives independent scroll areas.
  • Ctrl+Arrow, Ctrl+Home, Ctrl+End, Ctrl+Page Down and F5 get you around large workbooks fast.
  • Keep tables free of blank rows and columns so selections and jumps behave.

Next: Formatting Cells.