Click the Format button in the Cells group, put your cursor over Hide & Unhide, and pick an option in the pop-out menu. To quickly hide a column or row, right-click it and pick Hide in the shortcut menu.Īlternatively, if you happen to be on the Home tab, you can also use the ribbon to hide columns or rows. By hiding those columns in between, you can move among those you need much faster. You may have several columns, for example, but are only working with a couple that are far apart like columns A and K. Hide and Unhide Columns and Rows in ExcelĪnother helpful way to work with columns and rows is to hide those you don’t need at the moment. To unfreeze, click Freeze Panes > Unfreeze Panes on Windows and the Unfreeze Panes button in the ribbon on Mac. And when you scroll down or sideways, the column or row will remain in view. You’ll notice a thin border appear for the row or column you freeze. So just click Freeze Top Row or Freeze First Column, or both if you like. On Mac, you have buttons for each Freeze option. On Windows, click Freeze Panes in the ribbon and choose Freeze Top Row or Freeze First Column. In your Excel spreadsheet, select the View tab. This is super handy for heavy data entry tasks. You can freeze the top row or the first column to keep it in view when you scroll. If you have a lengthy spreadsheet or one that covers many columns, freezing can help. Freeze and Unfreeze Columns and Rows in Excel
![how do you freeze multiple panes in excel how do you freeze multiple panes in excel](https://yodalearning.com/wp-content/uploads/2017/07/freeze-panes-excel.png)
#HOW DO YOU FREEZE MULTIPLE PANES IN EXCEL HOW TO#
Here, we’ll show you how to do all three.
![how do you freeze multiple panes in excel how do you freeze multiple panes in excel](https://www.tutoraspire.com/wp-content/static/ms/excel/images/freeze-panes-in-excel.png)
You can freeze, hide, and group the columns and rows in Excel to give you a better view of your data.