Excel resources

Excel Tips & Tricks

Articles, examples, and practical guidance from the SpreadsheetWeb team.

Page 24 of 60 · 540 articles

How to add watermark in Excel

In this guide, we’re going to show you how to add watermark in Excel as well as the way of removing it.

Learn how to get filename from path in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.

In this guide, we’re going to show you how to display File Open dialog in VBA along with filtering and multi-selection samples.

In this guide, we’re going to show you how to open workbook in VBA and example usage scenario.

In this guide, we’re going to show you how to insert specific number of columns in Excel dynamically with VBA.

In this guide, we’re going to show you how to insert specific number of rows in Excel dynamically with VBA.

In this guide, we’re going to show you how to use regular expressions in Excel with example VBA codes and scenarios.

In this guide, we’re going to show you how to use Advanced Filters in Excel, one of the most underrated features.

In this guide, we’re going to show you how to calculate discrete probability in Excel with the PROB function.