View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Increase font size within my formula bar

Here are some thoughts you might look into - no guarantees:
go to windows and right click on the background - select options, go to the
appearance tab, select the the font dropdown and see your choices.

I believe this will work for your menus. It didn't work for icons or
formulas in the formula bar.

for the worksheet, go to style under the format menu and redefine the normal
style. If you want that as a default, create a Book.xlt and Sheet.xlt
templates in the templates directory with those settings.

If you don't want to send wide workbooks, then don't fill the screen before
you save them. Make them narrower and then save.

--
Regards,
Tom Ogilvy




"Dean" wrote:

I finally replaced my old CRT style monitor whose brightness had gotten
really bad with a 19" flat panel. I didn't realize until I'd gotten it home
that it is a widescreen one and am not sure if that is good or bad - any
thoughts, given that most of what I create is delivered to end users who may
not have widescreens?. I am older and often need reading glasses though, by
sitting aways from my monitor and playing with settings, I can usually avoid
using them. I actually prefer the 800 by 600 display resolution but, on
the new monitor, I really notice some fuzziness in the characters! Since
95% of what I do is in EXCEL, I have a few questions to ask this forum:

The monitor recommended 1140 by 900 resolution and I am trying to adapt to
that, since it seems to create the sharpest characters, albeit small ones.
I program hairy equations in EXCEL and spend most of my time editing
equations in the formula bar. Though I can easily change the size of the
EXCEL display to suit my tastes, I don't seem to be able to increase the
size of the characters within the formula bar which are too small to read
comfortably - is there a way to do that, short of resetting the display
resolution via the control panel?

Within the worksheet itself, I assume it is a bad idea to use a larger font,
say, 12 or even larger since, if end users view it - and mostly my templates
are used by a few end users - it will not be as sharp. Isn't that right?

I do get confused about what happens when I send my spreadsheets to someone
else, which I almost always do. I assume that, if my screen is wider than
theirs, they will not see all that I do unless they use a different
resolution. But doesn't almost everyone older - most of my end users are
older - use a different resolution anyway? Any thoughts?

When I am getting ready to print, I am never sure about whether WYSIWYG. I
use a lot of borders within my spreadsheets and sometimes the words seem too
wide for the border on my monitor, but may not be on the hard copy. And I
don't want them to be too wide on the monitor of my end users either. I
know I can use print preview but that also seems to not exactly show
everything that prints on hard copy. Are there certain settings that
guarantee that the size I see on the screen is how it will print? It even
seems to vary by which printer I use.

I realize that some of these questions are pretty stupid. If so, the one
about the formula bar is the one that is most important. You can ignore the
rest!

Thanks!
Dean