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

No, I didn't say anything like that. the term resolution was never entered
in anything I have typed today. You must be thinking of someone else.

So NOT in Excel, but in Windows itself:.

What I said is that you can change the size of menus in all applications by
doing it through the windows control panel = display = appearance tab =
Advanced button. Under the item dropdown select Menu. Then increase the
font size and also possibly the height of the menu bar itself next to item.

--
Regards,
Tom Ogilvy


"Dean" wrote in message
...
Sorry. I am confused by your answer, Tom. Are you confirming that there
is no way to adjust the size of the character in EXCEL's formula bar,
other than by changing the resolution?


"Tom Ogilvy" wrote in message
...
Windows desk top, right click, choose properties, then appearance tab.

Just did it and its there.

Yes, going through the control panel is the same.


If that didn't work then In the same place, hit the advanced button and
select menu under ITEM.. Change the settings there for item and font to
make them bigger.

Change other options as appropriate.

--
Regards,
Tom Ogilvy



"Dean" wrote in message
...
I'm not sure what you mean by "go to windows". Is that within EXCEL? If
not, is it for windows XP - I tried clicking on the desktop, but these
options weren't there? In any event, is this the same as control,
display, appearance, then choose font size, either normal, large, or
very large? I did try that.

Are you saying that there is no way to deal with the size of the
characters in the formula bar in EXCEL, other than via resolution
changes?

Thanks, Tom!
D

"Tom Ogilvy" wrote in message
...
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