| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How To Copy Text To Other Cells
sumesh56 laid this down on his screen :
'GS[_2_ Wrote: ;1600584']Try... Select A2:A5 Type =$A$1 Press Ctrl+Enter -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion thank you very much for the suggestion. it works. but no need for the absolute cell reference. it works like this i typed mar-12 in A1 then i select A2 :A10 then i typed = then i clicked on cell A1 then press control and enter. done! now if i change the content in cell A1 to jul-12 it will automatically appear in cells A1:A10. thanks once again. That approach results in each cell referencing the cell above, NOT A1. So A3's formula is =A2; A4's formula is =A3; and so on. My sugeestion makes the formula in all cell ref A1... -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy text out of a range of cells | Excel Worksheet Functions | |||
| copy text from cells into different textboxes | Excel Programming | |||
| copy text of cells down to blank cells | Excel Programming | |||
| how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
| If Cell equals text Copy Cells, B2,B3,B4 | Excel Programming | |||
![GS[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
