LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
tjtjjtjt
 
Posts: n/a
Default

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
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
Saved *.csv file gives SYLK file type warning upon Excel 2003 open Tom Excel Discussion (Misc queries) 5 March 19th 08 03:15 PM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 2 February 19th 05 08:52 PM
save excel file from a table delimited file (.txt) using macros sedamfo New Users to Excel 1 February 15th 05 04:19 AM
Excel Exits on File Close with Outlook Erin Searfoss Excel Discussion (Misc queries) 1 January 16th 05 09:43 PM
unable to open Excel file by double clicks Renyan Excel Discussion (Misc queries) 2 January 16th 05 01:07 AM


All times are GMT +1. The time now is 04:51 AM.

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

About Us

"It's about Microsoft Excel"