Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert lines
I am trying to do the following: If I add a line in Sheet 1, I want the same line with the same infos added automatically in Sheet 2. Is there any way to do that? Thanks for advice! Alex -- abunge ------------------------------------------------------------------------ abunge's Profile: http://www.excelforum.com/member.php...o&userid=35079 View this thread: http://www.excelforum.com/showthread...hreadid=548275 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert lines
Group Sheet1 and Sheet2:
With Ctrl pressed, click on Sheet1 tab, then Sheet2 tab All modifications will appear in all sheets of the group HTH -- AP "abunge" a écrit dans le message de news: ... I am trying to do the following: If I add a line in Sheet 1, I want the same line with the same infos added automatically in Sheet 2. Is there any way to do that? Thanks for advice! Alex -- abunge ------------------------------------------------------------------------ abunge's Profile: http://www.excelforum.com/member.php...o&userid=35079 View this thread: http://www.excelforum.com/showthread...hreadid=548275 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert lines
Hi I assume when u mean add lines u mean putting in cell entries? You can do it by grouping the worksheets when u enter data. Click on the sheet tab, like say Sheet 1, den ctrl click on other Sheets like Sheet 2 to group them. Alternatively, you can use shift to select a range of worksheets on the sheet tab. Then, enter any data in Sheet 1, and the change will reflect on all sheets grouped. To upgroup them, just right click on the sheet tab and press ungroup. Drawing like lines or shapes cannot be added to multiple sheets automatically, so you have to do it manually. ^^ -- KellTainer ------------------------------------------------------------------------ KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322 View this thread: http://www.excelforum.com/showthread...hreadid=548275 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert lines
Great, thanks a lot! I am trying to handle loads of data on different sheets, and this makes adding changes much easier. I knew there was some sort of easy solution... Thanks Alex -- abunge ------------------------------------------------------------------------ abunge's Profile: http://www.excelforum.com/member.php...o&userid=35079 View this thread: http://www.excelforum.com/showthread...hreadid=548275 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to insert blank lines | Excel Discussion (Misc queries) | |||
insert verticle lines between columns | Excel Worksheet Functions | |||
Write code to insert multiple lines | Excel Discussion (Misc queries) | |||
Make default insert sheet to have grid lines | New Users to Excel | |||
Challenging Charting | Charts and Charting in Excel |