Unhide hidden rows in Excel 2003
Thread poster: Samuel Murray

Samuel Murray  Identity Verified
Netherlands
Local time: 06:59
Member (2006)
English to Afrikaans
+ ...
Apr 7, 2011

G'day everyone

Last week a client sent me an Excel file with hidden rows that I was able to unhide. This week the client sent another Excel file with hidden rows, but I can't remember how I unhid the rows last week. I don't need to re-hide the rows later -- I just need to unhide it so that when I copy a column it copies all cells (including hidden ones). I've tried Ctrl+Shift+9, with no luck. I can't individually select rows because there are hundreds of hidden rows all over the place.

I also checked the file the client sent last week -- Ctrl+Shift+9 doesn't work there either, but I know that I was able to unhide the rows. I just can't remember how I did it.

Any ideas?

Thanks
Samuel


Direct link Reply with quote
 

István Hirsch  Identity Verified
Local time: 06:59
English to Hungarian
Did you select... Apr 7, 2011

the table before pressing Ctrl+Shift+9?

Direct link Reply with quote
 

Terry Richards
France
Local time: 06:59
French to English
+ ...
It's easy :) Apr 7, 2011

- Click the top left corner to select all cells

- Format ! Columns ! Unhide
and/or
- Format ! Rows ! Unhide


Direct link Reply with quote
 

Annamaria Amik  Identity Verified
Local time: 07:59
Romanian to English
+ ...
Select all, then Unhide? Apr 7, 2011

I don't have Office 2003 on my computer right now, but I think I used to unhide everything by selecting everything followed by right-click and Unhide.

HTH


Direct link Reply with quote
 

Samuel Murray  Identity Verified
Netherlands
Local time: 06:59
Member (2006)
English to Afrikaans
+ ...
TOPIC STARTER
Yes... Apr 7, 2011

István Hirsch wrote:
...the table before pressing Ctrl+Shift+9?


Yes. I can see from the row numbers that there are hidden rows, and if I copy a column and paste it elsewhere, some of the copied cells go missing (this typically happens because those cells get pasted in the hidden rows).

It took me very little googling last week to figure it out, but this week I can't figure out how to do it.

The weird thing is that when I hide further rows in that Excel file, I can't unhide those either.


Direct link Reply with quote
 

István Hirsch  Identity Verified
Local time: 06:59
English to Hungarian
Filter? Apr 7, 2011

Is there a blue down arrow in the first line of the table?
If so, click on it and select All from the drop-down menu.


Direct link Reply with quote
 

Oleksandr Ivanov  Identity Verified
Ukraine
Local time: 07:59
Member (2008)
English to Ukrainian
+ ...
Well Apr 7, 2011

You can select the rows just before and after the hidden rows to be unhidden with your mouse. Then, right click it and choose Unhide. It still works for me in Excel 2003.

Direct link Reply with quote
 

Samuel Murray  Identity Verified
Netherlands
Local time: 06:59
Member (2006)
English to Afrikaans
+ ...
TOPIC STARTER
Yes... Apr 7, 2011

Oleksandr Ivanov wrote:
You can select the rows just before and after the hidden rows to be unhidden with your mouse. Then, right click it and choose Unhide. It still works for me in Excel 2003.


Yes, all of these things work on a new spreadsheet, but not in the client's. Anyway, I'll just write it off to a very weird file.


Direct link Reply with quote
 

Antoní­n Otáhal
Local time: 06:59
Member (2005)
English to Czech
+ ...
OO? Apr 7, 2011

Have you tried to open it in OpenOffice and see what happens?

Antonin


Direct link Reply with quote
 

Michael J.H. Davies  Identity Verified
Denmark
Local time: 06:59
Member (2009)
English to Danish
+ ...
Yes, Annamaria's suggestion should do the trick. Apr 8, 2011

Annamaria Amik wrote:

I don't have Office 2003 on my computer right now, but I think I used to unhide everything by selecting everything followed by right-click and Unhide.

HTH


Direct link Reply with quote
 

Michael J.H. Davies  Identity Verified
Denmark
Local time: 06:59
Member (2009)
English to Danish
+ ...
Is the spreadsheet protected (maybe with a password?) Apr 8, 2011

Samuel Murray wrote:

Oleksandr Ivanov wrote:
You can select the rows just before and after the hidden rows to be unhidden with your mouse. Then, right click it and choose Unhide. It still works for me in Excel 2003.


Yes, all of these things work on a new spreadsheet, but not in the client's. Anyway, I'll just write it off to a very weird file.


If the spreadsheet has been locked, then you won't be able to unhide rows or columns until it is unlocked.


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Unhide hidden rows in Excel 2003

Advanced search






memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
SDL Trados Studio 2017 only €415 / $495
Get the cheapest prices for SDL Trados Studio 2017 on ProZ.com

Join this translator’s group buy brought to you by ProZ.com and buy SDL Trados Studio 2017 Freelance for only €415 / $495 / £325 / ¥60,000 You will also receive FREE access to our getting started eLearning program!

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search