MS Excel: Why would the Goal Seek option be dimmed for a book?
 

I am intrigued with a fact:
I have an Excel book from a student in which the Goal Seek oprion is dimmed
out and I would like to know why. I have also noticed that on the title bar
there is the following text after the book name: [Group]
Thank you for any help you can provide!

MS Excel: Why would the Goal Seek option be dimmed for a book?
 

When you see [Group] in the title bar, it means that at least two worksheets are
selected (grouped).

This means that almost anything you do to one of those grouped sheets, you do to
each in that group.

Just rightclick on one of the worksheet tabs and select Ungroup Sheets.

Lots of stuff is disabled when you have grouped sheets.

Janine wrote:

I am intrigued with a fact:
I have an Excel book from a student in which the Goal Seek oprion is dimmed
out and I would like to know why. I have also noticed that on the title bar
there is the following text after the book name: [Group]
Thank you for any help you can provide!

--

Dave Peterson

MS Excel: Why would the Goal Seek option be dimmed for a book?
 

The [Group] indicator in the title bar indicates that you have
two or more worksheets simultaneously selected, and that a change
to one worksheet will be made to all grouped worksheets. Look
down at the sheet tabs; those in white are the grouped sheets.
Some operations, such as Goal Seek, are not allowed when
worksheets are grouped.

Right-click on a sheet tab and choose UnGroup Sheets. Note,
though, that you may well have already made changes to all the
group sheets.




--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Janine" wrote in message
...
I am intrigued with a fact:
I have an Excel book from a student in which the Goal Seek
oprion is dimmed
out and I would like to know why. I have also noticed that on
the title bar
there is the following text after the book name: [Group]
Thank you for any help you can provide!

MS Excel: Why would the Goal Seek option be dimmed for a book?
 

Thank you!!!! :)

"Dave Peterson" wrote:

When you see [Group] in the title bar, it means that at least two worksheets are
selected (grouped).

This means that almost anything you do to one of those grouped sheets, you do to
each in that group.

Just rightclick on one of the worksheet tabs and select Ungroup Sheets.

Lots of stuff is disabled when you have grouped sheets.

Janine wrote:

I am intrigued with a fact:
I have an Excel book from a student in which the Goal Seek oprion is dimmed
out and I would like to know why. I have also noticed that on the title bar
there is the following text after the book name: [Group]
Thank you for any help you can provide!

--

Dave Peterson

MS Excel: Why would the Goal Seek option be dimmed for a book?
 

Thank you!!! :)

"Chip Pearson" wrote:

The [Group] indicator in the title bar indicates that you have
two or more worksheets simultaneously selected, and that a change
to one worksheet will be made to all grouped worksheets. Look
down at the sheet tabs; those in white are the grouped sheets.
Some operations, such as Goal Seek, are not allowed when
worksheets are grouped.

Right-click on a sheet tab and choose UnGroup Sheets. Note,
though, that you may well have already made changes to all the
group sheets.




--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Janine" wrote in message
...
I am intrigued with a fact:
I have an Excel book from a student in which the Goal Seek
oprion is dimmed
out and I would like to know why. I have also noticed that on
the title bar
there is the following text after the book name: [Group]
Thank you for any help you can provide!