Fortunately, Excel 2007 enables you to select all pages and copy formatting to all of them. This method allows you save precious time and ensure formatting is consistent across all sheets.

You don’t need to manually re-enter Excel spreadsheet data in another workbook. Learn how to copy a worksheet to another workbook here.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

Method for Excel 2010 For Excel 2010, right-click on the cell that contains the conditional formatting to move to other cells. Click Copy from the pop-up menu.

The Microsoft Excel Status Bar is now more advanced than before with the new ability to copy and paste values.