Modified on Tue, 22 Dec 2020 at 09:30 AM

" "

Create and simultaneously edit spreadsheets with your team, right in your browser. Analyze data with charts and filters, handle task lists, create project plans, and much more. All changes are saved automatically.

1. Customize your spreadsheet and data.

" "

Note: To improve compatibility with Microsoft Excel keyboard shortcuts, you can override browser shortcuts.

Format a sheet, including how data is presented, such as adding borders to cells and formatting data as currency

2. Work with rows, columns, and cells.

" "

Add rows, columns, and cells:

  1. Select the row, column, or cell near where you want to add your new entry.
  2. Right-click the highlighted row, column, or celland thenInsertand thenchoose where to insert the new entry.

Delete, clear, or hide rows and columns: Right-click the row number or column letterand thenDeleteClear, or Hide.

Delete cells: Select the cells and right-clickand thenDelete cellsand thenShift left or Shift up.

Move rows or columns: Select the row number or column letter and drag it to a new location.

Move cells:

  1. Select the cells.
  2. Point your cursor to the top of the selected cells until a hand appears.
  3. Drag the cells to a new location.

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 Viewand thenFreeze and choose an option.

Options 1 through 5 mapped out on a sheet

3. Click Share to share your spreadsheet and then choose what collaborators can do. They'll also receive an email notification.

" "

 Share or unshareEdit content directly

Add comments


4. Collaborate with your team in real time." "

Share with your team. Chat with those viewing the sheet. Open comments thread and insert comments.

5. Create different versions and copies of your spreadsheet.

" "

Make a copy—Create a duplicate of your spreadsheet. This is a great way to create templates.

Download as—Download your spreadsheet in other formats, such as Excel or PDF.

Email as attachment—Email a copy of your spreadsheet.

Version history—See all the changes you and others have made to the spreadsheet or revert to earlier versions.

Publish to the web—Publish a copy of your spreadsheet as a webpage or embed your spreadsheet in a website.

In the menu, under "Find," find various options, such as "Publish to the web"

6. Work with functions.

" "

Your most important Excel functions exist in Sheets, too. Here’s a few of the things you can do.


Statistical   Returns the numerical average value in a dataset, ignoring text.


Statistical  Returns the average of a range that depends upon multiple criteria.


Lookup  Returns an element from a list of choices based on index.


Statistical  Returns the count of the number of numeric values in a dataset.


Statistical  Returns a conditional count across a range.


Date  Converts a provided year, month, and day into a date.


Text  Returns the position at which a string is first found within text.


Text  Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings.


Logical  Returns one value if a logical expression is true and another if it is false.


Lookup  Returns the content of a cell, specified by row and column offset.


Math  Rounds a number down to the nearest integer that’s less than or equal to it.


Lookup  Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column.


Lookup  Returns the relative position of an item in a range that matches a specified value.


Statistical  Returns the maximum value in a numeric dataset.


Statistical  Returns the minimum value in a numeric dataset.


Date  Returns the current date and time as a date value.


Math  Rounds a number to a certain number of decimal places according to standard rules.


Math  Returns the sum of a series of numbers and/or cells.


Math  Returns a conditional sum across a range.


Date  Returns the current date as a date value.


Lookup  Searches down the first column of a range for a key and returns the value of a specified cell in the row found.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article