View Single Post
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default Excel should have vertical and horizontal rulers.

Excel is not good at things requiring exact measurements because it is
a spreadsheet. That may not fit into everyone's expectations because
there are other spreadsheets that are more tightly integrated with a
word processor.

Excel column widths are based on character width. You may or may not
have noticed that almost all fonts have numeric digits with the same width
so that numbers line up nicely in columns. So your measurement is the
width of the "n" character or a digit (I think they are the same). The
font size default is defined in Tools, Options, General
default font and font size.

If you want exact measurements then Microsoft expects you to use
Microsoft Word for printing -- as in printing Address Labels.

If you are interested in printing Address labels from MS Word
using the Mail Merge feature of Word you might be interested in my page.
. Mail Merge, Printing Labels using Mail Merge with data from Excel
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

Things like autofit, Shrink to fit, headers and footers, variations in
margins and fonts on different printers make it very difficult to get
consistent results when printing Excel spreadsheets. This may be
one of the reasons that the Adobe Acrobat (PDF) format is popular
you can print the same thing on different printers -- though it may look
the same it probably would not be good for printing (adhesive/gummed) labels..

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mgobluefanatic1" wrote in message
...
Excel, like Word should have vertical and horizontal rulers. Cell width and
height should also be able to be measured in inches. I don't understand why
this hasn't been already implemented into Excel.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...lic.excel.misc