anything in Excel...

It's Excel-o-lozy...

Shortcut - Insert Cell contents between two ranges.

Mostly we need to cut and insert data between two ranges.

See the image at right.
We need to insert data between column A and B from column F.

Select the data in column F
Press Ctrl+X, come to cell C3, press Ctrl+Shift+"="
It ll shift contents of C3:C8 rightward and insert contents of Column F in Column C, See the result image.

0 comments: