Excel unhide rows problem

  smudge101 09:21 07 Sep 05
Locked

Help!!

I have been sent a spreadsheet in which there are some 7000 hidden rows that I need access to. I have tried to unhide them without success.
Any ideas would be welcome.

  dave_and_confused 09:31 07 Sep 05

What happens when you goto the Windows Menu and select Unhide... ?

  Eric10 09:38 07 Sep 05

Have you tried selecting the rows either side of the hidden ones, right-click and choose Unhide.

  smudge101 09:41 07 Sep 05

Thanks for the fast responses.
I have tried highlighting the rows either side but nothing happens when I click unhide. There is a very brief flicker and that is all.
I have never come across anything quite like this.
I know it is not specific to my computer as the person who sent the file had the same problem.

  scotty 09:43 07 Sep 05

Try Format|Rows|Unhide

If that does not work, you can select all cells and copy them. Open a new spreadsheet and use Paste Special and select Formula then OK. This will copy the info from the cells without format settings.

  smudge101 10:02 07 Sep 05

Esp. thanks to Scotty.
I followed your advice about the paste special and now have access to all the rows. Hust got to tidy the sheet up a bit first.

Thanks again!!

  Simsy 10:09 07 Sep 05

is it possible that, on the original, rather than being hidden the columns have been set to have a width of zero?

Regards,

Simsy

  Simsy 10:10 07 Sep 05

I meant Rows, not Columns!!

Regards,

Simsy

  scotty 10:15 07 Sep 05

Simsy,

Setting the width to zero is how columns are hidden in Excel. Try hiding a column, then goto a cell in that column and check the width by going to Format\Column|width and you will see it is set to zero.

Good lateral thinking though!

  Simsy 17:42 07 Sep 05

but my suggestion might still have some merit...

when you "unhide" cols or rows they, (in my experience), revert to being "unhidden" at the size they were before being "hidden"... if they were set to zero width BEFORE being hidden, then unhiding them would "revert" them to, presumeably, zero width?

Regards,

Simsy

  keef66 11:11 09 Sep 05

Nope, unhiding rows reveals them even if they were manually set to a height of zero before hiding them.

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…