The greater the number of rows and columns in your Google Sheets spreadsheet, the more unwieldy it can become. Freezing or hiding rows and columns can make your spreadsheet easier to read and navigate. Here’s how.
Freeze Columns and Rows in Google Sheets
If you freeze columns or rows in Google Sheets, it locks them into place. This is a good option for use with data-heavy spreadsheets, where you can freeze header rows or columns to make it easier to read your data.
In most cases, you’ll want to freeze only the first row or column, but you can freeze rows or columns immediately after the first. To begin, select a cell in the column or row you’re looking to freeze and then click View > Freeze from the top menu.
Click “1 Column” or “1 Row” to freeze the top column A or row 1. Alternatively, click “2 Columns” or “2 Rows” to freeze the first two columns or rows.
You can also click “Up to Current Column” or “Up to Current Row” to freeze the columns or rows up to your selected cell.
When you move around your spreadsheet, your frozen cells will remain in place for you to easily refer back to.
A thicker, gray cell border will appear next to a frozen column or row to make the border between your frozen and unfrozen cells clear.
Read the remaining 20 paragraphs
from How-To Geek https://ift.tt/2Kj5DaK
No comments:
Post a Comment