Excel - Anchoring cells

Asked By Kurt Ullman on 07-Sep-10 02:14 PM
I have a spreadsheet I am  working on where I have 4 columns of
demographic information followed by 12 columns for their status during
specific months. I would like to anchor the 4 columns and then be able
to go the month in question. I want to be able to see the demo
information next to the cell for that person and that month. HOw?
Xcel 2004 for Mac if you need the information.
Thanks for any help.

--
I want to find a voracious, small-minded predator
and name it after the IRS.
Robert Bakker, paleontologist




Roger Govier replied to Kurt Ullman on 08-Sep-10 04:46 AM
Hi Kurt
Place your cursor in cell E2>Windows>Freeze Panes
This will lock the top row, and the first 4 columns of the sheet.

--

Regards
Roger Govier


__________ Information from ESET Smart Security, version of virus signature database 5430 (20100907) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Kurt Ullman replied to Roger Govier on 08-Sep-10 09:09 AM
In article <i67inn$fpd$1@news.eternal-september.org>,


When I try that, the Freeze Pains option is greyed out. Do I need
to do something else before? Thanks for the help.
Kurt


--
I want to find a voracious, small-minded predator
and name it after the IRS.
Robert Bakker, paleontologist
Roger Govier replied to Kurt Ullman on 09-Sep-10 06:54 AM
Hi Kurt

It sounds as though your sheet is protected.
Remove protection, apply Freeze Panes then put protection back on.

--

Regards
Roger Govier


__________ Information from ESET Smart Security, version of virus signature database 5430 (20100907) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Kurt Ullman replied to Roger Govier on 09-Sep-10 09:50 AM
In article <i6aefe$ah6$1@news.eternal-september.org>,

It is not protected. I tried to unprotect it using tools->
protection and I got the set-up information. If I unchecked everything,
the OK button went away. Also, I started up a brand new worksheet,
figuring if I could get it to work, then I'd just cut and paste the
information over. Even on the brand new one, I still got a greyed out
freeze pane.
Any other suggestions?
Kurt

--
I want to find a voracious, small-minded predator
and name it after the IRS.
Robert Bakker, paleontologist