software

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

--

Dave Peterson

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

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

quot;Dave Petersonquot; wrote:

gt; When you see [Group] in the title bar, it means that at least two worksheets are
gt; selected (grouped).
gt;
gt; This means that almost anything you do to one of those grouped sheets, you do to
gt; each in that group.
gt;
gt; Just rightclick on one of the worksheet tabs and select Ungroup Sheets.
gt;
gt; Lots of stuff is disabled when you have grouped sheets.
gt;
gt; Janine wrote:
gt; gt;
gt; gt; I am intrigued with a fact:
gt; gt; I have an Excel book from a student in which the Goal Seek oprion is dimmed
gt; gt; out and I would like to know why. I have also noticed that on the title bar
gt; gt; there is the following text after the book name: [Group]
gt; gt; Thank you for any help you can provide!
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Thank you!!!

quot;Chip Pearsonquot; wrote:

gt; The [Group] indicator in the title bar indicates that you have
gt; two or more worksheets simultaneously selected, and that a change
gt; to one worksheet will be made to all grouped worksheets. Look
gt; down at the sheet tabs; those in white are the grouped sheets.
gt; Some operations, such as Goal Seek, are not allowed when
gt; worksheets are grouped.
gt;
gt; Right-click on a sheet tab and choose UnGroup Sheets. Note,
gt; though, that you may well have already made changes to all the
gt; group sheets.
gt;
gt;
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt;
gt;
gt; quot;Janinequot; gt; wrote in message
gt; ...
gt; gt;I am intrigued with a fact:
gt; gt; I have an Excel book from a student in which the Goal Seek
gt; gt; oprion is dimmed
gt; gt; out and I would like to know why. I have also noticed that on
gt; gt; the title bar
gt; gt; there is the following text after the book name: [Group]
gt; gt; Thank you for any help you can provide!
gt; gt;
gt;
gt;
gt;