News

There are numerous ways to change column widths in Excel, but did you know you can force Excel to do this automatically when you add or remove data? In this example, Excel's default column width ...
How to Format Fractions to Percentages in Excel. The cells in a Microsoft Excel spreadsheet can hold various types of numerical data, including fractions and percentages.
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.
Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.
How to Auto Populate the Date in Excel. When you're setting up a Microsoft Excel spreadsheet that contains date information, you'll speed your task if you let Excel do the tedious work of filling ...
Learn how to autofit comment box in Excel using Format Comment option &VBA Code. This automatically resizes comment box to fit comment text.
Formulaic conditional formatting rules in Microsoft Excel can be tricky, so learn how to avoid a common mistake.
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.
Excel provides over 16 dozen geometric shapes that you can size and manipulate to your specific needs, plus hundreds of special effects.