ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change row height to 16.0? I get choice of 15.6 (26 Pix. (https://www.excelbanter.com/excel-discussion-misc-queries/1488-how-do-i-change-row-height-16-0-i-get-choice-15-6-26-pix.html)

jlloyd

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.

Frank Kabel

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.



Gord Dibben

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.



Jon Peltier

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.





Gord Dibben

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.






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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com