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

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
Thu Sep 28 12:17:19 CDT 2006

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@hotmail.com>
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
Thu Sep 28 18:01:41 CDT 2006

Try hitting Ctrl ~

Jason

mckitlk@hotmail.com wrote:
> 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

mckitlk
Mon Oct 02 10:54:52 CDT 2006

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.

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@hotmail.com>
> 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

mylifewalk
Mon Oct 02 11:11:03 CDT 2006

Try holding down CTRL while you turn your mouse wheel.

mckitlk@hotmail.com wrote:
> 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