Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

View Hidden Excel Columns

Posted on 2014-11-12
Last Modified: 2014-11-14
See attached (sent to me by someone else). Note there is column A, then C.

I want to see B.

I seem to recall in prior versions of Excel if you move the mouse over the column line (between A & C), it would change to a double vertical bar and you could drag them apart. Not now.

Excel version 14.0.7128.5000 / part of Office 2010.

How can I see B?
Question by:Richard Korts
  • 2
  • 2
  • 2
LVL 15

Accepted Solution

Haris Djulic earned 500 total points
ID: 40438755

you just select columns A and C and the right click and select Unhide, this will reveal the columns B..
LVL 26

Expert Comment

ID: 40438758
select from A to C columns.  then right click and on the menu select unhide columns
LVL 26

Expert Comment

ID: 40438760
Haris ,   few seconds difference
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

LVL 15

Expert Comment

by:Haris Djulic
ID: 40438763
Professor it is almost a minute :)
LVL 12

Expert Comment

ID: 40438972
Hi rkorts,

What happens when you move your mouse slightly to the right of the column line between the A & C headings?  On my Excel 2010 this is when the vertical bar becomes double.  If you're pointing at the column line, it will be single.
When it's double, you should be able to drag right to reveal column B.
Works for me.

Let me know what happens for you, please.

LVL 12

Expert Comment

ID: 40443580
Does my suggestion above work for you, rkorts?

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel Lookup - True if return at least one match 9 44
Turn date into age 17 32
Preserve formatting during mail merge using VBA 18 41
Conditional formatting excel 5 14
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question