Format rows, columns in Google Sheets

Format rows, columns in Google Sheets



  1. Add rows, columns, and cells—Select a cell or block of cells. Then, on the menu bar, click Insert and choose where to add the row, column, or cells.

  2. Delete or hide rows and columns—Right-click the row number or column letter and select Delete or Hide.
  3. Delete a cell or a block of cells—Select the cells you want to delete. Click Edit > Delete cells and shift up, or Edit > Delete cells and shift left.
  4. Move rows and columns—Click the row number or column letter to select it. Then, drag it to a new location.
  5. Freeze header rows and columns—Keep some data in the same place as you scroll through the rest of your spreadsheet. On the menu bar, click View > Freeze and choose an option.

None

    • Related Articles

    • Functions in Google Sheets

      Work with functions Your most important Excel functions exist in Sheets, too. Here’s a few of the things you can do. AVERAGE Statistical   Returns the numerical average value in a dataset, ignoring text. AVERAGEIFS Statistical  Returns the average of ...

    • Customize/format Sheets

      Customize your spreadsheet and data. Note: To improve compatibility with Excel keyboard shortcuts, you can override browser shortcuts.

    • PS Learning: Attach Google Docs, Sheets, and/or Slides to PSL content blocks

      Go to the add content block from any page and choose Google Drive. Then select the file or create the Google file right inside of PS Learning.

    • Create charts in Google Sheets

      Add charts In a spreadsheet, highlight the range of data you want to create a chart for. Click Insert > Chart. (Optional) In the editor, change the chart type and other aspects. (Optional) In the editor, to tailor axes, styles, titles, and more, ...

    • Embed Google Drive onto PS Learning Page

      Select Add Content Block and choose Google Drive to embed Documents, Sheets, Presentations, Drawings and other resources from your Google Drive. Collaboration tools can be enabled for Google Documents and Sheets.   Please note: This feature is only ...