How to Recover an Unsaved Excel File (5 Free Solutions) Losing an unsaved Excel file is a real pain🤕 Whether you lose an entire Excel spreadsheet or just the latest round of edits, it can take a lot of time to fix the problem. But don’t worry! In this guide, I’ve compiled the [...]
How to Randomize a List in Excel: Step-By-Step Guide Got a list you need to sort in a random order? While there's no one-click solution to randomize data in Excel, you can do it in 3 simple steps. Let me show you howđź’ˇ If you want to tag along, please download my sample [...]
How to Strikethrough Text in Excel (With Easy Shortcut) Need something to cross out an item on a list? Then you need the strikethrough format. Adding strikethrough in Excel is super easy - once you know how to do it. Let’s take a closer look at how to cross out text with the [...]
The drop-down list is a great way to look like a superuser and impress your co-workers and boss. At the same time, it’s a very user-friendly asset in almost all custom-made Excel sheets. In this tutorial, we're going to show you the 5 steps to create a drop-down in 1 minute or less. We call it the “1 Minute Drop-Down”.
How to Clear Excel Formatting Knowing how to clear Excel formatting is a time-saver. As you work with large worksheets, there are times when you need to remove the current formatting to highlight the data, change them into another, or to correct display issues. Usually, when the formatting isn’t too many, we simply [...]
How to Use Comments in Excel's VBA Editor Like any scripts, Excel’s VBA modules can be very long and complicated to read. Basic VBA scripts are easy to work your way through. But once you start adding more variables and functions, it gets very difficult to figure out what’s going on. So, how do you [...]
How to integrate Excel Online with Zapier (Gmail Example) Written by co-founder Kasper Langmann, Microsoft Office Specialist. A few weeks ago, we were contacted by Jose Proenca, who wrote us the following: I figured you'd be interested in a new release we're super excited about. Zapier is one of the first to make [...]
These Are The 69 World's Best Excel Blogs That Will Teach You Everything About Spreadsheets Written by co-founder Kasper Langmann, Microsoft Office Specialist. If you are looking for practical, in-depth educational blogs about Excel, you've come to the right place. Here are the top 69 best blogs to learn everything about Excel. As [...]