Tabs on bottom of sheet are all white in Group Mode.

[Guest]

I have a workbook file with multiple spreadsheets. When selecting more than
one at a time, the tabs all stay white so I can't tell which ones are
included in the group mode and which aren't. How can I get the selected
sheet tabs to display in a different color so I know which ones are or are
not selected in the Group Mode. I know the sheet is at least in Group mode by
the message next to the file name. Also, is there any way to re-set the
bottom of the sheet. Sometimes when I hit ctrl end home to go to the bottom
of the sheet, it goes well beyond the last cell with information in it.

Thanks for the help!!

 

[Bob Phillips]

The white tabs are the selected tabs.

See http://www.contextures.com/xlfaqApp.html#Unused

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Is there a way to set the default color for tabs on the spreadsheet. I don't
remember having to set colors for the tabs on the spreadsheet so it is easy
to see which cells are selected and which are not. I could set the tabl
color for all sheets, but I don't remember ever having to do this before.
Without coloring the tabs, how do we tell which sheets are selected for
group mode and which ones aren't.

Thanks for the help!!

Ken K.

 

[Bob Phillips]

Only via system settings I think.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[George Gee]

The default colour for the sheet tabs is the colour of the rest of the outer
window.
If you select a sheet, the default colour of the selected sheet tab is
white.
If you select or group two sheets, the default colour of the selected sheet
tabs is white.
If you select or group three sheets ................ etc..

George Gee

 

[Gord Dibben]

OP could create a workbook Template with colored sheet tabs if running 2002 or
newer.

This would make all "New" workbooks with the colored Tabs.

File>Save As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for File>New or the Toolbar button File>New or
CTRL + n

WARNING................Do not use File>New...Blank Workbook or you will get the
Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default Insert>Sheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP

 

[Bob Phillips]

Of course! I might even do that myself, never have liked the grey <bg>

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Pete_UK]

I've found with some projectors that the tab colours show white, not
grey, in the projected image - difficult to demonstrate (to students)
that the tab colours change to white when you select them as a
group !! <bg>

Perhaps the OP is suffering from a similar situation on his monitor -
is there some contrast setting he could try?

Pete