Share via

add header to each column

Anonymous
2023-08-23T18:05:01+00:00

I'm a newbie to detailed excel sheets.

I want to add a header to each column without messing up the numbers on the side.

Right now, my count is off by one, bc my header takes up the #1 cell in each column

Microsoft 365 and Office | Excel | For business | Windows

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

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rich~M 20,370 Reputation points Volunteer Moderator
    2023-08-24T14:53:29+00:00

    Hi Barbara. I am an Excel user like you.

    I have had a similar issue where the row numbers and the #'s on the rows don't line up and it can be very confusing. As Snow Lu suggested, add a column that is numbered for your data.

    You can then go to the View ribbon and un-check Headings in the Show section. Excel will then not display the row numbers, so you don't see both at the same time. NOTE: This will also hide the Column letters. You can then re-check the box at any time to bring them back when you need to see them.

    Reply if you have additional questions or information. Please mark this reply as answered if this solves your question.

    Rich~M

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-08-24T14:28:18+00:00

    This is by design. You may add a help column to recalculate the count.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2023-08-24T14:18:28+00:00

    Row #1 is my heading ; NAME -but by doing that, it messes up my count of the names. It gives me 27, when it's 26.

    How do I give each column a heading without taking up Row #1?

    0 comments
  4. Anonymous
    2023-08-24T01:35:58+00:00

    Could you share us a screenshot of your issue? Then we may give suggestions on it.

    0 comments