#1   Report Post  
washnepo
 
Posts: n/a
Default [group] in heading

i have an Excel 2000 spreadsheet, which has the following in the header
'Microsoft Excel - filename [group]'

I can modify cells, but when i try to modify boxes created with the draw
toolbar, a black and white stop sign is displayed.

Can anyone tell me what i have done and more importantly, how do i get rid
of the [group]

thanks
  #2   Report Post  
Hank Scorpio
 
Posts: n/a
Default

On Mon, 6 Dec 2004 01:17:14 -0800, "washnepo"
wrote:

i have an Excel 2000 spreadsheet, which has the following in the header
'Microsoft Excel - filename [group]'

I can modify cells, but when i try to modify boxes created with the draw
toolbar, a black and white stop sign is displayed.

Can anyone tell me what i have done and more importantly, how do i get rid
of the [group]


You have more than one sheet selected. Either select any sheet that
you don't currently have selected (you'll be able to tell the
difference from the colours of their tabs unless they're all
selected), or right click on a sheet tab and select "Ungroup Sheets".

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Also a good idea to make note of which sheets were "grouped" and browse
through them looking for changes you may have inadvertantly made.

Any changes made to one sheet will have been done to all sheets in the group.

That includes formatting changes and data entry among others.

Gord Dibben Excel MVP

On Mon, 06 Dec 2004 20:45:29 +1100, Hank Scorpio
wrote:

On Mon, 6 Dec 2004 01:17:14 -0800, "washnepo"
wrote:

i have an Excel 2000 spreadsheet, which has the following in the header
'Microsoft Excel - filename [group]'

I can modify cells, but when i try to modify boxes created with the draw
toolbar, a black and white stop sign is displayed.

Can anyone tell me what i have done and more importantly, how do i get rid
of the [group]


You have more than one sheet selected. Either select any sheet that
you don't currently have selected (you'll be able to tell the
difference from the colours of their tabs unless they're all
selected), or right click on a sheet tab and select "Ungroup Sheets".

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *


Reply
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
What means [Group] in the title bar of a workbook Gabriel Martin Excel Discussion (Misc queries) 4 December 8th 04 11:35 AM
How do I set up a column with a heading and a subheading? Chelle21 Excel Discussion (Misc queries) 1 November 29th 04 10:08 PM


All times are GMT +1. The time now is 06:18 AM.

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

About Us

"It's about Microsoft Excel"