Exel help i wanna keep a colum of cells in the same place on the left of the screen , while the rest of the sheet a rolling calender scrols right to left behind this any one remember how to do this ive done it before and forgot how cheers
Select the column to the right of the one you want to keep at the lefthand side of screen. Go to Window menu and select 'freeze panes'.
yep yep... select the column that you want to keep at the left hand side Select the freeze panes.... make sure you only select the cells needed otherwise it becomes a ritee pain....
