Get started with Sheets for Google Workspace Create or import a spreadsheet Add or update content in a spreadsheet Use Gemini to generate and organize content Want advanced Google Workspace features for your business? Try Google Workspace today! Create or import a spreadsheet Create and name your spreadsheet On your computer, open a Google Docs , Sheets , Slides , Forms or Vids home screen. Create a file from template Use a template in Google Vids At the top of the page, click Untitled document and enter a new title. Import and convert an existing spreadsheet Converting your file from another program creates a copy of your original file in a Docs, Sheets, or Slides format. You can then edit the file in your browser. If you have existing files, you can import and convert them to Docs, Sheets, or Slides. Click New File Upload . Choose the file you want to import from your computer to add it to Drive. In the Upload complete window, click Show file location . Right-click the file and select Open with Google Docs/Sheets/Slides . Have a Microsoft file? If you've already stored Microsoft files in Drive, you can also update them without converting them . Add tabs to your spreadsheet Work with more than one sheet in a single spreadsheet file by adding tabs. At the bottom of your spreadsheet, click Add sheet to add another tab. Add or update content in a spreadsheet Add or update data Open a spreadsheet in Google Sheets . Click a cell that’s empty, or double-click a cell that isn’t empty. Optional: To add another line within a cell, press ⌘ + Enter on a Mac or Ctrl + Enter on Windows. When you’re done, press Enter . Add rows, columns, and cells : Select the row, column, or cell near where you want to add your new entry. Right-click the highlighted row, column, or cell Insert choose where to insert the new entry . Delete, clear, or hide rows and columns :

Right-click the row number or column letter. Click Delete , Clear , or Hide . Select the cells. Right-click Delete cells Shift left or Shift up . Move rows or columns : Select the row number or column letter and drag it to a new location. Select the cells. Point your cursor to the top of the selected cells until a hand appears. Drag the cells to a new location. Group rows or columns : Select the rows or columns. Click View Group Group rows or Group columns . Freeze header rows and columns : Keep a row or column in the same place as you scroll through your spreadsheet. On the menu bar, click View Freeze and choose an option. Add formulas or functions Open a spreadsheet. Type an equal sign ( = ) in a cell and type in the function you want to use. Note: You may see suggested formulas and ranges based on your data. A function help box will be visible throughout the editing process to provide you with a definition of the function and its syntax, as well as an example for reference. If you need more information, click the “Learn more” link at the bottom of the help box to open a full article. Use Gemini to generate & organize content You can use this feature only if your organization supports it. For help, contact your administrator . On your computer, open a spreadsheet in Google Sheets . At the top, click Ask Gemini . Select a prompt or create your own. For example: “Create a framework for researching a sales prospect to prepare for a customer meeting.” “Set up a task tracker to build a new website.” “Plan a kick-off event for the sales team.” “Create a framework for researching a sales prospect to prepare for a customer meeting.” “Set up a task tracker to build a new website.” “Plan a kick-off event for the sales team.” Choose an option: To add the table to your spreadsheet, click Insert . To create a different version of the table, click Retry . To add the table to your spreadsheet, click Insert . To create a different version of the table, click Retry . Click Good suggestion for a table that fulfills your request or Bad suggestion for a table that does not meet your needs. When you’re finished, click Insert . Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated. Was this helpful? Learn how to print Learning Center guides, save them as PDFs, or customize them for your organization.