Excel resources
Excel Macros
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 2 of 4 · 33 articles
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 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.
5 Ways to Create an Excel Named Range
Using named ranges make formulas easier to read and maintain. We're going to show you 5 different ways to create an Excel named range.
How to delete blank rows and columns at the end of worksheets using VBA
Learn how to delete blank rows and columns at the end of worksheets using VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
How to make Excel delete rows with value of your choosing using VBA
In this article, we're going to show you how to make Excel delete rows with value of your choosing using VBA.
How to delete all comments in Excel using VBA
Excel, just like other Office products, supports comments. Let us show you how to delete all comments in Excel using VBA.
How to make Excel delete all pictures
Deleting images can be time consuming in large workbooks. Let us show you how to make Excel delete all pictures automatically using VBA.
How to remove hyperlink in Excel quickly using VBA
Hyperlinks can often become nuisance. In this article, we're going to show you how to remove hyperlink in Excel quickly using VBA.
How to make Excel update links using VBA
Excel doesn't automatically update any external links in your workbooks. Let's show you how to make Excel update links automatically.