Click on the View tab at the top and select the Freeze Panes command. This will create a dropdown menu. From the options listed, select Freeze Top Row. This will freeze the first row, no matter what row you happen to have currently selected.
How do I freeze multiple rows in Excel 2019?
Freeze columns and rows
- Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
- Select View > Freeze Panes > Freeze Panes.
How do I freeze the top two rows in Excel 2010?
To freeze rows:
- Select the row below the rows you want frozen. For example, if you want rows 1 and 2 to always appear at the top of the worksheet even as you scroll, then select row 3. …
- Click the View tab.
- Click the Freeze Panes command. …
- Select Freeze Panes. …
- A black line appears below the rows that are frozen in place.
How do I freeze the top 2 rows in Excel 2007?
In the Window group of the View tab, choose Freeze PanesFreeze Panes. A thin black line separates the sections. As you scroll down and to the right, notice that the columns above and rows to the left of the cell cursor remain fixed. Keep titles visible by freezing the panes.
Why can’t I freeze the top row in Excel?
To enable the Freeze Panes command again, you must choose either the Normal or Page Break Preview commands. You’ll have to manually restore any frozen panes that you lost when you chose Page Layout view. Figure 1: Excel’s Page Layout command disables the Freeze Panes command and unfreezes rows/columns, as well.
How do you freeze top row?
How to freeze the top row in Excel
- Scroll your spreadsheet until the row you want to lock in place is the first row visible under the row of letters.
- In the menu, click View.
- In the ribbon, click Freeze Panes and then click Freeze Top Row.
How do I freeze multiple non consecutive rows in Excel?
Select the row below the row(s) you wish to freeze. Click the View tab on the Ribbon. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. Your selection will be frozen in place.
How do I freeze multiple rows in sheets?
Freeze or unfreeze rows or columns
- On your computer, open a spreadsheet in Google Sheets.
- Select a row or column you want to freeze or unfreeze.
- At the top, click View. Freeze.
- Select how many rows or columns to freeze.
How do I freeze multiple panes in Excel 365?
Freeze columns and rows to keep them in view while you scroll through your data.
- Select the cell below the rows, and to the right of the columns you want to freeze.
- Click View > Freeze Panes > Freeze Panes.
How do I freeze the top row in Excel?
To freeze the top row or first column:
- From the View tab, Windows Group, click the Freeze Panes drop down arrow.
- Select either Freeze Top Row or Freeze First Column.
- Excel inserts a thin line to show you where the frozen pane begins.
How do I freeze both the top row and first column in Excel 2010?
To freeze the first row and column, open your Excel spreadsheet. Select cell B2. Then select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. Then click on the Freeze Panes option in the popup menu.
How do you freeze panes above the left of the cell?
In the Window group of the View tab, choose Freeze PanesFreeze Panes. A thin black line separates the sections. As you scroll down and to the right, notice that the columns above and rows to the left of the cell cursor remain fixed. Keep titles visible by freezing the panes.
How do I freeze both top row and first column?
To freeze the top row and the first column at the same time, click the View tab > Freeze Panes > Freeze Panes.
How do I freeze both the top row and first column in Excel 2007?
To freeze the first row and column, open your Excel spreadsheet. Select cell B2. Then select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. Then click on the Freeze Panes option in the popup menu.
How do I freeze the first two columns in Excel?
Under view, browse to find freeze panes. Click on freeze panes to reveal the list of options, select the first option which is freeze panes. This option will freeze or rather lock the two columns in a way that they will always remain visible even after scrolling down.
How do you freeze a selected column in Excel?
To freeze columns:
- Select the column to the right of the column(s) you want to freeze. …
- Click the View tab on the Ribbon.
- Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. …
- The column will be frozen in place, as indicated by the gray line.
How do I freeze a row in Excel on a Mac?
Freeze the top row
- Open the document you want to work on in Excel.
- Switch to the View tab in your Ribbon interface, located on top of the Excel window.
- Click on the Freeze Top Row icon. …
- The freeze is indicated by the bottom line of the row becoming darker than other lines, showing that the row is currently frozen.
How do I keep column headers when scrolling in Excel?
How to keep column header viewing when scrolling in Excel?
- Enable the worksheet you need to keep column header viewing, and click View > Freeze Panes > Freeze Top Row.
- If you want to unfreeze the column headers, just click View > Freeze Panes > Unfreeze Panes.
How do I freeze merged cells in Excel?
How to freeze rows and columns in Excel
- Select a cell below the last row and to the right of the last column you’d like to freeze.
- On the View tab, click Freeze Panes > Freeze Panes.
How do I lock cells in sheets?
Lock Specific Cells In Google Sheets
- Right-click on the cell that you want to lock.
- Click on Protect range option.
- In the ‘Protected Sheets and ranges’ pane that opens up on the right, click on ‘Add a sheet or range’
- [Optional] Enter a description for the cell you’re locking.
How do I freeze the first 3 columns in Excel?
How to freeze multiple columns in Excel
- Select the column to the right of the last column you want to freeze. For example, if you want to freeze the first 3 columns (A – C), select the entire column D or cell D1. …
- And now, follow the already familiar path, i.e View tab > Freeze panes > and again Freeze panes.
How do I freeze the top row in Word?
Freeze Rows in Word Table
- Select rows which you would like to freeze their size in the table, right click and choose Table Properties.
- Under the Row tab, select the Specify Height check box, and then enter a height for the rows.