Excel Intro:
Select Sheets

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007,2010,2013,2016  or españolIcon: Change web

To select worksheets, you use the tabs at the bottom of the workbook window. 

Why would you want to select sheets? 

  • To rearrange their order 

  • To copy sheet(s) to a new spreadsheet

  • To perform the same action on all the selected sheets at once.  
    (This is tricky, but it can be a very handy way to format a set of sheets all at once.)


Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel Intro
    InterfaceTo subtopics
    Select & Navigate To subtopics
     footprintSelect Cell
     footprintSelect Range
     footprintSelect Row/Column
     footprintSelect Sheet
           Methods Popup Table
           Shortcut keys Popup Table
    Common TasksTo subtopics
    ExercisesTo subtopics

Project 2: Excel BasicsTo subtopics

Project 3: Format & ArrangeTo subtopics

Project 4: Groups & FormulasTo subtopics

Project 5: DesignTo subtopics


Icon Step-by-Step 

Step-by-Step: Select Sheets

 Icon Step-by-Step

What you will learn:

to select a sheet
to select adjacent sheets
to select non-adjacent sheets 
to de-select a group of sheets

Start with: (Excel open to budget.xls from resource files)

Select Sheet: Click

The sheets in this workbook have names to fit their contents.

  1. Click on the sheet tab for Inflow-Outflow Difference.

    It is now the active sheet, which puts it on top of the other sheets. This sheet is a chart based on data on the Budget sheet.

Select Sheets: Keys

Sheets that are selected together are grouped.

  1. Select the sheet named Budget.
  2. Hold the SHIFT key down and click on the sheet named Actual.

    3 sheets selected

    All three sheets are all selected. They are grouped.

    Tip You cannot drag to select multiple sheets. Dragging moves the sheet(s) instead.

    WarningWhen multiple sheets are selected, anything you do to the one on top (the visible one), is done to all of the selected sheets. This includes entering data, formatting, adding or deleting rows or columns, and clearing data. Be very careful when multiple sheets are selected!

  3. Ungroup sheets (mouse): Click on Actual
  4. Tip Grouping is removed when you click on a sheet that is not in the group. If all of the sheets are grouped, a click on any sheet removes the grouping.

Select Sheets: Non-adjacent

  1. Select non-adjacent sheets: With the sheet Actual selected, hold the CTRL key down and click on Budget. Only the sheets Budget and Actual are selected. The name Actual is bold and Actual is the active (visible)  sheet.

    Non-adjacent sheets selected.

  2. Click on the sheet Budget. It becomes the active sheet. The grouping remains.
  3. Right click menu with sheets selectedUngroup sheets (menu)
    Right click on the Budget tab and from the popup menu choose  Ungroup Sheets . Now only the Budget sheet is selected.

    This method is best when you want to ungroup the sheets, but you want to switch to a different sheet.


       Selection Methods Popup Table
       Shortcut keys for Excel Popup Table