Or, go to https://www. google. com/sheets/about/ and click Go to Sheets. Or, click the 9-dot grid button in the upper-right corner of https://www. google. com/, Gmail, or any Google web app. Select Sheets from the menu.

Create new spreadsheet opens a blank spreadsheet. Choose template opens the template gallery, where you can choose a premade layout that fits your spreadsheet needs. You can also open a new spreadsheet from Google Drive by clicking the New button and selecting Google Sheets.

Alternatively, click New in Google Drive, then File upload.

The . XLSX icon next to the title in the Google Sheets editor indicates that you’re working on an Excel file. If there’s a red dot notification on this icon, there may be a compatibility issue.

The . XLSX icon next to the title in the Google Sheets editor indicates that you’re working on an Excel file. If there’s a red dot notification on this icon, there may be a compatibility issue.

By default, there will be 26 columns (A to Z) and 1000 rows. Add more rows by scrolling to the bottom, entering in an amount next to “more rows at bottom,” and clicking Add. After adding in your data, you can search through the sheet if you’re looking for something specific.

You can add a new column or row to a specific location by selecting any cell in the row/column and clicking the Insert tab. You’ll see options to insert rows or columns above or below and to the right or left of the selected cell.

You can also use the toolbar above the formula box to make formatting changes to a range of cells. When selecting multiple cells (horizontally or vertically), you can merge them so that they span multiple rows or columns. To adjust the way numbers are formatted, go to the Number subsection in the Format tab. You can format numbers in a variety of ways. For example, selecting “Percent” will show numbers as percentages.

You can also use the toolbar above the formula box to make formatting changes to a range of cells. When selecting multiple cells (horizontally or vertically), you can merge them so that they span multiple rows or columns. To adjust the way numbers are formatted, go to the Number subsection in the Format tab. You can format numbers in a variety of ways. For example, selecting “Percent” will show numbers as percentages.

If your data have column headers, go to Sort range > Advanced range sorting options. Check the “Data has header row” box. When you click the Sort by drop-down menu, you can select a column by its header name. The A to Z and Z to A options are ascending and descending respectively. This sorts numbers low-to-high or high-to-low. Filtering your data is a great way to see temporary views of the dataset without changing the spreadsheet.

If your data have column headers, go to Sort range > Advanced range sorting options. Check the “Data has header row” box. When you click the Sort by drop-down menu, you can select a column by its header name. The A to Z and Z to A options are ascending and descending respectively. This sorts numbers low-to-high or high-to-low. Filtering your data is a great way to see temporary views of the dataset without changing the spreadsheet.

See our guide on creating graphs in Sheets for more detailed information!

See our guide on creating graphs in Sheets for more detailed information!

1 row or 2 rows will freeze the first 1 or 2 rows. 1 column or 2 columns will freeze the first 1 or 2 columns. To freeze more rows and columns, select the cell that you want to freeze up to. Then, select Up to row NUMBER or Up to column LETTER.

1 row or 2 rows will freeze the first 1 or 2 rows. 1 column or 2 columns will freeze the first 1 or 2 columns. To freeze more rows and columns, select the cell that you want to freeze up to. Then, select Up to row NUMBER or Up to column LETTER.

Google Sheets offers most of the same functions found in Microsoft Excel, so those experienced with Excel should find Sheets to be pretty familiar. Advanced users can create their own functions using Google Apps Script. For example, you could create a simple script to add the time and date automatically. Here are a few common Google Sheets functions: IF lets you return a specified value by evaluating a logical expression. This works similarly to using If-Else in Excel. VLOOKUP searches a column for a key value, then returns a cell value in a specific column to the right of the search range. (Check out our Excel guide for this function). SUM adds multiple cell values together. (Same as SUM in Excel). ABS will give you the absolute value of a number. FLOOR rounds a number value down to the closest integer. NPV returns the net present value for an investment given periodic cash flows.

Google Sheets offers most of the same functions found in Microsoft Excel, so those experienced with Excel should find Sheets to be pretty familiar. Advanced users can create their own functions using Google Apps Script. For example, you could create a simple script to add the time and date automatically. Here are a few common Google Sheets functions: IF lets you return a specified value by evaluating a logical expression. This works similarly to using If-Else in Excel. VLOOKUP searches a column for a key value, then returns a cell value in a specific column to the right of the search range. (Check out our Excel guide for this function). SUM adds multiple cell values together. (Same as SUM in Excel). ABS will give you the absolute value of a number. FLOOR rounds a number value down to the closest integer. NPV returns the net present value for an investment given periodic cash flows.

Google Sheets offers most of the same functions found in Microsoft Excel, so those experienced with Excel should find Sheets to be pretty familiar. Advanced users can create their own functions using Google Apps Script. For example, you could create a simple script to add the time and date automatically. Here are a few common Google Sheets functions: IF lets you return a specified value by evaluating a logical expression. This works similarly to using If-Else in Excel. VLOOKUP searches a column for a key value, then returns a cell value in a specific column to the right of the search range. (Check out our Excel guide for this function). SUM adds multiple cell values together. (Same as SUM in Excel). ABS will give you the absolute value of a number. FLOOR rounds a number value down to the closest integer. NPV returns the net present value for an investment given periodic cash flows.

Show common keyboard shortcuts — Ctrl + / Select column — Ctrl + Space Select row — Shift + Space Fill down — Ctrl + d Fill right — Ctrl + r Copy, cut, and paste — Ctrl + c, Ctrl + x, and Ctrl + v Move to beginning of sheet — Ctrl + Home Move to beginning or end of a range — Ctrl + Up/Down/Left/Right Arrow

Show common keyboard shortcuts — Cmd + / Select column — Ctrl + Space Select row — Shift + Space Fill down — Cmd + d Fill right — Cmd + r Copy, cut, and paste — Cmd + c, Cmd + x, and Cmd + v Move to beginning of sheet — Cmd + Fn + Left Arrow Move to beginning or end of a range — Cmd + Up/Down/Left/Right Arrow

Sharing a sheet with some means that they can view, comment on, or edit the file directly. There’s also an option to create a shareable link that you can send to people separately.

Sharing a sheet with some means that they can view, comment on, or edit the file directly. There’s also an option to create a shareable link that you can send to people separately.