Skip to main content
Business LibreTexts

6.12: Introduction to Using Multiple Worksheets

  • Page ID
    46513
  • \( \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}}\)

    What you’ll learn to do: create a new workbook with more than one worksheet.

    When you open a new Excel file, there is automatically a single worksheet. However, there are a number of reasons why you may want more than one worksheet in a single workbook. For example, consider the following ways multiple worksheets in a workbook can help with keeping data organized:

    1. A workbook with monthly sales figure with each year on a different worksheet
    2. A workbook with mailing lists for weekly flyers on one worksheet and coupon mailings on another
    3. A workbook with inventory data with each month on a different worksheet

    In any of these cases, or others, it is very easy to add more worksheets to an Excel workbook.

    Contributors and Attributions

    CC licensed content, Original
    • Introduction to Using Multiple Worksheets. Authored by: Shelli Carter. Provided by: Lumen Learning. License: CC BY: Attribution

    6.12: Introduction to Using Multiple Worksheets is shared under a CC BY license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?