Want to highlight Cell or Row if a checkbox is selected? We show you hHow to highlight a Cell or Row with a Checkbox in Excel.

How Do You Create a Header Row & Description Row in an Excel Spreadsheet?. Your Excel 2013 spreadsheets can benefit from page headers and fixed column titles, also called description rows.

One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the ...

Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without ...

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

Once I create the header row at the top, I can easily filter out which tasks are done or not based on whether the checkbox is ticked (True) or unticked (False).

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

Excel's checkboxes seem like a very simple feature on the surface—which is probably why they're often overlooked. But when used properly, this underrated feature can transform your spreadsheets into ...