Set row equal to another row

timpani · #1 07-25-2012, 02:50 AM

Hi Redbeard,

Say row 1 has the data you want to duplicate.

You can set cell A2 to be "=A$1". Then select the cell, copy, click on the left hand side of row 2 so that the whole row is selected, and paste.

Is that what you were after?

Redbeard · #2 07-25-2012, 05:37 AM

Outstanding! Thanks very much for your help. The cells that are blank in the source row show up as zero in the duplicate row. Any way around that? Thanks again for your quick help.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Does 'Save as Unicode text' equal UTF-8	Chayes	Excel	1	07-20-2012 03:07 AM
Make row in one sheet equal column of another	hypertyper	Excel	6	01-31-2012 03:48 PM
Automatically change the value of one cell so that two other cells become equal	matthew544	Excel	5	09-18-2011 08:56 AM
Dividing merge cell into ten equal rectangles for inputing Digit?	aligahk06	Excel	0	05-12-2010 06:56 AM
If A1 greater than or equal to 1 Then A3 = A2*A1	brians	Excel	5	03-09-2010 12:04 PM