| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i type the same text for multiple rows
How about
1) Select cell A8 2) Type =A1 and press enter Repeat steps 1-2 for cells A9 through A14 (increase =A1 to =A2, and so on) Then enter data into A1:A7, it will be mirrored in cells A8:A14. Is that what you wanted? --JP On Oct 9, 1:39*pm, troubled wrote: i want a1:a7 to have exact info and a8:a14 to have the same also. Is there a way to input identical cells at the same time, or do i have to copy and paste |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| justify text into multiple rows | Excel Worksheet Functions | |||
| how to convert date type to text type | Excel Discussion (Misc queries) | |||
| In Excel, how do I put multiple rows of text in one cell. | Excel Discussion (Misc queries) | |||
| How to combine multiple rows of text cells into one cell | Excel Discussion (Misc queries) | |||
| vlookup multiple text rows | Excel Discussion (Misc queries) | |||
![JP[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
