LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default automaticaly increase the row spacing in xcel

a simple hack:
insert a column (or use an empty one :)
set fontsize a bit larger than standard text (16?)

et voila.. higher rows..

using format/row/autofit.. wont 'destroy' your layout.


PS: setting font size does alter usedrange thus filesize
so keep your column close to the data and dont use IV.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Stanley wrote :

I want to increase the row spacing from the standard spacing which is
contingent on the lines of text to the standard plus a line or 2 in
order to have more white space between the items in each row. We do
it manualy now how do you do it automaticaly



 
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
Regarding Xcel rchennag Excel Discussion (Misc queries) 1 March 5th 10 05:49 PM
Excel: How to increase line spacing in a document Felix12.2007 Excel Discussion (Misc queries) 2 June 10th 09 06:24 PM
Increase spacing above contents of cell Annie1904 Excel Discussion (Misc queries) 0 March 6th 08 07:44 PM
Number in cell increase with increase in font size. Value increases with increase in font.[_2_] Excel Discussion (Misc queries) 2 August 9th 07 01:58 PM
Xcel bw Setting up and Configuration of Excel 1 September 7th 05 01:53 AM


All times are GMT +1. The time now is 08:02 PM.

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"