Home |
Search |
Today's Posts |
Group Shee, Microsoft Excel, newsgroup, help, assistance" /> Group Shee Excel Worksheet Functions" />
#1
|
|||
|
|||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee
I am trying to migrate Lotus 123 spreadsheets to Excel.
Multi sheet spreadsheets are "Grouped" in order that changes in format (add or delete lines, columns, etc) on one sheet are made to all sheets. Does Excel have a similar function? |
#2
|
|||
|
|||
Yep.
Just click on the first worksheet tab and ctrl-click on subsequent. (or click and shift-click to extend the range of selected worksheets) Be careful to ungroup (rightclick on one of the grouped worksheets tabs) and select "ungroup sheets") when you're done. (you can get them all by rightclicking on a worksheet tab and choosing "select all sheets", too.) jaking wrote: I am trying to migrate Lotus 123 spreadsheets to Excel. Multi sheet spreadsheets are "Grouped" in order that changes in format (add or delete lines, columns, etc) on one sheet are made to all sheets. Does Excel have a similar function? -- Dave Peterson |
#3
|
|||
|
|||
I have the same issue, however I have previously used this Excel grouping
feature, but it does not even come close to the functionality in Lotus 123. I want the same formats on each sheet and I want to be able to add and delete rows and columns, but I don't want to enter date on one sheet have have it appear all sheets. Thanks "Dave Peterson" wrote: Yep. Just click on the first worksheet tab and ctrl-click on subsequent. (or click and shift-click to extend the range of selected worksheets) Be careful to ungroup (rightclick on one of the grouped worksheets tabs) and select "ungroup sheets") when you're done. (you can get them all by rightclicking on a worksheet tab and choosing "select all sheets", too.) jaking wrote: I am trying to migrate Lotus 123 spreadsheets to Excel. Multi sheet spreadsheets are "Grouped" in order that changes in format (add or delete lines, columns, etc) on one sheet are made to all sheets. Does Excel have a similar function? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Cannot Group Seven Worksheets, only Six | Excel Discussion (Misc queries) | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
indirect function in different worksheets, losing my hair! | Excel Discussion (Misc queries) |