#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Line Height

Can anyone tell me how to make each line less tall?
I have the character size set to 9 but want to make each line less tall, to
fit more on a page.
Thanks for any help.
Larry
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Line Height

Select the cell
Format|row|rowheight
and type the size you want.

You can also use the lines between the row numbers on the left hand side.

Just click and drag where you want. (same with columnwidths)

You can even double click on that line and have the row (or column) autofit.

Longwell wrote:

Can anyone tell me how to make each line less tall?
I have the character size set to 9 but want to make each line less tall, to
fit more on a page.
Thanks for any help.
Larry


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default Line Height

Hi,

1. If your font size is 9 but you want the row height smaller then change
the font size and best fit the rows.
2. If all you want to do is see more on screen then use the Zoom command,
View, Zoom
3. If all you want to do is get more on a page at printout choose File, Page
Setup, on the Page tab under Scalling change the Adjust to.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Longwell" wrote:

Can anyone tell me how to make each line less tall?
I have the character size set to 9 but want to make each line less tall, to
fit more on a page.
Thanks for any help.
Larry

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
the row height should be excatly the height of the data jaggu Excel Discussion (Misc queries) 2 November 6th 08 10:30 PM
need to dbl row height without changing height of cell next to it Excel-Illiterate New Users to Excel 1 May 16th 06 01:08 AM
Superscript of 1 number changes line height--losing top of charac. A T Excel Discussion (Misc queries) 1 October 24th 05 08:12 PM
Resizing row height to dynamically fit height of text box Jon Excel Discussion (Misc queries) 1 August 8th 05 01:37 PM
resize row height and column height Tom Setting up and Configuration of Excel 3 April 3rd 05 02:03 PM


All times are GMT +1. The time now is 06:57 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"