Computing.Net > Forums > Office Software > Fixed column or-and row in Excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Fixed column or-and row in Excel

Reply to Message Icon

Name: Zennon
Date: April 23, 2009 at 22:57:26 Pacific
OS: Windows XP
CPU/Ram: 2GB
Product: Fujitsu siemens / Lifebook c1410
Subcategory: Microsoft Office
Comment:

Hi everyone!
How to fix the selected columns (or rows) so that they don't move when scrolling the others?
I've seen Excel files where e.g. columns A,B,C were fixed (always in the same position and visible)and the next ones could be scrolled to the right or to the left.

Thanks a lot in advance!


Zennon



Sponsored Link
Ads by Google

Response Number 1
Name: jon_k
Date: April 24, 2009 at 03:50:54 Pacific
Reply:

It's called freezing panes

in excel 2003, it's window / freeze panes

in excel 2007, it's freeze panes in the view ribbon


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Fixed column or-and row in Excel

Minimize Rows in Excel www.computing.net/answers/office/minimize-rows-in-excel/8830.html

Multiple If/And statemtn in EXCEL www.computing.net/answers/office/multiple-ifand-statemtn-in-excel/5841.html

increase no of rows in excel shet www.computing.net/answers/office/increase-no-of-rows-in-excel-shet/8272.html