Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

suzanne has attended:
Excel Advanced course

Excel 2007

When i tried to hide a row (I) and Column (A) at the same time the whole sheet vanished. How do i get this back?

RE: Excel 2007

Hi Suzanne,

Thank you for your question.

If you place your mouse pointer at the edge of the column until you get a resizing handle. Hold the left mouse button down and drag out to the right until a column appears.

Next select the whole spreadsheet by clicking on the blank button(where the rows and columns meet).

Right click over the column header and choose Unhide.

The spreadsheet should re-appear. Then do CTRL+HOME to return to cell A1.

I hope this answers your question.

Regards

Simon

Thu 5 Feb 2009: Automatically marked as resolved.

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.