Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
exhausted everything
 
Posts: n/a
Default adding rows to ALL worksheet (all in one)

Can when I add a row to one worksheet (the main one), is there a
functionality that will add that row to all the worksheets within the same
workbook?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default adding rows to ALL worksheet (all in one)

You can group the worksheets, so that a change made to one will
also be made to the other. To group the sheets, hold down the
CTRL key while clicking the sheet tab. You'll notice that
"[Group]" is displayed in the application title bar. To ungroup
the sheets, right click one of the sheets and choose "Ungroup
Sheets".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"exhausted everything"
wrote in message
...
Can when I add a row to one worksheet (the main one), is there
a
functionality that will add that row to all the worksheets
within the same
workbook?



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
rows 1-2 missing from excel worksheet Perplexed Excel Worksheet Functions 1 October 29th 05 03:09 AM
In a protected worksheet allow users to delete rows Jason Trivett Excel Worksheet Functions 1 July 12th 05 09:50 AM
Select rows of data in a worksheet on one criteria in multiple co MrSkoot99 Excel Worksheet Functions 5 July 11th 05 01:48 PM
Can I split my worksheet and have different size columns and rows. tommy Excel Discussion (Misc queries) 1 February 16th 05 11:17 PM
Adding rows of different info from separate worksheets into summar Barry P New Users to Excel 1 February 8th 05 02:47 PM


All times are GMT +1. The time now is 01:17 AM.

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

About Us

"It's about Microsoft Excel"