ExcelBanter - How do I insert something on multiple worksheets in one workbook?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I insert something on multiple worksheets in one workbook? (https://www.excelbanter.com/excel-worksheet-functions/26716-how-do-i-insert-something-multiple-worksheets-one-workbook.html)

carrie

How do I insert something on multiple worksheets in one workbook?

I need to insert a paragraph at the beginning of and excel workbook. We have
about 80 worksheets in that book and I'd like to be able to do it all at
once. Is this possible?

Ron de Bruin

Hi Carrie

group your sheets like this

right click on one of the sheet tabs and "select all sheets"
enter your text
right click on one of the sheet tabs and "ungroup sheets"

--
Regards Ron de Bruin
http://www.rondebruin.nl

"carrie" wrote in message ...
I need to insert a paragraph at the beginning of and excel workbook. We have
about 80 worksheets in that book and I'd like to be able to do it all at
once. Is this possible?

All times are GMT +1. The time now is 06:52 PM.