98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hidden rows within Excel
Hidden rows within Excel
Resolved · High Priority · Version 2007
Fri 1 May 2009, 10:20Delegate Daniel said...
Daniel has attended:
Word Intermediate course
PowerPoint Intermediate Advanced course
Excel Intermediate course
Hidden rows within Excel
I have received a spreadsheet from a colleague but unfortunately they seem to have hidden a number of rows.
I have tried highlighting the adjacent rows and right clicking, I have tried highlighting the whole worksheet and using the format cells option.
I'm at a loss as to what to do next.
Any thoughts?
Fri 1 May 2009, 10:59Trainer Anthony said...
RE: Hidden rows within Excel
Hi Daniel. You need to highlight all cells and then right click on the highlighted area and select unhide to reveal all cells. If that doesn't work there is something else going on. Have you tried selecting the whole spreadsheet, copying it to the clipboard and then pasting it into a new worksheet?
Anthony
Fri 1 May 2009, 11:05Delegate Daniel said...
RE: Hidden rows within Excel
Hey there Anthony,
Many thanks for the swift response.
I'd already tried both of those ideas but to no avail. I was wondering whether there were any insider tips that aren't so obvious?
Do you think there is an issue with my viewing rights?
Dan
Tue 5 May 2009, 10:33Trainer Anthony said...
RE: Hidden rows within Excel
Hi Dan. Have you tried going to Tools - Protection and seeing whether there is any custom protection on the worksheet? Rows and columns can be made uneditable this way and your source might have applied this to the worksheet.
It's also a possibility that row height or column width might be set to 0 for your "hidden" data. Trying selecting all and then formatting row height and column width through the menu drop downs.
Let me know how you get on.
Anthony
Mon 11 May 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Closing all your workbooks QuicklyHold the SHIFT key down and using the mouse click on the file menu, it will now now CLOSE ALL rather than close. This closes all workbooks down but still leaves the application open. |
