format text on worksheet tab

R

Rose

I recently had my computer re-imaged (or profile reformatted?) and am now
picking up the pieces, so to speak. I'd like reformat the default text used
when renaming Excel spreadsheets. I can obviously set the worksheet
defaults, but haven't been able to troubleshoot the tab text specifically.
anyone come across this "problem" before?
 
G

Gord Dibben

How can you "obviously set the worksheet defaults" and what do you mean by
"renaming Excel spreadsheets"?

Sheet Tab fonts and sizes are determined by your Windows Display settings
and cannot be changed within Excel alone.

Size is controlled by ScrollBar sizing in Display>Appearance>Advanced>Item

Any change here is a global change for all Windows OS

Font type is also controlled by Display>Appearance which is a global change.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 crashes on copying worksheet to new workbook 0
Excel 2007 Format issue, colons being substituted for decimals. 1
Extract number from text string based on number's format? 16
retain custom date format "text" when pasting or reformatting data 2
MS Query in Excel 1
How to insert line of text on other worksheet depending upon result in a cell? 3
How to change default cell format to "Text" 2
Format Cells Does Nothing 4

Top