Main content

Alert message



You can change the height of a row or width of a column in a spreadsheet.

  1. Open a spreadsheet.
  2. Click or touch the edge of the header for the row or column.
  3. Drag the edge of the header to the size you want.

Resize multiple rows or columns

On a computer, you can also resize more than one row or column at a time.

  1. Open a spreadsheet.
  2. Click on the header for the first row or column and drag your cursor to expand your selection.
  3. Right-click on the selection and choose Resize columns (or Resize rows).
  4. Change the size in the box that appears.
  5. Click OK.

NOTE: There is a known issue where the row height is automatically changed in Google Sheets after a character has been deleted. This article addresses that issue:


Double-clicking inside of a cell will permit you to select specific text within that cell. Once selected, click the 'bold' ('B') icon in the toolbar or, using your keyboard, type CTRL+B. Press 'ENTER' or click in another cell to see the change.


Selecting the table or cells and clicking on the 'Borders' icon in the toolbar will permit you to select a border color and border style (solid, dashed, dotted) but will not permit you to change the thickness of the border at this time.



You can import a spreadsheet in any of these file formats:

  • .xls (if newer than Microsoft® Office 95)
  • .xlsx
  • .xlsm
  • .xlt
  • .xltx
  • .xltm
  • .ods
  • .csv
  • .txt
  • .tsv
  • .tab

Password-protected files cannot be imported.

To import a spreadsheet, select File > Import.

Choose the file you'd like to upload, and select one available import options below. Note: Not all file types will have all six options.

  • Create new spreadsheet: This option creates a new Google spreadsheet from your imported file in a new browser tab.
  • Insert new sheet(s): This option adds new sheets to your existing spreadsheet containing the data in your imported file.
  • Replace spreadsheet: This option replaces your existing spreadsheet with the data in your imported file.
  • Replace current sheet: This option replaces the current sheet with the imported data. Formatting and data previously on this sheet is replaced.
  • Append rows to current sheet: This option adds the imported data to the row after the last row with any data in it on your current sheet. Your existing data will remain intact.
  • Replace data starting at selected cell: This option pastes the imported data in a range of cells you have selected. It will replace any data that was previously on the sheet where the imported data has been pasted, but preserves existing data everywhere else.

If you're importing a plain text file like .csv or .txt, you'll have the option to select a separator character, like a comma or tab, or to choose a customized separator character.