Getting a bird's eye view of a spreadsheet's layout

[mckitlk]

Hi, All,

When I worked with Lotus 1-2-3 years ago, I found that it had a feature
which would show you, on one screen, all the cells in a spreadsheet
that had anything in them. I don't remember what it was called -- map,
layout, overview, or what. But it was invaluable when trying to
analyze a spreadsheet.

I'm now working with Excel 2003, and can't find anything similar.

Does anyone know how to do this?

Thanks in advance!

Laura

 

[Jim Cone]

Page Break Preview on the View menu might do it...
-or-
enter a small number (33?) in the "zoom" box on the toolbar.
-or-
select your data and then choose "selection" in the zoom box.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


<[email protected]>
wrote in message
Hi, All,
When I worked with Lotus 1-2-3 years ago, I found that it had a feature
which would show you, on one screen, all the cells in a spreadsheet
that had anything in them. I don't remember what it was called -- map,
layout, overview, or what. But it was invaluable when trying to
analyze a spreadsheet.
I'm now working with Excel 2003, and can't find anything similar.
Does anyone know how to do this?
Thanks in advance!
Laura

 

[jasonchow]

Try hitting Ctrl ~

Jason

 

[mckitlk]

Thanks, both.

I think selecting the entire worksheet (click in the upper left corner)
and using Zoom/Selection comes closest to what I was looking for.
Still not quite there, though. Oh, well.

 

[mylifewalk]

Try holding down CTRL while you turn your mouse wheel.