Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...

In my post on table formatting, I demonstrated how to transform your static data into a simple yet sexy database in a matter of seconds. If you don’t know how to use table formatting, go read that ...

White space appears as empty area within an Excel 2003 cell and it can be created by text or formatting. Textual white space consists of manually entered extra spaces or lines within the cell. Excel ...

To clear all contents, formats, and comments in the selected cells, click Clear All. To clear only the formats that are applied to the selected cells, click Clear Formats. To clear only the contents ...

Microsoft Excel offers a plethora of features to organize, analyze, and present data. One such feature is the ability to format data as tables. Tables not only enhance the visual appeal of your data ...

Although Google Sheets and Excel Online are two of the best free online spreadsheets editing apps, you may not like certain features of them. For example, the date format. In case you do not want to ...

Throwing a lot of work into a shared Excel sheet can be rewarding, which is why it’s even more soul-crushing to wake up one day to find it destroyed. Unfortunately, whether by accident or malice, ...

If you want to know how to hide cells in Excel, we’ve got you covered right here. Microsoft Excel is the go-to software for any companies or small businesses that need to keep track of their ...

Locking cells in a Microsoft Excel spreadsheet is a super useful thing to know how to do. It’s used to protect a certain segment or an entire worksheet from being modified by anyone other than the ...