| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight / Copy down a long row?
If you want the same value in all blank cells.....................
Select column A and F5SpecialBlanksOK Enter your value in active blank cell then CTRL + ENTER Gord Dibben MS Excel MVP On Wed, 24 Oct 2007 11:31:01 -0700, chris wrote: I work with spreadsheets where I have to copy a value into the cells down a long blank column next to another long row. How do you highlight the range of cells to copy into? I thought you could also highlight a blank cell (A) and a filled cell (B) to anchor, then hit shift and down arrow to get a full range a1...b1000, then move the cursor from B1000 to A1000 to get only the A column to paste into... Does that question make sense? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Titles in a long list of rows | Excel Discussion (Misc queries) | |||
| Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
| my sheet takes too long to copy as it has macros | Excel Discussion (Misc queries) | |||
| need to copy a long list of file names | Excel Discussion (Misc queries) | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
