excel question

Posted By Message

MarathonKnitter
HAPPY

Member since 2/07

17374 total posts

Name:
EMBRACING CHANGE

excel question

how can i set up cells to stay put?

like the header of a column or row to stay visible as i scroll up and down; left and right.

tia

Posted 6/27/08 1:19 PM
 
Long Island Weddings
Long Island's Largest Bridal Resource

JodiBabe
Married for 9 yrs!!!!!!

Member since 5/05

6672 total posts

Name:
Jodi

Re: excel question

Under view -----> Headers & Footers

Set them up in there

ETA: wait sorry not sure if they will stay if you scroll....sorry

Message edited 2008-06-27 13:21:54.367000.

Posted 6/27/08 1:20 PM
 

Sash
Peace

Member since 6/08

10314 total posts

Name:
fka LIW Smara

Re: excel question

Select the cell under the last row and column you want to freeze. Then in teh menu bar go to Window-->Freeze Pane.

In 2007 I think there is a window tab and you should see freeze pane.

Posted 6/27/08 1:21 PM
 

CouponKT
Our family is complete

Member since 6/06

16494 total posts

Name:
K

Re: excel question

higlight the cells you want to stay put and click on FREEZE CELLS in one of the drop down menus (I have Vista, so it's a little different for me to look at)

Posted 6/27/08 1:22 PM
 

MarathonKnitter
HAPPY

Member since 2/07

17374 total posts

Name:
EMBRACING CHANGE

Re: excel question

thanks

freezing worked Chat Icon

Posted 6/27/08 1:27 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
Excel question... igottabeme 1/22/08 4 Families Helping Families ™
URGENT EXCEL QUESTION kerrycec03 10/18/07 8 Families Helping Families ™
Excel Question spooks 8/22/07 1 Families Helping Families ™
Excel Question spooks 6/8/07 2 Families Helping Families ™
Excel masters - a question SweetestOfPeas 5/18/07 18 Families Helping Families ™
Dumb excel question JenniferEver 4/23/06 3 Families Helping Families ™