Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 48 of 60 · 540 articles
How to allow Excel uppercase characters only
Data validation can help streamline entry process. Let us show you how to allow Excel uppercase characters only, using Data Validation.
How to prevent Save As with VBA
Learn how to prevent Save As with VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
How to create an Excel histogram
A histogram is a visual representation of numerical data distribution, giving you the big picture. Let's see how an Excel histogram works.
How to find in Excel if cell is blank using VBA
In this article we're going to show to find in Excel if cell is blank using VBA and automate this process.
How to line up decimals in Excel using Number Formatting
Finance setting requires displaying numbers in a certain way. Let us show you how to line up decimals in Excel using Number Formatting.
How to make Excel capitalize first letter using VBA
To save time or for the sake of laziness, you find data in uppercase or lowercase. Let's show you how to make Excel capitalize first letter.
How to convert selection to Excel lowercase using VBA
Learn how to convert selection to Excel lowercase using VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
How to make Excel change case to uppercase using VBA
Changing lowercase characters into uppercase is a tedious task to do manually. Let's show you how to make Excel change case to uppercase.
How to remove characters in Excel using VBA
Although you can replace characters with Find & Replace, we will show you how to remove characters in Excel using VBA to automate it.