Use Paste Special to copy Formatting

Excel Tip Use Paste Special to copy Formatting

Excel Tip Use Paste Special to copy Formatting

A quick copy trick utilizes the Paste Special feature. and the Format Painter also works great with a small range, but this trick is helpful when copying formats to an entire column or row:

1) Select the source cell and press [Ctrl]+C.

2) Click anywhere inside the destination column or row.

3) Press [Ctrl]+[Spacebar] to select the entire column or [Shift]+[Spacebar] to select the entire row. (This works only with a blank data range.)
2010: With the column or row selected, choose Formatting from the Paste drop-down (in the Clipboard group).
2007: Choose Paste Special from the Paste drop-down and click Formats in the Paste section.
2003: Right-click a selected cell and choose Paste Special from the submenu. In the resulting dialog, click Formats in the Paste section.

4) Using Live Preview, you can see what the applied formats will look like. Click OK if you decide to apply them.

You can also format a new chart using Paste Special. Select the source chart and press [Ctrl]+C.
Select the destination chart and choose Paste Special from the Paste drop-down. Choose Formats and click OK.

Show Comments

2 Comments

  1. Faridul

Leave a Reply