Resources
How to create index of sheets in Excel with hyperlinks
In this guide, we're going to show you how to create index page of worksheets in Excel with hyperlinks. Using VBA, you can automatically update the hyperlinks after adding or removing sheets. [button...
How to make multiple selections in a dropdown list in Excel
Excel doesn’t have any built-in feature that allows you select multiple items in a dropdown. In this guide, we're going to show you how to make multiple selections in a dropdown list in Excel. [button...
How to get quarter from a date in Excel
In this guide, we're going to show you how to get quarter from a date in Excel. To get quarter from a...
How to flip data in Excel
In this guide, we're going to show you how to flip data in Excel. Using helper column And Sort...
How to split text with Power Query in Excel
Power Query is a data management tool in Excel. In this guide, we're going to show you how to split text with Power Query in Excel. [button link="https://spreadsheetweb.com/wp-content/uploads/2021/03/How-to-split-text-with-Power-Query-in-Excel.xlsx" type="big"...
How to disable protected view mode in Excel
Excel opens most files from other sources in Protected View mode by default. In this guide, we're going to show you how to disable protected view mode in Excel. Excel, like most other Office applications such as Word and PowerPoint, shows this message to ensure that...
How to split text with VBA in Excel
Text to Columns feature can help you split text strings in Excel. Using VBA, you can make this process even faster. In this guide, we're going to show you how to split text with VBA in Excel. [button...
How to split text with formulas in Excel
Excel has more than one way for splitting text, such as Text to Columns feature. However, the feature requires a manual user intervention. You can make the process dynamic with help of functions. In this guide, we're going to show you how to split text with formulas...
How to count a specific character in a string in Excel
In this guide, we're going to show you how to count a specific character in a string in Excel. Finding the number of a specific character, such as a delimiter, can help with splitting a text with the use of formulas. [button...