If you want to show or hide the list of formulas while typing in an Excel spreadsheet, here is how you can do that. You can enable or disable the autocomplete of ...

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions. One of the ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

Maintaining an Excel spreadsheet of computer files can help you keep track of important business documents or images. Unfortunately, Microsoft Excel doesn't include a one-step method for importing a ...

We all can admit that Microsoft Excel is the best tool in its class, but there are ways to improve it with some cool and free Excel add-ins from the store. Some of these add-ins do basic things, while ...

Numbers affect your business's success, and Excel helps you manage your numbers. Whether your spreadsheets contain sales figures or employee names, you may need to need to count values in a ...

Excel percentage formulas can get you through problems large and small every day—from determining sales tax (and tips) to calculating increases and decreases. We’ll walk through several examples below ...