another Q - "moving" table

  • Thread starter Thread starter Heshe
  • Start date Start date
H

Heshe

I've seen this on a file once but I dont know how it was achieved.

Let's say i have a huge table, about 30 columns, 1000 rows.
The top row gives the characteristics, and the "leftest" column give
whose characteristics are those; like:

John Jack whoever
height
weight
whatever

since the table is quite big, when you're in the middle, its ver
uncomfortable to fill it since you have already successfully forgotte
which column was for John and which was for Jack and so on.
So I wanted to make it such, that the inner part of the table can mov
as i scroll down or right... so that as if it goes under the firs
column or the top row.

How can I achieve this?

Thanks in advance
 
Heshe,

Select the first data cell, that is not top or leftish, and then in menu
Windows>Freeze Panes you'll get what you want.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Heshe

Select A2 to have row 1 frozen when you select Window>Freeze Panes.

The rule for freezing panes is: everything above and to the left of the
selected cell will stay in view as you scroll right and/or down.

Gord Dibben Excel MVP
 
Back
Top