what happened to the rest of the columns and rows?

T

Tonso

Using Excel 2002, I opened a file that contained a chart. The rows and
columns extend only as far as the chart extends. Maybe 50 or so rows
and 30 columns are visible. The rest are gone. How do I get them back?
Thanks,

Tonso
 
G

Gord Dibben

I would assume that the missing rows and columns are hidden.

CTRL + a(twice in 2003) to select all.

Format>Rows>Unhide

Format>Columns>Unhide


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i overcome the xl2003 limit of 65,536 rows? 3
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1
Blank Charts and Paste Special 5
Rows of data, using status columns to sort data to pie chart on another worksheet tab 1
Getting Text data using the Data - Subtotal feature 1
How to update a portion of rows and columns between two files 1
Where are the old 'Print' scenarios? 2
Compatibility MOde and Read only 1

Top