How do you keep the first column in Excel visible?

To freeze the top row or first column:

  1. From the View tab, Windows Group, click the Freeze Panes drop down arrow.
  2. Select either Freeze Top Row or Freeze First Column.
  3. Excel inserts a thin line to show you where the frozen pane begins.

How do I make one column in sheets always visible?

To pin data in the same place and see it when you scroll, you can freeze rows or columns.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a row or column you want to freeze or unfreeze.
  3. At the top, click View. Freeze.
  4. Select how many rows or columns to freeze.

How do I keep the first two columns visible in Excel?

For example, if you want to lock the first two columns and keep them always visible, you just need to select the adjacent column (the third one), and then click View > Freeze Panes > Freeze Panes. Now the first two columns are always visible while scrolling to right.

How do I unhide the first column in Excel 2007?

Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide & Unhide > Unhide Columns. Now you should be able to see column A in your Excel spreadsheet.

How do I make the top column always visible in Excel?

Freeze columns and rows

  1. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
  2. Select View > Freeze Panes > Freeze Panes.

How do I keep Line 1 visible in Excel?

In Excel, you can go to Freeze Panes to freeze first row.

  1. Active the worksheet you want to keep its first row, and then click View > Freeze Panes > Freeze Top Row.
  2. Tip: If you want to cancel the freezing, click View > Freeze Panes > Unfreeze Panes.

How do I make a cell always visible in Excel?

On the menu bar, select on the view button and browse around until you see the freeze panes command. Click on freeze panes to reveal the list of options. Click on freeze panes to make your row always visible in the excel sheet.

How do I keep a row visible in Excel while scrolling?

How to freeze the top row in Excel

  1. Scroll your spreadsheet until the row you want to lock in place is the first row visible under the row of letters.
  2. In the menu, click “View.”
  3. In the ribbon, click “Freeze Panes” and then click “Freeze Top Row.”

Can you lock columns in Excel?

Press the Keyboard Shortcut Ctrl + A to select all the cells of the sheet. Right click and choose Format cells. Go to the Protection tab and uncheck Locked option and click Ok. Now select only the cells or columns, rows that you want to protect.

How do I unhide column 1 in Excel?

On the Home tab, in the Cells group, click Format. Do one of the following: Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns.

How do I unhide the first row in Excel 2007?

Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide & Unhide > Unhide Rows. Row 1 should now be visible.

How to keep first row always visible in Excel?

Enable the workbook you want to keep 1st row visible across whole workbook, and select Cell A2, and click Enterprise > Worksheet > Freeze panes multiple worksheets. See screenshot: Then you can see every first row of all worksheets has been frozen. Tip: To cancel the freezing, click Enterprise > Worksheet > Unfreeze panes multiple worksheets.

How to lock specific columns always visible in a sheet?

For example, if you want to lock the first two columns and keep them always visible, you just need to select the adjacent column (the third one), and then click View > Freeze Panes > Freeze Panes. Now the first two columns are always visible while scrolling to right. Freeze top row and Freeze first column

How to freeze first row and first column in Excel?

MS Excel 2007: Freeze first row and first column. 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. Now when you scroll, you should still continue to see row 1 and column A.

How to keep the headings visible in Excel?

Press Ctrl + Hometo move to cell A1 (the top of your worksheet). Your headings must be visible prior to moving to the next step. On the View tab, in the Window group, click Freeze Panes, Freeze Top Row. A black line displays under the Top Row to indicate that it is frozen.