HomeApplicationOffice informationHow to Hide Rows on Google Sheets on PC or Mac

How to Hide Rows on Google Sheets on PC or Mac

Steps

  1. How to Hide Rows on Google Sheets on PC or Mac Picture 1
    Open Google Sheets in your internet browser. Type sheets.google.com in your browser's address bar, and hit ↵ Enter or ⏎ Return on your keyboard.
    1. If you're not automatically signed in to Google, enter your email and password to log in.
  2. How to Hide Rows on Google Sheets on PC or Mac Picture 2
    Click a spreadsheet. Find the spreadsheet you want to edit in the list of all your saved sheets, and open it.
  3. How to Hide Rows on Google Sheets on PC or Mac Picture 3
    Click the number label next to the row you want to hide. Find the number label on the left-hand side of the row you want to hide, and click it. This will select and highlight the entire row.
    1. If you want to hide multiple rows at once, hold down the ⇧ Shift key on your keyboard, and then click another row. This will select and highlight all the rows in the selected range.
  4. How to Hide Rows on Google Sheets on PC or Mac Picture 4
    Right-click the highlighted row. This will open your right-click menu in a drop-down box.
  5. How to Hide Rows on Google Sheets on PC or Mac Picture 5
    Select Hide row on the menu. This will collapse and hide the selected row from your spreadsheet. The data in it will not be deleted, but it won't show up on the sheet unless you unhide it.
    1. If you've selected multiple rows, this option will read as Hide rows and indicate the range of selected cells.
4 ★ | 13 Vote
rowclickhideselected

You should read it

May be interested

  • How to Make a Finance SpreadsheetPhoto of How to Make a Finance Spreadsheet
    spreadsheet software can be used to create a powerful personal finance management tool. the following instructions can be used to make a personal finance spreadsheet in microsoft excel or open office. simply use a comma to separate values...
  • How to Create an Excel Spreadsheet Without ExcelPhoto of How to Create an Excel Spreadsheet Without Excel
    there are numerous spreadsheet software programs that can serve as alternatives to microsoft excel, most of which are available for download from the internet at little or no cost. despite some differences in compatibility, available...
  • How to Do Cost Volume Profit AnalysisPhoto of How to Do Cost Volume Profit Analysis
    cost-volume-profit analysis is an important tool from cost accounting to help managers decide how many units to sell, answer questions about the product mix, set profit targets reasonably -- all in accord with a given product's cost...
  • How to Refer to Tables and Figures in a TextPhoto of How to Refer to Tables and Figures in a Text
    tables and figures can help you to simplify the information you are presenting in a paper. if you have performed long-term scientific research, tables and graphs are essential for showing the results of that research, as well as for...
  • How to Make a SpreadsheetPhoto of How to Make a Spreadsheet
    this wikihow teaches you how to create a data spreadsheet, which is a document that uses columns and rows to organize data. commonly used spreadsheet programs include microsoft excel, apple numbers, and google sheets. open microsoft excel....
  • How to Use Google SpreadsheetsPhoto of How to Use Google Spreadsheets
    on june 6, 2006, google released a spreadsheets product as a 'limited test' to a small number of users. that limited test stuck around, and google sheets is now widely used as a sub-feature of google docs. the product resembles a simple...

Office information