Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 49 of 60 · 540 articles
How to have Excel convert formula to value using VBA
In this article, we're going to show you how to have Excel convert formula to value using VBA, to protect your formulas.
How to compare two rows in Excel using VBA
Learn how to compare two rows in Excel using VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
How to find named ranges in Excel by highlighting them using VBA
Highlighting them on your worksheets can help you identify their properties easily. Let us show you how to find named ranges in Excel.
How to lock a cell in Excel formula using VBA
In this article, we're going to show you how to lock a cell in Excel formula using VBA and prevent your users from changing formulas or data.
How to un-protect a protected worksheet and vice versa - the VBA method
In this article, we're going to show you how to 'un-protect' protected worksheets and how to protect un-protected worksheets using VBA.
How to alphabetize Excel tabs using VBA
In this article, we're going to show you how to alphabetize Excel worksheets in ascending or descending alphabetical order using VBA.
Create Tables and Manipulate Data in an Instant with Excel Flash Fill
You can use the Flash fill to manipulate data quickly. Let us show you how Excel Flash Fill can save you time and drudgery.
How to unhide sheets in Excel with VBA
Learn how to unhide sheets in Excel with VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
How to hide formulas in Excel using the Protect Sheet feature
This article shows how to hide formulas in Excel using the Protect Sheet feature to prevent users from editing or seeing your formulas.