increase font on formula bar

Hi,
Is it possible to increase the font size on the formula bar without affecting the cells font size  ?
If so how ?
Thanks
Ian
raceproretiredAsked:
Who is Participating?
 
☠ MASQ ☠Commented:
Yes, but temporarily it will affect all fonts in Excel.  Provided you have saved a workbook prior to making the changes you can revert all the other fonts afterwards by loading that. Start with a small change (Excel defaults to 11pt for normal use).
http://pakaccountants.com/increase-font-size-in-excel-formula-bar-quick-tip/
1
 
JohnBusiness Consultant (Owner)Commented:
What version of Windows?  With the latest version of Windows 10 you can set the scale factor. 125% on my high resolution works very nicely for Excel and all Office and most other applications.
1
 
raceproretiredAuthor Commented:
Hi Masq,
The suggestion in the link doesn't work for me. When I reopen the workbook it still shows a big
font for all cells and formula bar. The are linked by the sounds of it.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
raceproretiredAuthor Commented:
Hi John,

I am using Win 8.1.  I often have to edit long formulas and results in eyestrain.
On the other hand I need to display as many rows and columns as possible so size 11 works fine.
At the moment I copy the formulas to a notepad and edit them that way.
0
 
JohnBusiness Consultant (Owner)Commented:
You need to use the Excel tools to adjust fonts but that may adjust other aspects as well. Less choice with Windows 8 or 7
1
 
raceproretiredAuthor Commented:
It appears nothing can be done for WIN OS other than 10.
0
 
JohnBusiness Consultant (Owner)Commented:
Older systems require text size changes in individual applications
1
 
raceproretiredAuthor Commented:
Can I change one worksheet where font size for formula bar is say 18 and cells remain at 11  ?
If that is possible then what are the steps ?
Thanks
0
 
JohnBusiness Consultant (Owner)Commented:
You need to follow the method MASQ set out above
1
 
raceproretiredAuthor Commented:
I followed the instructions on the link and it doesn't work. I did comment on that earlier.
0
 
☠ MASQ ☠Commented:
When you open the older workbook (saved before the changes - not one open when making the changes) everything is still too big?
Which version of Excel are you using in 8.1?
0
 
raceproretiredAuthor Commented:
Thanks guys for your input. All works fine now.
Ian
0
 
JohnBusiness Consultant (Owner)Commented:
You are very welcome and I was happy to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.