G Guest Nov 16, 2003 #1 I came across a spreadsheet where column A and Row 1 were fixed and allowed the rest of columns and rows to still sroll. How was this done?
I came across a spreadsheet where column A and Row 1 were fixed and allowed the rest of columns and rows to still sroll. How was this done?
D Dave Peterson Nov 16, 2003 #3 Put the cell that you want in the top left corner (usually it's A1). then select a different cell. everything above that cell and to the left will be frozen. Then Window|Freeze Panes (and that's where you'd unfreeze them, too.)
Put the cell that you want in the top left corner (usually it's A1). then select a different cell. everything above that cell and to the left will be frozen. Then Window|Freeze Panes (and that's where you'd unfreeze them, too.)
