Hyperlinks removed

How to Remove Hyperlink in Excel?

Have you ever imported data to Excel from an external source with many unwanted hyperlinks that came along? Also, you might have come across multiple undesired hyperlinks automatically generated by Excel for emails and URLs … Read more

Combine first and last name to generate username

How to Combine First and Last Name in Excel

Excel has many useful functions and tools that enable us to perform text manipulation. That’s why, when you have first and last names in separate columns in a spreadsheet, it’s extremely easy to combine them … Read more

How to Insert Square Root Symbol in excel

How to Insert Square Root Symbol in Excel

Before anything, what is a square root symbol? Let me quickly take you back to high school mathematics. Here’s what the square root symbol looks like. We often need this symbol in your spreadsheets for … Read more

Right click and delete a single sheet

How to Delete Multiple Sheets/Tabs in Excel at ONCE

Opening sheets for different purposes within an Excel document is an excellent feature. However, sometimes you may accidentally open multiple unnecessary sheets, which can cause redundancy, especially if you don’t know how to delete multiple … Read more

Click on custom sort

How to Sort by Date in Excel

Sorting is an extremely useful function of Excel. Excel sort enables many options and variations so that you can sort your data with any specification. In this tutorial, we will learn how to sort by … Read more

Dollar sign in excel - Constant cell address

Why a Dollar Sign is Used in Excel?

Have you ever seen ‘$’ in an excel sheet and wondered why is it so frequently used? To simplify things, ‘$’ means don’t change. Sometimes, the $ in an excel sheet is just a dollar … Read more