If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

how to make one column unmovable in Excel?

CyberGhost · 2003-12-18 00:16:16

i have a little problem lets say for example, you write computer name into the column A, and the part names into B,C,D,E,F,..... but! when you scroll horizontally, the column A is hidden, so you don't know what computer parts are you looking at how to make column A permanently visible? so when horizontal scroll i won't…

Options

18-12-2003 1:16am

#1

CyberGhost

Registered Users Posts: 5,554 ✭✭✭

Join Date: July 2003

Posts: 4767

i have a little problem

lets say for example, you write computer name into the column A, and the part names into B,C,D,E,F,..... but! when you scroll horizontally, the column A is hidden, so you don't know what computer parts are you looking at

how to make column A permanently visible? so when horizontal scroll i won't hide the A column?

Thanks!

0

Comments

Options
#2 18-12-2003 1:19am
Zaph

Registered Users, Subscribers Posts: 47,312 ✭✭✭✭

Join Date: July 2003

Posts: 45057

Go to cell B1 and from the menu select Window\Freeze Panes. That should do it for you.

0
Options
#3 18-12-2003 1:50am
CyberGhost

Registered Users Posts: 5,554 ✭✭✭

Join Date: July 2003

Posts: 4767

yes! that's exactly what i wanted!

Thanks a lot mate!!!

0