Using Excel: Learn It 2 – Creating a Workbook with Multiple Worksheets

  • 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 magenta 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 magenta arrow pointing to the insert dropdown menu, and specifically the insert sheet option.

 

5 Tips for Success in Google Sheets

  1. Use Shortcuts: Learning Google Sheets keyboard shortcuts will save you a lot of time. For example, use Ctrl+C and Ctrl+V to copy and paste, or Ctrl+Z to undo changes.
  2. Freeze Rows and Columns: If you have headers or labels that you want to keep visible while scrolling through data, you can freeze rows or columns by going to View > Freeze.
  3. Conditional Formatting: Use Conditional Formatting (under Format > Conditional formatting) to highlight cells based on their values, such as marking all cells with values above 90% in green.
  4. Backup Your Data: While Google Sheets automatically saves your work in the cloud, it’s always a good idea to download important data as a backup. Go to File > Download to save your spreadsheet as an Excel file, PDF, or CSV.
  5. Explore Add-ons: Google Sheets offers a wide variety of add-ons that can enhance your experience, from advanced charting tools to apps that automate data entry tasks. Check out the Add-ons menu to explore what’s available.

By following these steps, you’ll be able to master the fundamental features of Google Sheets and use it effectively for data manipulation, analysis, and collaboration. Whether for personal organization or group projects, Google Sheets offers the tools you need to manage data with ease.