Excel Tips and Tricks
How to save Excel charts as image
Excel is one of the most common platforms for creating charts. In this guide, we’re going to show you how to save Excel charts as an image. [button link="https://www.spreadsheetweb.com/wp-content/uploads/2021/06/How-to-save-Excel-charts-as-image.xlsx " type="big"...
How to add watermark in Excel
How to add watermark in Excel Image or video watermarks are commonly used for copyright protection or marketing. Although Excel has watermark support, it's not very easily accessible. In this guide, we’re going to show you how to add watermark in Excel and also how to...
How to get filename from path in Excel
In this guide, we’re going to show you how to get filename from path in Excel. We will cover how to do this with and without VBA. [button link="https://www.spreadsheetweb.com/wp-content/uploads/2021/06/How-to-get-filename-from-path-in-Excel.zip" type="big"...
How to display File Open dialog in VBA
Excel VBA allows you to open a workbook directly - all you need is the full path of the file, including the file name. However, locating and supplying the file path each time may can be tedious when working with multiple files. In this guide, we’re going to show you...
How to open workbook in VBA
How to insert specific number of columns in Excel
Inserting new columns is the easiest way to add new fields into your worksheet area. Since Excel inserts columns by copying the formatting of the previous column, it is usually more practical than moving bottom cells to open up space for new data. Thanks to VBA, we...
How to insert specific number of rows in Excel
Inserting new rows is the easiest way to add new fields into your worksheet area. Since Excel inserts rows by copying the formatting of the previous row, it is usually more practical than moving bottom cells to open up space for new data. Thanks to VBA, we can insert...
How to use regular expressions in Excel
You can use text functions to manipulate text strings in Excel. However, you can't use them with regular expressions. As of writing this article VBA is your only option. In this guide, we’re going to show you how to use regular expressions in Excel. [button...
How to use Advanced Filters in Excel
The arrow buttons, FILTER function, and Power Query are popular methods for filtering data in Excel. Unless you are using Power Query, these methods may not be enough when working with two or more criteria. The more powerful Advanced Filter feature can help for more...