Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

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

How to Format Text in an Excel Spreadsheet. Excel's text formatting capabilities can make the results of your financial, statistical or scientific spreadsheet calculations more esthetically ...

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.

A. Format cells that meet these value conditions 1. Open a sales spreadsheet or enter a dozen names with sales totals for the first four months of 2017; that is, Jan, Feb, Mar, and Apr.

Format numbers in Thousands, Millions, or Billions in Excel To format numbers in Thousands, Millions, or Billions in Excel, follow these steps: Open the Excel spreadsheet and select cells.

How to Change Date Format in a Google Spreadsheet. Google spreadsheets, like their Microsoft Excel counterparts, give you the power to tailor data to suit your business needs. Numbers, currency ...

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

The problem: Using conventional techniques, conditional formatting allows you to specify a range of cells that will determine the formatting within the same spreadsheet; the data usually cannot be ...

Locking cells in a Microsoft Excel spreadsheet is among the most commonly used functions. Here’s a guide on how to lock cells in Excel.