Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Adjusting height of text cells

I find that what appears on screen is different from what appears on
paper. e.g. a cell may appear on 2 lines on the screen, but on 1 line
followed by a blank line on paper. I sometimes hack to truncate the
rendering of the text on screen, so it appears sensibly on paper. I
have
asked questions on such matters without getting anything useful. As
you
say, it's not even funny


I resolved to setting the col width[s] to match my page margins so what
I see on the sheet is what I see in PrintPreview. This is usually what
prints as well, but there's almost always some (minor) line spacing
issues on the printout.

I prefer to use Arial font because I find it's much crisper, clearer,
and easier-to-read than Tahoma, generally speaking. I hate that Tahoma
is the default for userforms and so I always make a point to set Arial
right away so all the controls inherit Arial.

Ultimately, the client dictates font[s] used because it reflects
branding. Not sure I agree with that since readability has higher
priority for me. What scares me that given the monumental amount of
info floating around about eyestrain and worker fatigue, one would
think people would smarten up about their reckless use of uppercase and
garrish colors!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


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
Row height not auto adjusting on wrapped cells (Excel '07) Dave Excel Discussion (Misc queries) 2 August 5th 09 10:37 PM
Adjusting row height while wrapping text Office_user Excel Discussion (Misc queries) 0 April 5th 09 02:17 PM
Adjusting row height to accomidate text in a cell GeorgeJ Excel Discussion (Misc queries) 2 November 20th 07 12:31 AM
Automatically Adjusting Row Height in Merged Cells MGC Excel Discussion (Misc queries) 12 October 1st 07 08:19 PM
Row height is not adjusting after activating Merge Cells & Wrap Te MHPDallas Excel Worksheet Functions 1 April 9th 05 12:32 AM


All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"