Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 10 of 60 · 540 articles
How to delete all named ranges with #REF Excel errors using VBA
#REF errors can be annoying. In this article, we're going to show you how to delete named ranges with #REF Excel errors using VBA.
How to do a wildcard search in Excel
If you know how your search value starts or ends, but not sure about what's in between, you can find that with a wildcard search in Excel.
How to Highlight Misspelled Cells in Excel Using VBA
Excel doesn't do as good of a job as some text editors when it comes to spellchecking. Let's show you to highlight misspelled cells in Excel.
How to Show a Welcome Message in Excel: Enhancing User Experience
In this guide, we’re going to show you how to show a welcome message in Excel by using VBA macros to enhance user experience.
Excel Keyboard Shortcuts: Top 10 Shortcuts for Excel
Although the computer mouse is an essential tool in desktop navigation, power users rarely use it to interact with their workbooks using Excel keyboard shortcuts.
How to Find Errors in Excel List?
This article shows how to find errors in an excel list using ISERROR and MATCH functions in an array formula.
How to Calculate Sum in Excel with intersecting tables
This article shows how to calculate sum with intersecting tables using SUM function and intersect operator, the space character (" ").
15 Must Know Excel Functions
SpreadsheetWeb • Keep expanding your knowledge and practice with 15 must-know Excel functions to master spreadsheets.
How to compare two columns in Excel using VBA
Comparing columns of data manually can be tedious when working with large data. Let's show you how to compare two columns in Excel using VBA.