How to size a column in inches, see it the way it would print

  • Thread starter Thread starter Armando Ruiz
  • Start date Start date
A

Armando Ruiz

I would llike to find out how can I do this to easily
size columns and rows width and height. Seems I want to
print labels in excel, fill them up from a DAO recordset,
Because the labels are already sized and cut, if there is
an error or mis alignment they just don't print well. I
have done this in Access, but it is very inconsistent
when i move the application from one machine to another,
I've found excel very easy to use, I'm just having this
problem sizing the cells to the labels measurements. the
label's height and width are 1 in. by 2.625 in. there is
a top and bottom margin of .50 in. side margins of .25 in.
Any help will be greatly appreciated.
Thank you everyone.

Armndo
 
Armando

If you want to use VBA to set height and width in mm....

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol

It could be done in Excel only, but........

Investigate the use of Word's mailmerge feature to get Excel data to labels
and envelopes.

Doing it strictly in Excel is difficult and involves much trial and error
formatting.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm

Gord Dibben Excel MVP
 
Back
Top