If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
what row do I start an address for a window envelope?
nDoes anyone have any hady tips about which row on the xls spreadshet I need
to start on so the recipient's adress block shows when I fold the invoice and post in a DL window envelope? |
#2
|
|||
|
|||
what row do I start an address for a window envelope?
Open a new workbook and put this formula into cell A1:
=ADDRESS(ROW(),COLUMN()) then fill (drag) that formula over several columns and down several rows. Print page 1 of the sheet, fold it up and see what addresses show through the window. That should give you an idea of about where to stop. Of course, once you format your actual worksheet later, that could change some, but you may be able to adjust somewhat by adjusting the height of some rows. "Lindsay 1957" wrote: nDoes anyone have any hady tips about which row on the xls spreadshet I need to start on so the recipient's adress block shows when I fold the invoice and post in a DL window envelope? |
Thread Tools | |
Display Modes | |
|
|