At some point the the past I created a worksheet by copying and pasting data from another worksheet. I have formulas tied to the new worksheet and everything is working fine. When I recently looked at the columns and their data I noticed that Column A is not shown and it starts with Column B. I thought A was hidden but no matter what I try I can't show a column A in that worksheet. I assume that the worksheet doesn't start with column B and A is hidden somehow.
Any suggestions on how to fix this?
Missing column in Planmaker
Re: Missing column in Planmaker
If column A is hidden, you should see a small triangle at the top left corner of column B. Simply click on that triangle, and column A will become visible.
Alternatively, you can select column B, then press and hold the left mouse button while dragging it to the left as if you're selecting column A as well. After that, right-click and choose the 'Show' option.
For a visual guide, please refer to this screen recording, which explains both methods.
Alternatively, you can select column B, then press and hold the left mouse button while dragging it to the left as if you're selecting column A as well. After that, right-click and choose the 'Show' option.
For a visual guide, please refer to this screen recording, which explains both methods.
Reveal hidden column
I have a worksheet that starts with column B and haven't been able to find a way to reveal column A. I've tried a number of steps from he help file but have been unsuccessful. Anyone know how to show a hidden column?
Re: Missing column in Planmaker
Thank you. Second option worked great.
Re: Reveal hidden column
Sorry about the duplicate post. I'd forgotten I'd already asked and someone answered but didn't see the notification until after I clicked Submit.
I didn't think too much about second post because when I clicked on Submit nothing seemed to happened so thought something went wrong and just closed my browser. Obviously it did post.
I didn't think too much about second post because when I clicked on Submit nothing seemed to happened so thought something went wrong and just closed my browser. Obviously it did post.
Re: Missing column in Planmaker
I have fixed it now by merging both posts.