Excel help...
Jun. 15th, 2007 09:23 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
mebfeathI'm doing a spreadsheet for my boss's cervical cancer program in Vanuatu, and I know you can make cells at the top or on the side of a spreadsheet stay there permanently while the others move across. I need to do this, but I don't know how.
Ok, so that sentence made no sense at all.
Basically, what I need to do is to keep the first few columns or rows (haven't decided yet) on the screen at all times, but I need to scroll down through the columns/rows after. Does that make sense?
Long week. *headdesks*
Help.
Ok, so that sentence made no sense at all.
Basically, what I need to do is to keep the first few columns or rows (haven't decided yet) on the screen at all times, but I need to scroll down through the columns/rows after. Does that make sense?
Long week. *headdesks*
Help.
![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
no subject
Date: 2007-06-15 11:46 am (UTC)Highlight the entire column/row underneath or beside where you want frozen. Go to the window menu at the top of the page and click on freeze panes.
That should do it :)
no subject
Date: 2007-06-17 02:39 am (UTC)YAY! It works! Thanks so much! :)
no subject
Date: 2007-06-17 07:26 am (UTC)no subject
Date: 2007-06-15 05:07 pm (UTC)no subject
Date: 2007-06-17 02:41 am (UTC)