| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alt+Enter in cell with link to another cell
Hi friends
I know in a cell as you type you can press Alt+Enter as you are typing to show in the cell on next line so you can line up text. I also know that as a macro it shows as & Chr(10) & but I want to link to other sheet that has a few Description lines and put each line of descriptions on its one line in a cell When I enter the formula ='TAS tran'!AI2&Chr(10)&'TAS tran'!AJ2&Chr(10)&'TAS tran'!AK2 it gives a #NAME? error. How can I do in a formula to Alt+Enter so the Description lines start to the left? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hit enter in cell & move text down in cell, not go to cell below. | Excel Worksheet Functions | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| Force user to enter data in cell before moving to next cell | New Users to Excel | |||
| How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
Threaded Mode
