How do I add rows and headers to several worksheets automatically

C

Chesil

I have several worksheets that have the same rows and headers but different
data and I'll need to add new rows with headers as new projects start. Is
there a way to do this automatically without having to manually add rows and
headers to each sheet?
 
J

Jim Thomlinson

You can select multiple sheets at once and now changes are being made to all
of the selected sheets at once. To select multiple sheets

Select the first sheet
Now hold down the Ctrl key and select more sheet. The tab on each sheet you
select will highlight.
You can also hold down the Shift key to select all sheet from the first
selected sheet to the sheet you are selecting.

To remove the multi select just select a sheet that is not currently part of
the selected sheets.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top