exchanging rows

N

nada

hi, i want to know if there is a way that enables me to exchange two rows in
a worksheet including there functions and formats.
 
B

Bernie Deitrick

Select the first row, hold down the shift key, grab the thick border, and drag the row up or down to
where you want it. Then do the same thing for the second row.

HTH,
Bernie
MS Excel MVP
 

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

Outlook calendar list 0
Repeating a row other than the 1st row as the header row in a table from next page 1
Address Format changed after Migration 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Dealing with a Pivot Table (when I don't want to) 0
Indenting every other paragraph in Word at the same time? 0
Changing row background from external program 0
Need Help with a VBA subroutine 0

Top