Linking Question

[zkiraly]

Hello,

I have 40 sheets in a spreadsheet. In all of the sheets, cell D5 says "January 2005". How can I change all the D5 cells in the sheets simultaneously to say "February 2005" so that I won’t have to go through each sheet one by one to change January 2005 to February 2005?


Thanks

 

[Dargie]

Hi there

Activate Sheet 1 then press Ctrl + Shift, and then press page down until all pages are highlighted as a group. Ths sheet tabs will all go white.
In whatever sheet is showing on screen,possibly sheet 40?, change your value in Cell D5 to Feb 2005, and it will change this value in all the other selected sheets. Click one sheet tab to deselect all the sheets and activate one sheets again.

Hey presto!! Easy as that


Cheers Steve