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

Tech-Archive recommends: Speed Up your PC by fixing your registry

Thanks, both.

I think selecting the entire work*** (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.

Jim Cone wrote:
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


<mckitlk@xxxxxxxxxxx>
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 spread***
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 spread***.
I'm now working with Excel 2003, and can't find anything similar.
Does anyone know how to do this?
Thanks in advance!
Laura

.

Quantcast