MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying to multiple spreadsheets


Posted by Carl L. Medus on September 04, 2001 11:56 AM

So, here's the problem. I have a formula in cell a1, sheet 1
that I want to copy down to cells a1, sheets 2, 3, 4, 5, 6 ...

So how do you do this in excel.


Posted by Carla on September 04, 2001 12:50 PM

Hold down the control key and highlight all of the sheets you want the formula in. Then type the formula in a1 on the first sheet that is highlighted and it will appear in all sheets highlighted. Hope this helps