Limited Range of Rows and Columns

E

eggplant77

I have downloaded a spreadsheet that contains only columns A through H
and only rows 1 through about 80. To the right and below this range is
gray. I don't think this was done by hiding rows and columns because
when I highlight all cells and try "Unhide" nothing changes.

How can I view the rows and columns that are currently not displayed?

Thanks.
 
G

Gord Dibben

Can you scroll past column H and below row 80?

If so, the cells probably have their background color set to gray.

Hit CTRL + a(twice in XL2003) to select all cells.

Then Format>Cells>Patterns>"No Color"

If you can't scroll, please post back and we can investigate further.


Gord Dibben Excel MVP
 
E

eggplant77

Gord, Thanks for your help. I tried a new technique of left clickin
and manipulating the column width and row height to make the missin
rows and columns appear. It turns out they were hidden but for som
reason, pressing control-a twice and selecting 'unhide' didn't do th
trick. In any case, the problem is resolved. Thanks again
 

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

Expand and collapse rows 7
Macro for comparing columns and highlighting matching/differences 14
How to vary shading of groups of rows, based on change in value in aparticular column 9
Locate text in range (multiple occurrences) and report other cell insame column? 10
Number of rows and columns 14
row comparison 5
Macro running slow 7
Loop through a range of rows and hide based on conditions 3

Top