Adding text to a cell using a custom format instead of typing it clearly labels the data and still lets Excel calculate it. (Click for larger image).

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

How to Enter a Subscript in Excel. Properly formatting expressions such as "H2O" in your Excel spreadsheet requires the use of subscripts. Subscript formatting makes a letter or number appear ...

Text wrapping isn't just for word processors. You can wrap text in spreadsheets too. Here's how to wrap text in Microsoft Excel using two different methods.

Add artistic effects, make corrections, add color, make images transparent, compress pictures, change pictures, reset pictures in Excel by following this tutorial.

You can change the date & time format in Google Sheets & Excel Online using this guide. Use different date & time formats in spreadsheets.

As software has grown more sophisticated, there is more opportunity for users to mash up content between different programs. The Excel spreadsheet program, for example, used to handle only text ...

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.