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 Delete Functions in Excel. Excel uses the Visual Basic for Applications (VBA) language to generate functions used within the spreadsheet. Most developers use Excel functions to automate ...

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need to know.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

Clean spreadsheets improve data analysis and efficiency. Learn how to remove empty rows in Excel with quick, easy steps for a streamlined workflow.

Learn how to create, delete & use a Custom List in Excel. If your work requires typing specific lists repeatedly, you can create Custom Lists to save your time. Learn how!