I do my invoices with exel,
Sheet1 is the invoice, (text is horizontal)
Sheet2 is the envelope to be printed, (text is vertical)
What I would like to do is to copy the 4 lines of the address that I input in Sheet1 to Sheet2, without the formating as I use a different size and font in sheet2.
Also I need to insert 2 or 3 spaces before the text in the cells in Sheet2 as when I format the cell to 'top' (text is vertical) the first few characters are hidden. I don't really get why the formating does not work well. . .
I use excel 2007