 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Tabs on bottom of sheet are all white in Group Mode.
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!!  Signatureakkrug The white tabs are the selected tabs. See http://www.contextures.com/xlfaqApp.html#Unused SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >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 [quoted text clipped - 8 lines] > > Thanks for the help!! 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. Signatureakkrug > The white tabs are the selected tabs. > [quoted text clipped - 12 lines] > > > > Thanks for the help!! Only via system settings I think. SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Is there a way to set the default color for tabs on the spreadsheet. I > don't [quoted text clipped - 30 lines] >> > >> > Thanks for the help!! 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 >Only via system settings I think. Of course! I might even do that myself, never have liked the grey <bg> SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > OP could create a workbook Template with colored sheet tabs if running > 2002 or [quoted text clipped - 32 lines] > >>Only via system settings I think. 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 > Of course! I might even do that myself, never have liked the grey <bg> > [quoted text clipped - 43 lines] > > - Show quoted text - 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 > Is there a way to set the default color for tabs on the spreadsheet. I > don't [quoted text clipped - 30 lines] >> > >> > Thanks for the help!!
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.