Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
keep first left colum visible
Hi,
how do I keep the first left colum visible when I work with up to 100 columns to the right? the left colum has information I need to see when working at the right. I know this is possible, but I don't know how to set it... thanks for help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
keep first left colum visible
Try this:
Set the headings where your want them on the screen Select the first cell below the headings Example: If you always want to see rows 1:3 and column A Select cell B4 From the Excel Main Menu: <window<freeze panes Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "panambi" wrote in message ... Hi, how do I keep the first left colum visible when I work with up to 100 columns to the right? the left colum has information I need to see when working at the right. I know this is possible, but I don't know how to set it... thanks for help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
keep first left colum visible
Select cell B1 and choose Freeze Pane from the Window menu.
-- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "panambi" wrote in message ... Hi, how do I keep the first left colum visible when I work with up to 100 columns to the right? the left colum has information I need to see when working at the right. I know this is possible, but I don't know how to set it... thanks for help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
keep first left colum visible
Thank you so much!
one more question: how do I do the set up, if I want to have the first column printed on each page? "Ron Coderre" wrote: Try this: Set the headings where your want them on the screen Select the first cell below the headings Example: If you always want to see rows 1:3 and column A Select cell B4 From the Excel Main Menu: <window<freeze panes Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "panambi" wrote in message ... Hi, how do I keep the first left colum visible when I work with up to 100 columns to the right? the left colum has information I need to see when working at the right. I know this is possible, but I don't know how to set it... thanks for help! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
keep first left colum visible
File/ Page Setup/ Sheet/ Columns to repeat at left:
$A:$A -- David Biddulph "panambi" wrote in message ... Thank you so much! one more question: how do I do the set up, if I want to have the first column printed on each page? "Ron Coderre" wrote: Try this: Set the headings where your want them on the screen Select the first cell below the headings Example: If you always want to see rows 1:3 and column A Select cell B4 From the Excel Main Menu: <window<freeze panes Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "panambi" wrote in message ... Hi, how do I keep the first left colum visible when I work with up to 100 columns to the right? the left colum has information I need to see when working at the right. I know this is possible, but I don't know how to set it... thanks for help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what are the 8 grey inactive Excel Colums headed 1-8 left of Colum | Excel Discussion (Misc queries) | |||
Keep certain cells visible when scrolling, not just rows or colum | Excel Worksheet Functions | |||
Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Check data on colum A and find match on colum b | Excel Discussion (Misc queries) |