123Convert
Instructor
I'm a former Excel user and I'm trying to use Lotus in the same way I used Excel. Can you tell me how to group worksheets so that I can edit/format/data entry on multiple sheets at once?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Grouping worksheets
- Thread starter 123Convert
- Start date
- Status
diogenes10
Technical User
Hi,
I am having to go the other way, Lotus to Excel.
I have not used this to make changes in multiple sheets, I use it more to copy formatting, but I think it is what you are wanting
(Millenium editions)
there is a Sheet menu choice, under that is a group sheets option.)
-------------------------------------
It's 10 O'Clock ( somewhere! ).
Are your registry and data backed up?
I am having to go the other way, Lotus to Excel.
I have not used this to make changes in multiple sheets, I use it more to copy formatting, but I think it is what you are wanting
(Millenium editions)
there is a Sheet menu choice, under that is a group sheets option.)
-------------------------------------
It's 10 O'Clock ( somewhere! ).
Are your registry and data backed up?
- Thread starter
- #3
123Convert
Instructor
It looks like "grouping" in Lotus doesn't mean the same as "grouping" in Excel. Unless I'm missing something, grouped sheets in Lotus don't copy entered data from one sheet to the next in the group, just formats, styles and inserted/deleted columns. I'm looking for something that will make the same data entry changes in all the sheets at once.
- Status