Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 31 of 60 · 540 articles
How to create a dynamically changing calendar in Excel
Do you want a dynamic calendar in your worksheet? In this article, we are going to show you how to create a calendar in Excel.
How to change case in Excel
Learn how to change case in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to use emojis in Excel
Doesn’t emojis in Excel work sound well? In this article, we are going to show you how to use emojis in Excel.
How to use symbols on charts in Excel
Do you ever want to use symbols on your chart? In this article, we are going to show you how to use symbols on charts in Excel.
How to find nth closest match in Excel
Learn how to find nth closest match in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to create a Waterfall Chart in Excel
In this guide, we’re going to show you how to create a waterfall chart in Excel to visualize +ve or -ve values in a data series affect sequentially.
How to cut and paste transpose in Excel
Excel doesn’t support transpose paste after cutting. In this article, we are going to show you how to cut and paste transpose in Excel.
How to find the first blank cell in a range in Excel
In this article, we are going to show you how to find the first blank cell in a range in Excel. You can create a hyperlink to that cell too.
How to find the first non-blank cell in a range in Excel
In this article, we are going to show you how to find the first non-blank cell in a range in Excel with MATCH and ISBLANK functions.