How to Create a New Worksheet in Excel 2013


A Microsoft Excel file is called a workbook, and a single workbook can contain multiple worksheets. This is helpful when you have a lot of data for a single purpose, but which may not necessarily belong on a spreadsheet together.

Excel workbooks will typically include three worksheets by default, but that number can be modified based on your current needs. Our guide below will show you how to create a new worksheet in an Excel 2013 workbook so that you can add information to your file without editing an existing worksheet.

You can read this article for more information about the difference between a worksheet and a workbook in Excel.

Creating a New Worksheet in Excel 2013

The steps in this guide will show you how to add a new, blank worksheet to the workbook that is currently active in Excel 2013. If you wish to make it easier to identify this worksheet in the future, then read this article about renaming a worksheet in Excel 2013.

  1. Open your workbook in Excel 2013.
  2. Click the + button at the bottom of the window, to the right of the existing sheet tabs.

These steps are also shown below with pictures –

Step 1: Open your workbook in Excel 2013.

 

Step 2: Click the New sheet button (the + icon) to the right of your existing worksheet tabs.

how to create a new worksheet in excel 2013

 

 

Note that you can also create a new worksheet by clicking the Home tab at the top of the window, then clicking the arrow under Insert in the Cells section of the ribbon, then clicking the Insert Sheet button.

click the insert sheet button

 

 

If you are unable to see the worksheet tabs at the bottom of Excel, then they may be hidden. Learn how to unhide worksheet tabs in Excel 2013 to make it easier to switch between worksheets.

 

Is there a single missing worksheet in your workbook, and you are unable to locate it? You can unhide worksheets in Excel 2013 so that you can edit information contained within them.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.