How to Freeze or Hide Columns and Rows in Google Sheets

How to Freeze or Hide Columns and Rows in Google Sheets

All

Linux Articles / All 14 Views comments

The Google Sheets logo

The higher the variety of rows and columns in your Google Sheets spreadsheet, the extra unwieldy it may well turn into. Freezing or hiding rows and columns could make your spreadsheet simpler to learn and navigate. Right here’s how.

Freeze Columns and Rows in Google Sheets

In the event you freeze columns or rows in Google Sheets, it locks them into place. This can be a good choice to be used with data-heavy spreadsheets, the place you'll be able to freeze header rows or columns to make it simpler to learn your knowledge.

Usually, you’ll need to freeze solely the primary row or column, however you possibly can freeze rows or columns instantly after the primary. To start, choose a cell within the column or row you’re trying to freeze after which click on View > Freeze from the highest menu.

Click on “1 Column” or “1 Row” to freeze the highest column A or row 1. Alternatively, click on “2 Columns” or “2 Rows” to freeze the primary two columns or rows.

You can too click on “As much as Present Column” or “As much as Present Row” to freeze the columns or rows as much as your chosen cell.

To freeze rows or columns in Google Sheets, click View > Freeze

Once you transfer round your spreadsheet, your frozen cells will stay in place so that you can simply refer again to.

A thicker, grey cell border will seem subsequent to a frozen column or row to make the border between your frozen and unfrozen cells clear.

An example of frozen columns and rows in Google Sheets

If you wish to take away frozen columns or rows, click on View > Frozen and choose “No Rows” or “No Columns” to return these cells to regular.

To unfreeze a column or row in Google Sheets, click View > Freeze then click No Rows or No Columns

Disguise Columns and Rows in Google Sheets

If you wish to briefly cover sure rows or columns, however don’t need to take away them out of your Google Sheets spreadsheet utterly, you'll be able to disguise them as an alternative.

Cover Google Sheets Columns

To cover a column, right-click the column header on your chosen column. Within the menu that seems, click on the “Disguise Column” button.

Right click a column header, then click Hide Column to hide that column in Google Sheets

Your column will then disappear from view, with arrows showing within the column headers on both aspect of your hidden column.

Click the opposite arrows to display a hidden column in Google Sheets

Clicking on these arrows will expose the column and return it to regular. Alternatively, you need to use keyboard shortcuts in Google Sheets to cover your column as an alternative.

RELATED: All the Best Google Sheets Keyboard Shortcuts

Click on the column header to pick it after which press Ctrl+Alt+zero in your keyboard to cover it as an alternative. Choosing the columns on both aspect of your hidden row after which urgent Ctrl+Shift+zero in your keyboard will unhide your column afterward.

Cover Google Sheets Rows

Just like the method above, if you wish to cover a row in Google Sheets, right-click on the row header for the row you’re trying to cover.

Within the menu that seems, click on the “Cover Row” button.

To hide a Google Sheets row, right-click the row header, then click Hide Row

Your chosen row will disappear, with reverse arrows showing within the header rows on both aspect.

Click the opposite arrows to display a hidden row in Google Sheets

Click on on these arrows to show your hidden row and return it to regular at any level.

When you’d want to make use of a keyboard shortcut, click on the row header to pick it after which press Ctrl+Alt+9 to cover the row as an alternative. Choose the rows on both aspect of your hidden row and press Ctrl+Shift+9 in your keyboard to unhide it afterward.

Comments