Formats numbers with a decimal separator. The spreadsheet locale determines which character is used as the decimal separator for all numeric values. When you press the decimal key on a numeric keypad, the spreadsheet locale also determines the character inserted.,(comma) Formats numbers with a thousands separator. / Formats numbers as a fraction. %

To format numbers, dates, or currencies in a spreadsheet, follow these steps: On your Android phone or tablet, open a spreadsheet in the Google Sheets app. Tap a cell or range of cells. Tap Format . Tap an option from the list. The format will be applied to your selected cells. The date, time, and currency options are based on the spreadsheet ...

Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and work with other people. DOWNLOAD CHEAT SHEET. Step 1: Create a spreadsheet. To create a new spreadsheet: Open the Sheets home screen at sheets.google.com. Click New . This will create and open your new spreadsheet.

Format numbers, dates and currencies. To format or change the format of numbers, dates or currencies in a spreadsheet: On your computer, open a spreadsheet in Google Sheets. Select the range of cells that you'd like to format or modify. Click Format Number. Select the format to apply to the range of cells. Custom formatting of numbers, dates ...

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.

To get an example spreadsheet and follow along with the video, click “Make a Copy” below. Make a copy. Sort data in alphabetical or numerical order. On your computer, open a spreadsheet in Google Sheets. Highlight the group of cells you'd like to sort. If your sheet includes a header row, freeze the first row.

You can use autofill to create a series of numbers, letters, or dates in Google Sheets. Use autofill to complete a series. On your computer, open a spreadsheet in Google Sheets. In a column or row, enter text, numbers, or dates in at least two cells next to each other. Highlight the cells. You’ll see a small blue box in the lower right corner.

Open a spreadsheet in Google Sheets. Click a cell, then drag your mouse across nearby cells you want to select, or hold ⌘ on a Mac or Ctrl on Windows and click another cell. To format text or numbers in a cell, use the options in the toolbar at the top. Format your data

Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and work with other people. DOWNLOAD CHEAT SHEET. Step 1: Create a spreadsheet. To create a new spreadsheet: Open the Sheets home screen at sheets.google.com. Click New . This will create and open your new spreadsheet.

Open a spreadsheet in Google Sheets. In the menu bar, click Insert Tables. In the column header, select a column you want to group by view. Beside the heading name, click the Down arrow Group by column. In each category’s row, click the Down arrow . Select an aggregation type.