Resources
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...
How to slugify a string with Excel
“Slugify” is a term for converting strings into URL slug format. A URL slug, or just slug in this article’s context, is the part of the URL that comes after the domain extension. In this guide, we're going to show you how to slugify a string with Excel. [button...
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://www.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 highlight alternate rows in Excel
With alternating background colors, it becomes easier to differentiate between each row. In this guide, we're going to show you how to highlight alternate rows in Excel. [button...
10 Excel tips to increase productivity in Excel
10 Excel tips to increase productivity In this guide, we’re going to show you 10 tips to increase your Excel productivity for when working with spreadsheets. Cell styles You can change the color, font type and borders around cells. Modifying these elements can help...