ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I get an address in one cel and vertical? (https://www.excelbanter.com/excel-discussion-misc-queries/17516-how-can-i-get-address-one-cel-vertical.html)

Joffrey

How can I get an address in one cel and vertical?
 
I like to put an address in one cell (ex. A1) and another address in the cel
beneed it (ex. A2). So If I need an address to copy, I just have to copy one
cel.

RagDyeR

Not a good idea to do this, but use
<Alt <Enter
to allow your data to be entered on new lines within a cell.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Joffrey" wrote in message
...
I like to put an address in one cell (ex. A1) and another address in the cel
beneed it (ex. A2). So If I need an address to copy, I just have to copy
one
cel.




All times are GMT +1. The time now is 06:00 AM.

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