How do we fix a Column in Sheet 1?

[rainforest_puppy]

Hi,

Can anyone advise on how can i fix column A on sheet 1 and enable this column to appear in every other sheets? Ie sheet 2 will show Column A of sheet 1



thanks for any input

 

[Smitty]

To set it so that column A is always visible, got B1-->Windows-->Freeze Panes.

To show column A in each sheet, group the other sheets with Ctrl+Left-Click put =Sheet1!A1 in A1 on the first grouped sheet and drag down as far as you have data in Sheet1 column A.

HTH,

 

[rainforest_puppy]

To set it so that column A is always visible, got B1-->Windows-->Freeze Panes.

To show column A in each sheet, group the other sheets with Ctrl+Left-Click put =Sheet1!A1 in A1 on the first grouped sheet and drag down as far as you have data in Sheet1 column A.

HTH,

thanks for the fast response.
But i am not sure whether its work. I hold ctrl and left click on the other sheet and input =Sheet1!A1 in A1 of Sheet 2. But i cant get it to work?

 

[Smitty]

You use Ctrl+Left-Click, clicking on each sheet in the workbook EXCEPT sheet1. This will group the sheets, which allows you to make the same changes to all of those sheets at once. Then when you apply the formula to the sheet that remains active, it will apply the formula to the rest of the grouped sheets.