Hide and Unhide Function

M

Mark4u

When I hide a column or a row and than I click unhide it doesn't unhide
itself. I tried highlighting both columns at the same time to the sides of
the hidden rows and than right clicking and clicking unhide but it still
doesn't work. What is going on? How do I unhide my hidden rows?
 
R

RobN

Could it be that you've opened a workbook created in a version prior to Vs
2007?

Anyway, if you click in the name box (left of the formula bar), and enter a
cell reference for the hidden column and press enter, eg B1 (if it's column
B that's hidden), and then check the column width (via Format>Column width),
you'll probably see it as 0. Simply change this to a greater value, say 10.

Rob
 
M

Mike H

Hi,

You don't select columns either side of the hidden one you select the column
to the left of the hidden column and drag over to a column to the right. That
way you have the hidden column selected. Then you click unhide.

Mike
 
M

Mark4u

Mike,

Thanks a bundle for your help, that was great. It saved me a ton of time. I
really appreciate it.
 
M

Mark4u

Rob,

Thanks a lot for your help, I really appreciate it. I wouldn't have ever
thought of that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unhide a row 1
Excel 2007 - Hide & Unhide Columns/Rows 8
How to unhide all? 4
CAN'T UNHIDE COLUMNS 7
Unhide Column 5
Workbook hiding itself when it is opened! 0
Hide Unhide Buttons 3
hide columns with a "+" 2

Top