Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy several row headers to rows (blank) below for each header
Efficient and fastest way to copy several row headers to rows below (maybe 2
or more blank rows) for each header. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy several row headers to rows (blank) below for each header
Rechie,
Select all the cells, then use Edit / Go To.... Special Blank Cells OK then type = and select the header cell of the column with the current active cell, then press F4 until you get a $ in front of the row (say, like =A$3) and press Ctrl - Enter. Then if you want to convert those cells to values, copy all the cells and paste special values.... HTH, Bernie MS Excel MVP "Rechie" wrote in message ... Efficient and fastest way to copy several row headers to rows below (maybe 2 or more blank rows) for each header. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy from one sheet to another and skip the blank rows | Excel Discussion (Misc queries) | |||
Macro to copy previous row and insert two blank rows | Excel Discussion (Misc queries) | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Copy rows of data to another worksheet where ReturnDate is blank | Excel Discussion (Misc queries) | |||
Activate a macro to insert a row and copy the formuals from the rows above to the blank row | Excel Discussion (Misc queries) |