Share via

I want to freeze my six column headings. I have clicked in differant cells beneath the row of column headings but nothing freezes and the row of column headings scrolls out of view.

Anonymous
2024-12-25T17:23:38+00:00

I want to freeze my suix column headings. I have clicked in different cells beneath the row of column headings, but nothing freezes, and the row of column headings scrolls upward out of view.

Microsoft 365 and Office | Word | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

6 answers

Sort by: Most helpful
  1. Jay Freedman 207.5K Reputation points Volunteer Moderator
    2024-12-27T19:00:09+00:00

    It shouldn't work that way.

    I have a workbook with six columns and a little over 300 rows. The first column is a sequence number, and the first row is the column headings. When I click in cell B2 and choose Freeze Panes the way I posted, the first column and the first row are both frozen. Here's a partial screenshot with row 175 as the first visible one and with the sheet scrolled to the right partway through column B:

    This is in desktop Excel of Microsoft 365 on Windows 11. I also opened the same file in Online Excel, and it behaved the same way. What version of Excel and operating system are you using?

    1 person found this answer helpful.
    0 comments No comments
  2. Jay Freedman 207.5K Reputation points Volunteer Moderator
    2024-12-27T00:47:11+00:00

    When you posted your question, you chose Word as the application instead of Excel. That's indicated at the top right under "Question Info". Doug was justified in assuming you're dealing with a table in Word.

    In Excel, to do what you want, click in the cell to the right of the column you want to freeze and the row below the column headings. Then click View > Freeze Panes > Freeze Panes.

    1 person found this answer helpful.
    0 comments No comments
  3. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2024-12-25T19:52:40+00:00

    While Excel has the ability to do that, Word does not.

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2024-12-27T17:56:31+00:00

    Thanks, Jay, for your reply. I did click in the cell to the right of the column I wanted to freeze and the row below the column headings. I then clicked View > Freeze Panes > Freeze Panes. However, nothing froze. The column headings ultimately scrolled upward and out of sight.

    Tim

    0 comments No comments
  5. Anonymous
    2024-12-26T22:47:02+00:00

    Thank you for your reply. I don't recall that I said, or implied, my columns were in Word. My columns are on an Excel spreadsheet. I am familiar with freezing panes. However, nothing happens when I click in the cell on the left and one row beneath the row of column headings and select freeze panes. I've tried simultaneously to freeze the row of column headings together with Column "A". And, I've tried to freeze only the row of column headings. In both cases nothing freezes.

    0 comments No comments