It’s not easy to fool Excel, but with a few extra clicks, you can work around this odd pasting behavior. If you paste formatted values into a cell with another applied format, the pasted format wins.

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. Microsoft Excel has a ...

Microsoft Excel lets you format tables, adding borders and colors, and lets you format the text in them, editing font, size and style. A spreadsheet may contain a number of tables, giving you several ...

If you have multiple sheets in your Microsoft Office Excel 2007 workbook, you can spend a lot of time editing the format of each page. Fortunately, Excel 2007 enables you to select all pages and copy ...

One custom format field can scale numbers, add icons, apply color rules, and clean up visual clutter instantly.