Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an excel sheet with Column A rows 1 through 15 having the bottom of
each cell with a bottom border. The column width is 32. What I am looking for is if you type in A1 and it goes to the end of the cell how can you make is continue in A2 and so on. I am looking for doing this instead of a merge cell or wrap text because I want to keep the format of the underlines under each text and that is what the bottom borders is doing for me. Thank you |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What you are asking for is not supported. There is no way to skip to another
cell automatically while editing a cell. -- HTH... Jim Thomlinson "Jeremy" wrote: I have an excel sheet with Column A rows 1 through 15 having the bottom of each cell with a bottom border. The column width is 32. What I am looking for is if you type in A1 and it goes to the end of the cell how can you make is continue in A2 and so on. I am looking for doing this instead of a merge cell or wrap text because I want to keep the format of the underlines under each text and that is what the bottom borders is doing for me. Thank you |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You could type it all in one cell then wrap text and row autofit with
underline enabled. No need for borders if all you want is the text underlined. Otherwise you would need event code to split the text into individual cells at a designated character length. Gord Dibben MS Excel MVP On Wed, 6 Jan 2010 05:46:01 -0800, Jeremy wrote: I have an excel sheet with Column A rows 1 through 15 having the bottom of each cell with a bottom border. The column width is 32. What I am looking for is if you type in A1 and it goes to the end of the cell how can you make is continue in A2 and so on. I am looking for doing this instead of a merge cell or wrap text because I want to keep the format of the underlines under each text and that is what the bottom borders is doing for me. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto row height a cell with wrap text enabled and a lot of charact | New Users to Excel | |||
Auto fit row height and Word Wrap | Excel Worksheet Functions | |||
Why won't text in cell wrap. Cell format set to wrap. | Excel Discussion (Misc queries) | |||
Auto-wrap text showing #####. | Excel Discussion (Misc queries) | |||
Auto Text Wrap in a Cell | Excel Discussion (Misc queries) |