Technology

Ultimate Guide to Adding Worksheets in Excel and Google Sheets: A Comprehensive Step-by-Step Tutorial

Adding additional sheets in excel comes in handy as using multiple sheets allows you to organize your data logically making it easier and more flexible to create reports and charts for data analysis. This article by FPT Shop will provide a simple and quick guide on how to add an excel sheet!

Administrator

21 April, 2024

169

When working with multiple data files on Excel software or wanting to organize data into separate sections, adding a sheet helps you organize data more systematically and make it easier to manage. The following article from FPT Shop will show you how to add a sheet in Excel, how to add a new sheet in Google Sheet, quickly and easily.

The difference between Sheet and Workbook in Excel

Before proceeding to add a sheet in Excel, it’s important to understand the difference between the two concepts of “sheet” and “workbook”:

Workbook: An Excel file that contains a set of sheets or worksheets. The maximum number of sheets in a workbook depends on the specific version of Excel. A Workbook can also be understood as the main workspace for data and calculation formulas.
Sheet or Worksheet: A spreadsheet with a default name like sheet1, sheet2,… Each sheet consists of a grid of cells organized into rows and columns, forming numerous cells in Excel. The specific number of rows and columns in each sheet also depends on the specific version of Excel or as defined by the user.

How to add a new sheet in Excel

Add a new sheet using a shortcut

You can quickly add a sheet in Excel by using a shortcut. This method can be applied to all current versions of Excel (Excel 2003, 2007, 2010, 2013,…)

To add a sheet in Excel, simply press Shift + F11 on your keyboard.

Add a sheet in Excel 2007, 2010, 2013,…

Method 1: Using the available icon in Excel

Look at the bottom of the screen, next to the sheet name there is a + (plus sign) icon that allows you to left-click to quickly and easily add a new sheet. This method also helps you to add a new sheet in Excel conveniently with just one click.

Method 2: Using the command on the Ribbon

Besides the above methods, you can also add a sheet in Excel by using the commands available on the Ribbon by:

Step 1: Open the Excel file you need to add a new sheet → select the Home tab.

Step 2: Go to Cells → click Insert → then choose Insert Sheet to add a new sheet in Excel.

Add a new sheet in Excel 2003

You can add a new sheet on Excel 2003 and other versions as follows:

Step 1: Open the Excel file you need to add a new sheet to and right-click on the sheet name.

Step 2: In the menu that appears, select Insert.

Step 3: In the Insert dialog box, select the General → tab then choose Worksheet → then click OK to add a new sheet in Excel.

How to add a new spreadsheet in Google Sheet

Add a new spreadsheet using a shortcut

Similar to the method to add a sheet in Excel, you can quickly add a new spreadsheet in Google Sheet with just the shortcut Shift + F11.

Add a new spreadsheet using the available icon

At the bottom, to the left of Spreadsheet 1, there is a plus sign (+) icon, you can left-click on the icon to quickly add a new spreadsheet.

Add a new spreadsheet using the Ribbon

You can also add a new spreadsheet in Google Sheet by using the commands available on the Ribbon.

Step 1: Open the Google Sheet you need to add a new spreadsheet to.

Step 2: Click on the Insert tab → then select New Spreadsheet to add a spreadsheet in Google Sheet.

Frequently asked questions

To add a new worksheet in Excel, simply right-click on any existing worksheet tab at the bottom of the Excel window and select ‘Insert’. This will give you the option to insert a new worksheet either before or after the currently selected sheet.

Yes, you can easily change the color of your worksheet tabs in Excel. Right-click on the tab you want to change and select ‘Tab Color’. From there, you can choose from a variety of colors to make your tabs stand out.

Renaming a worksheet in Excel is simple. Just double-click on the existing name in the tab, delete it, and then type in your new name. Hit enter when you’re done, and the worksheet will be renamed.

Excel is a Microsoft Office product and is a widely-used spreadsheet program. Google Sheets is a similar spreadsheet program that is part of the Google Workspace (formerly G Suite) and is accessible through a web browser or mobile app. While both programs have similar functionality, there are some features unique to each.

Yes, Google Sheets supports a wide range of formulas that are very similar to Excel. You can use functions like SUM, AVERAGE, VLOOKUP, and many more. The syntax for these formulas is generally the same as in Excel, making it easy to transfer your knowledge between the two programs.