Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I fix 1 column & scroll across others?
I'm trying to set up a sheet where the first column is text, and the subsequent columns are calculations. There are 52 calculations columns. I'd like to fix the text column in place so it is always the left-most column, while still being able to scroll through the other columns - that way I have a label to reference instead of trying to follow row 12 back to column A to see what the row represents. Can you tell me how to do this? -- smurphytoo ------------------------------------------------------------------------ smurphytoo's Profile: http://www.excelforum.com/member.php...o&userid=36341 View this thread: http://www.excelforum.com/showthread...hreadid=561271 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I fix 1 column & scroll across others?
Hi, You could try selecting cell cell B2 and then selecting Windows Freeze Panes VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561271 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Creating a scroll down menu in a column | Excel Discussion (Misc queries) | |||
how can i multiply two columns | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions |