excel training microsoft - how do you unhide
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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?

resolvedResolved · Low Priority · Version Standard

replyReply 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.

For upcoming training course dates see: Pricing & availability

replyReply 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

replyReply 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

 

Excel tip:

Moving between Worksheets without using the mouse

Use the 'Ctrl+PgDn' and 'Ctrl+PgUp' keys.

'Ctrl+PgDn' will move to the right and 'Ctrl+PgUp' will move to the left one worksheet at a time.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard