Paste data while maintaining the original formatting

To paste data while maintaining the original formatting, follow the steps below:

1.Select the place where you want to paste the data:

•If the clipboard contains data from a single cell, row, or column, select the cell, row, or column to insert this data into.

•If the clipboard contains a range of cells, rows, or columns, select the appropriate size range or select the cell, row, or column into which to insert the contents of the first cell, row, or column from the range.

•If the clipboard contains an object, select the cell to align the upper left corner of the object to.

2.Run the insert command in one of the following ways:

•On the Home tab, in the Edit group, click  Paste.

•On the Home tab, in the Edit group, click the arrow to the right of the  Paste button. In the drop-down list, select Paste.

•Open the context menu by right-clicking on the selected cells or on the headers or contents of the selected rows or columns. Select the Paste command from the context menu.

•Press Ctrl+V or Shift+Insert.