Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
Happy to help.
I forgot to mention that Groups are activated in one of two ways: If Sheet1 is active, hold down Shift and click on Sheet3 to group sheets 1, 2 and 3. or If Sheet1 is active, hold down Ctrl and click on Sheet3 to group sheets 1 and 3 only. tj "LHIANNON" wrote: Thanks so much! I appreciate it. "tjtjjtjt" wrote: It means you are editing more than one worksheet at the same time. Look at the Sheet tabs at the bottom of the screen. Find the ones that appear white--those are the grouped sheets. Make a note of them. Then, to undo it, right-click on the current sheet name and click ungroup sheets. Now, go to each of the sheets that were in the group and make sure you didn't damage your file with edits intended for only one sheet. If there is damage, you may need to return to a backup of the file or consider closing it without saving changes. tj "LHIANNON" wrote: While entering data in my workbook, I noticed that the file name now appeared as "incom_expense_2005 [group}. Data entered on one sheet appeared on the next sheet, though I cannot find any linkage between the cells, and the two cells ares not set up to be linked. Also, data from the first cell sometimes appears on the second sheet, though it is transparent - you can still see the original data. I cannot figure this out and had to rebuild my sheet. Please help. This is the second time it happened. All other worksheets operate properly, so excel does not seem to be the problem. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
Excel Exits on File Close with Outlook | Excel Discussion (Misc queries) | |||
unable to open Excel file by double clicks | Excel Discussion (Misc queries) |