We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Hidden columns in excel

Options
Hi

I hve hidden a column in excel and it won't unhide it through the formet, column bit, my dad has done the same?

Any suggestions on how to show it!

Carli x

Comments

  • John_Gray
    John_Gray Posts: 5,843 Forumite
    Part of the Furniture 1,000 Posts Name Dropper Photogenic
    Have you worked through the suggestions found by Googling for Excel column unhide? Worth a try!

    John
  • Hillfly
    Hillfly Posts: 672 Forumite
    Part of the Furniture Combo Breaker
    2 things you can do.

    1) Select the columns either side of the hidden one and then right click and select unhide.

    2) Select the columns either side of the hidden one and then right click and select Column width. Set the value to say 8 and it should appear.
    Fortune's always hiding, I've looked everywhere......
  • Hillfly
    Hillfly Posts: 672 Forumite
    Part of the Furniture Combo Breaker
    John_Gray wrote:
    Have you worked through the suggestions found by Googling for Excel column unhide? Worth a try!

    John


    Amen to that!
    Fortune's always hiding, I've looked everywhere......
  • Murtle
    Murtle Posts: 4,154 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker
    If it's the first column click the button in the top left corner that highlights the whole spreadsheet and then right click you get the option to unhide!
  • esuhl
    esuhl Posts: 9,409 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    I seem to remember that there's a "veryhidden" attribute in VBA that can't be restored through the normal user interface.

    If you've been using the VBA programming language or have installed any add-ons to Excel, maybe that's the cause...?
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.9K Banking & Borrowing
  • 253.1K Reduce Debt & Boost Income
  • 453.5K Spending & Discounts
  • 243.9K Work, Benefits & Business
  • 598.8K Mortgages, Homes & Bills
  • 176.9K Life & Family
  • 257.2K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.