If your Excel spreadsheet freezes when copying and pasting, Uncheck Show cut, copy and paste options, Disable the Live Preview option, etc.

Applying the same formatting to each sheet in an Excel workbook is ideal when each of your sheets is set up the same, but it can be helpful in other circumstances as well.

The error "Too many different cell formats" in Excel occurs when the data in Excel exceeds the formatting limit. Here are some solutions to try.

In Excel, you can apply direct formatting to cells' values or backgrounds to make the spreadsheet easier to read. However, when an Excel formula returns a set of values—known as a spilled array ...

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.

Combine an Excel custom format with data validation and remove the pressure for input perfection from personnel by letting Excel do the work.