What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format ...

Want to to alternate row colors in Excel? You can apply color in alternate row & column in Excel spreadsheet using Conditional Formatting.

Change the default width for all columns in a worksheet by clicking the worksheet's tab at the bottom Excel and returning to the menu that displays the formatting options as described previously.

How to Join Two Columns in Excel. When you're setting up a Microsoft Excel spreadsheet to build an employee directory, calculate product margins or project sales, you may run into circumstances in ...

You can set up conditional formatting in Excel for dates. We have included detailed examples you can try while reading the guide.

If you are working with Excel files with hidden columns, it's important to learn how to unhide columns in Excel to extract maximum data.

The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.

Formulaic conditional formatting rules in Microsoft Excel can be tricky, so learn how to avoid a common mistake.

How to Remove Table Formatting in Excel, Keeping all Data, Rules, and Formulas This method is ideal for those who wish to retain the integrity of their data, including any rules or formulas they ...

Sometimes when you’re using Excel, you might have data inputted across multiple columns, and you may wish to combine columns. One of the major perks of using spreadsheet software like Excel is that ...