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/column, select the cell/row/column where you want to paste the data.

•If the clipboard contains a range of cells/rows/columns, select the appropriate size range or select the cell/row/column where you want to paste the contents of the first cell/row/column in the range.

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

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

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

•When working in macOS, select the Edit > Paste command from the command menu.

•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.

•Right-click the selected cells or the titles/contents of the selected rows/columns to open the context menu. Select Paste from the context menu.

•Press Ctrl+V or Shift+Insert (Windows, Linux) or  Cmd+V (macOS).