How do I change row height to 16.0? I get choice of 15.6 (26 Pix.

G

Guest

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.
 
G

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
 
J

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/
_______
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help on formatting row height 1
How set many row heighths = height of another row 1
Row heights 4
How do I autofit row height to adjust to new text on Excel form? 1
Row Height - Forcing a Minimum ('03 & '07) 3
Changing Row Height/Column Width 4
How to copy row height? 9
Auto-adjust row height does not work correctly 2

Top