Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 8th 04, 01:39 PM
jlloyd
 
Posts: n/a
Default How do I change row height to 16.0? I get choice of 15.6 (26 Pix.

In an excel sheet I need the row heights to be 16.0. I select the rows and
go to Format, Row, Height and type 16.0. When I check the row height it will
be 16.2. I can take the cursor and try to change an individual row height
and it will let me choose 15.6 (26 Pixels) or 16.2 (27 Pixels). I have
changed the screen resolution and it did not help and I have tried to change
print resolution but am only given 600dpi as a choice.

  #2   Report Post  
Old December 8th 04, 10:26 PM
Frank Kabel
 
Posts: n/a
Default

Hi
AFAIK 1 pixel is the smallest increment you can use.

--
Regards
Frank Kabel
Frankfurt, Germany

"jlloyd" schrieb im Newsbeitrag
...
In an excel sheet I need the row heights to be 16.0. I select the

rows and
go to Format, Row, Height and type 16.0. When I check the row height

it will
be 16.2. I can take the cursor and try to change an individual row

height
and it will let me choose 15.6 (26 Pixels) or 16.2 (27 Pixels). I

have
changed the screen resolution and it did not help and I have tried to

change
print resolution but am only given 600dpi as a choice.


  #3   Report Post  
Old December 8th 04, 10:49 PM
Gord Dibben
 
Posts: n/a
Default

Must be a Windows Display or Printer Setting.

I have no problem making row height of 16.0 stick.

Excel 2002

Gord Dibben Excel MVP

"jlloyd" schrieb im Newsbeitrag
...
In an excel sheet I need the row heights to be 16.0. I select the

rows and
go to Format, Row, Height and type 16.0. When I check the row height

it will
be 16.2. I can take the cursor and try to change an individual row

height
and it will let me choose 15.6 (26 Pixels) or 16.2 (27 Pixels). I

have
changed the screen resolution and it did not help and I have tried to

change
print resolution but am only given 600dpi as a choice.


  #4   Report Post  
Old December 9th 04, 03:20 AM
Jon Peltier
 
Posts: n/a
Default

Hey Gord -

You using Windows Display setting Large Fonts or Small Fonts? The conversion from
pixels to points is different (sthg like 0.8 pts/px for large fonts and 0.75 for
small, but don't quote me).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Gord Dibben wrote:

Must be a Windows Display or Printer Setting.

I have no problem making row height of 16.0 stick.

Excel 2002

Gord Dibben Excel MVP


"jlloyd" schrieb im Newsbeitrag
...

In an excel sheet I need the row heights to be 16.0. I select the


rows and

go to Format, Row, Height and type 16.0. When I check the row height


it will

be 16.2. I can take the cursor and try to change an individual row


height

and it will let me choose 15.6 (26 Pixels) or 16.2 (27 Pixels). I


have

changed the screen resolution and it did not help and I have tried to


change

print resolution but am only given 600dpi as a choice.




  #5   Report Post  
Old December 9th 04, 04:47 PM
Gord Dibben
 
Posts: n/a
Default

Jon

Display........96 DPI

Screen Resolution.........1024 x 768

Appearance
Windows and Buttons.....Windows Classic
Color Scheme.....Windows Standard
Font Size.....Normal

Running Windows XP Pro with SP2

Gord

On Wed, 08 Dec 2004 22:20:39 -0500, Jon Peltier
wrote:

Hey Gord -

You using Windows Display setting Large Fonts or Small Fonts? The conversion from
pixels to points is different (sthg like 0.8 pts/px for large fonts and 0.75 for
small, but don't quote me).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Gord Dibben wrote:

Must be a Windows Display or Printer Setting.

I have no problem making row height of 16.0 stick.

Excel 2002

Gord Dibben Excel MVP


"jlloyd" schrieb im Newsbeitrag
...

In an excel sheet I need the row heights to be 16.0. I select the

rows and

go to Format, Row, Height and type 16.0. When I check the row height

it will

be 16.2. I can take the cursor and try to change an individual row

height

and it will let me choose 15.6 (26 Pixels) or 16.2 (27 Pixels). I

have

changed the screen resolution and it did not help and I have tried to

change

print resolution but am only given 600dpi as a choice.






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



All times are GMT +1. The time now is 05:31 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017