Excel Tip 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.

Comments

  1. Faridul

    Hi,
    Hope you are doing well.
    Could you pls help me on below concern?
    How can I highlight entire row depending on value in one cell?

Leave a Reply to Raghu R Cancel reply

Your email address will not be published. Required fields are marked *

three × four =

This site uses Akismet to reduce spam. Learn how your comment data is processed.