ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   what row do I start an address for a window envelope? (https://www.excelbanter.com/excel-discussion-misc-queries/262161-what-row-do-i-start-address-window-envelope.html)

Lindsay 1957

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?

JLatham

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?



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

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