MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Shortcut to swap cell contents of two rows


Posted by Wowblagger on October 22, 1999 4:10 AM

Does anyone know if there is a shortcut in Excel to swap the contents of Column a, row2 with that in Column A, row1. While this is easy to write in VBA, there MUST be a shortcut! I am using Excel '95.


Posted by judi on October 22, 1999 12:49 PM

I am not sure if this is your question, but did you try Cut (cell a2) then click on cell a1 and Insert Cut Cells. I am working in excel 97 and I am not sure this applies in 95.