Copy several row headers to rows (blank) below for each header

  • Thread starter Thread starter Rechie
  • Start date Start date
R

Rechie

Efficient and fastest way to copy several row headers to rows below (maybe 2
or more blank rows) for each header.
Thanks
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How do I add rows and headers to several worksheets automatically 1
Display index of column headers in column A 9
Excel Help to copy information from one row at a time to another sheet 1
Showing Letters For Column Headers Rather Thann Numbers ? 1
After Macro runs, no cell activated - what am I missing? 2
Insert Row 2
Header rows 4

Back
Top