Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 18th 05, 06:25 PM
carrie
 
Posts: n/a
Default 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?

  #2   Report Post  
Old May 18th 05, 06:31 PM
Ron de Bruin
 
Posts: n/a
Default

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?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the quickest method to insert & name multiple worksheets . clyonesse Excel Worksheet Functions 8 September 20th 05 10:55 PM
fax multiple worksheets volleyman Excel Worksheet Functions 0 March 30th 05 05:51 PM
What is the quickest method to insert & name multiple worksheets . clyonesse Excel Worksheet Functions 0 January 20th 05 06:15 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 06:57 PM
Countif with multiple criteria and multiple worksheets JJ Excel Worksheet Functions 1 December 28th 04 06:37 PM


All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017