How to Enter Formula in Multiple Sheets

[Nitesh Khot]

Hi..

I have 20 sheets in single Workboook and I need to put formula into all sheets in column AA1 to End of the Row.


Is this possible with or without Macro...

Thanks.
Nikh

 

[mohadin]

Hi nitesh khot
yes and easy
select the first sheet then hold the shift while selecting the last sheet
then in the sheet select the cells you want to write the formula an write the formula you want the hit enter while holding the Ctrl
and it's done

 

[Nitesh Khot]

Thank you so much....It awesome..

 

[mohadin]

wellcome
best regards