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 » excel training microsoft - How do you unhide "lost" cells?
excel training microsoft - How do you unhide "lost" cells?
Resolved · Low Priority · Version Standard
Mon 28 Jan 2008, 16:21Delegate Renee said...
Renee has attended:
Excel Introduction course
How do you unhide "lost" cells?
If you hide columns in the excel spreadsheet, quite often they get lost and you can't find them again. where do I look for them once you have used the "unhide/hide" option and they still don't turn up.
Tue 29 Jan 2008, 16:43Delegate Paul said...
RE: how do you unhide "lost" cells?
Try selecting a load of rows, e.g. row 1 thru row 2500 and then go right click > unhide.
You may find them
Fri 1 Feb 2008, 10:42Trainer Mark said...
RE: how do you unhide "lost" cells?
Hi Renee
Hope you are well i can understwhere you are coming from, when you need to unhide rows or columns you find need to find which row or column that you need to unhide to do this look on the header for an example header D and header F
You will then need to select from column C to G then go the format menu and columns then click unhide this should bring back the unhidden ones, you can also right click on the column header and click unhide
hope this helps you
Mark East
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:Hide columns in an Excel 2010 WorksheetIf you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns. |
