You should copy and special paste only the values of the range and afterwards simply delete the cells you just copied into another location. The reason for using copy instead of cut is because Paste Special is not applicable in case of cutting.
Continue readingTag Archives: copy
How to copy formatting? | Excel 2013
Click on the cell from which you would like to copy the format. Go to home tab and Clipboard group. Select format painter. Click on the cells to copy the format.
Continue reading