Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2
Default How do I set the default tab fill in excel?

I have a flat panel monitor and it is very hard to diferentiate what tabs I
have selected by holding down shift or control and what are not selected for
a multiply copy, move, delete, etc. I would like to change the default tab
fill to a darker grey but cannot seem to find this anywhere. Also, changing
the angle of how I veiw the monitor does not help as the top of the screen
then is darker. Any help would be appreciated.
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
Default How do I set the default tab fill in excel?

The color of Tabs are determined by your Windows Color Scheme in Display
PropertiesAppearance.

You can, if using Excel 2002 or 2003, color the tabs by selecting all tabs and
right-click and "Tab Color".

To make this default, you could create a Template for all new workbooks.

Open a new workbook. Customize as you wish. FileSave
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 FileNew or the Toolbar button FileNew

Do not use FileNew...Blank Workbook or you will get the Excel default workbook.

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 InsertSheet.

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

For second question.........I have not heard of a method of changing the default
on these.


Gord Dibben Excel MVP

On Tue, 29 Aug 2006 06:19:02 -0700, rjdrw
wrote:

I have a flat panel monitor and it is very hard to diferentiate what tabs I
have selected by holding down shift or control and what are not selected for
a multiply copy, move, delete, etc. I would like to change the default tab
fill to a darker grey but cannot seem to find this anywhere. Also, changing
the angle of how I veiw the monitor does not help as the top of the screen
then is darker. Any help would be appreciated.


Gord Dibben MS Excel MVP
  #3   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2
Default How do I set the default tab fill in excel?

Thanks, I use Autocad 80% of the day and the options in this changes the tab
color along with all the toolbars and menus. Would be nice to have this
happen in the future releases of excel.

"Gord Dibben" wrote:

The color of Tabs are determined by your Windows Color Scheme in Display
PropertiesAppearance.

You can, if using Excel 2002 or 2003, color the tabs by selecting all tabs and
right-click and "Tab Color".

To make this default, you could create a Template for all new workbooks.

Open a new workbook. Customize as you wish. FileSave
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 FileNew or the Toolbar button FileNew

Do not use FileNew...Blank Workbook or you will get the Excel default workbook.

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 InsertSheet.

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

For second question.........I have not heard of a method of changing the default
on these.


Gord Dibben Excel MVP

On Tue, 29 Aug 2006 06:19:02 -0700, rjdrw
wrote:

I have a flat panel monitor and it is very hard to diferentiate what tabs I
have selected by holding down shift or control and what are not selected for
a multiply copy, move, delete, etc. I would like to change the default tab
fill to a darker grey but cannot seem to find this anywhere. Also, changing
the angle of how I veiw the monitor does not help as the top of the screen
then is darker. Any help would be appreciated.


Gord Dibben MS Excel MVP

  #4   Report Post  
Posted to microsoft.public.excel.setup
 
Posts: n/a
Default How do I set the default tab fill in excel?

Hi -- I'm a different poster. I followed these directions. My custom
colors are there whenever I open a new workbook or insert a new
worksheet. However, when I open a new file in Excel, it opens as
"SHEET.XLT" or "BOOK.XLT" andd defaults to the STARTUP folder. So it
seems that these custom color templates want to overwrite themselves.

I'm using Excel 2000.

Can you suggest what I should do to keep the custom color palette that
I created?

Thank you.

<*(((<



On Tue, 29 Aug 2006 09:01:35 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

The color of Tabs are determined by your Windows Color Scheme in Display
PropertiesAppearance.

You can, if using Excel 2002 or 2003, color the tabs by selecting all tabs and
right-click and "Tab Color".

To make this default, you could create a Template for all new workbooks.

Open a new workbook. Customize as you wish. FileSave
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 FileNew or the Toolbar button FileNew

Do not use FileNew...Blank Workbook or you will get the Excel default workbook.

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 InsertSheet.

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

For second question.........I have not heard of a method of changing the default
on these.


Gord Dibben Excel MVP

On Tue, 29 Aug 2006 06:19:02 -0700, rjdrw
wrote:

I have a flat panel monitor and it is very hard to diferentiate what tabs I
have selected by holding down shift or control and what are not selected for
a multiply copy, move, delete, etc. I would like to change the default tab
fill to a darker grey but cannot seem to find this anywhere. Also, changing
the angle of how I veiw the monitor does not help as the top of the screen
then is darker. Any help would be appreciated.


Gord Dibben MS Excel MVP


Awaiting your responses with baited breath, I remain, yours truly,

<*(((<
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How to set the default color for fill in functon? Eric Excel Discussion (Misc queries) 5 May 16th 06 03:36 AM
How to fill colour in Excel, it appers No fill in my computer? bede Excel Discussion (Misc queries) 1 June 11th 05 03:27 AM
autoshape fill problems in Excel 2003 kcole Excel Discussion (Misc queries) 0 June 2nd 05 10:14 PM
Excel printing problem - won't print cell under a "fill effect" bo dmotika Excel Discussion (Misc queries) 0 May 26th 05 04:38 PM


All times are GMT +1. The time now is 01:32 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"