Skip to main content
Workforce LibreTexts

4.17: Creating a Workbook with Multiple Worksheets

  • Page ID
    14776
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    Learning Objectives

    • Create a new workbook with more than one worksheet.

    Method 1

    The easiest method to add additional worksheets to a workbook is by using the Insert Worksheet shortcut represented by the + button at the bottom of the workbook window. You can use this shortcut button multiple times to insert additional worksheets into your workbook.

    A blank excel sheet is open. A green arrow is pointing at the option to add a new sheet.

    Method 2

    You can also use the menu option Insert>Insert Sheet from the Cells group of the ribbon.

    A blank excel sheet is open. There is a green arrow pointing to the insert dropdown menu, and specifically the insert sheet option.

    Contributors and Attributions

    CC licensed content, Original
    • Creating a Workbook with Multiple Worksheets. Authored by: Shelli Carter. Provided by: Lumen Learning. License: CC BY: Attribution

    4.17: Creating a Workbook with Multiple Worksheets is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?