How to freeze panes in Excel | lynda.com tutorial
How to Freeze Cells in Excel
When you are using an Excel spreadsheet, you could potentially deal with thousands of cells. In order to keep some rows and columns visible while scrolling through the entirety of your sheet, you can freeze them in place. If you want to easily edit two parts of the spreadsheet at once, splitting your panes will make the task much easier.
Determine what you want frozen.Frozen cells will stay on the screen while you scroll through the rest of your spreadsheet. This is very useful if you want the column headers or row labels to be visible anywhere on the spreadsheet. You can only freeze whole rows or columns.
Click the "View" tab.Find the "Window" group. This contains the "Freeze Panes" button.
Freeze the top row.If your top row contains column headers and you want them to always be visible, you can freeze the top row. Click the "Freeze Panes" button and select "Freeze Top Row". A line will appear underneath the top row, and it will stay on the screen if you scroll down.
Freeze the leftmost column.If you have a lot of columns that you need to fill out and want to be able to see the identifier for each row, you can freeze the leftmost column. Click the "Freeze Panes" button and select "Freeze First Column". A line will appear to the right of the first column, and it will stay on screen if you scroll to the right.
Freeze columns and rows.You can freeze both columns and rows if you want them to stay on the screen. The frozen columns and rows must connect to the edge of the spreadsheet, but you can freeze multiple columns and rows at once.
- For example, you can freeze columns A and B, but you can't freeze just column B.
- To choose what you want frozen, select the column that you want to be the new upper corner, click the "Freeze Panes" button, and then select "Freeze Panes". Everything above and to the left of the cell will be frozen. For example, if you select cell C5, rows 1-4 will be frozen along with columns a and B.
Unfreeze your cells.If you want to return the spreadsheet to normal, click the "Freeze Panes" button and select "Unfreeze Panes". The frozen cells will be unlocked.
Decide what you want split.Splitting your panes allows you to scroll your separate sections individually. This is very useful for large spreadsheets that you need to manipulate several areas of at once.
- When splitting, you split from the right and from the top.
Drag the split bars.The split bars are small bars located at the top of the vertical scrollbar and the right of the horizontal scrollbar. Click and drag these bars to set your new split border. You can scroll the spreadsheet in each individual frame you create.
- Dragging split bars is no longer available in Office 2013. Instead, you can click the "Split" button in the "View" tab to create a default split that you can then click and drag to adjust.
Remove a split.If you want remove the split, double-click the split bar to make it disappear.
QuestionHow do I freeze the top two rows?wikiHow ContributorCommunity AnswerSelect the row directly under the rows you want to freeze (in this case, the third row). Go to View, Freeze Panes, and select "Freeze Panes." Everything above the row you have selected will be frozen.Thanks!
How to tree tracking system in Excel sheet?
How do I freeze a single cell in Excel?
How do I freeze both columns and rows?
Sources and Citations
In other languages:
Português: , Deutsch: , Русский: , Français: , Español: , Bahasa Indonesia: , Italiano:
Video: Microsoft Excel: How To Freeze Rows Or Columns
WATCH: You Need To See This Deleted Scene From Friends
How to Buy Barcode Scanners
It’s just mindless thuggary’
8 All-Natural Ways to Manage Morning Sickness
How to Get Your Softest SkinEver
How to Wash a Chest Binder
Adele’s Best Fashion Moments
Dos and Donts of Dog Grooming
9 Ways To Prevent A Headache And The Misery That Comes With It
Must-Know MRSA Facts