Text Returns the position at which a string is first found within text. Statistical Returns a conditional count across a range.ĭate Converts a provided year, month, and day into a date. Statistical Returns the count of the number of numeric values in a dataset. Lookup Returns an element from a list of choices based on index. Statistical Returns the average of a range that depends upon multiple criteria. Statistical Returns the numerical average value in a dataset, ignoring text. Your most important Excel functions exist in Sheets, too. Publish to the web-Publish a copy of your spreadsheet as a webpage or embed your spreadsheet in a website. Version history-See all the changes you and others have made to the spreadsheet or revert to earlier versions. This is a great way to create templates.ĭownload as-Download your spreadsheet in other formats, such as Excel or PDF.Įmail as attachment-Email a copy of your spreadsheet. Make a copy-Create a duplicate of your spreadsheet. They'll also receive an email notification.Ĭhat with other people viewing the spreadsheetĬreate different versions and copies of your spreadsheet. On the menu bar, click View Freeze and choose an option.Ĭlick Share to share your spreadsheet and then choose what collaborators can do.

Click Data Group rows or Group columns.įreeze header rows and columns: Keep a row or column in the same place as you scroll through your spreadsheet.

Point your cursor to the top of the selected cells until a hand appears.

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

Right-click the highlighted row, column, or cell Insert choose where to insert the new entry.ĭelete, clear, or hide rows and columns: Right-click the row number or column letter Delete, Clear, or Hide.ĭelete cells: Select the cells and right-click Delete cells Shift left or Shift up.Select the row, column, or cell near where you want to add your new entry.

Macbook pro cheat sheet