How to Delete Filtered Rows in Excel (with and without VBA)
Excel provides a wide range of functionality, a lot of which most users are not even aware of. One of its most fascinating features is the versatility of its Filters. …
How to Group and Ungroup Worksheets in Excel
A few readers had shared their concerns about situations where some of their sheets seem to be stuck together. So, any changes they make to one sheet are also affecting …
How to Remove Commas in Excel (from Numbers or Text String)
Commas serve multiple purposes when working with spreadsheets. They make numbers more readable. For example, the number 1,452,346 is much clearer than the number 1452346. Commas also help delimit related …
How to Set the Default Font in Excel (Windows and Mac)
Most spreadsheet software comes with a default font pre-selected. For example, Microsoft Excel worksheets always start with the Calibri font set at size 11. For Excel on a Mac, the …
How to Remove Dollar Sign in Excel (4 Easy Ways)
When working with financial data, you will notice that currency values are automatically formatted by Excel to include a dollar sign. This might not be the currency symbol you want …
How to Remove Hyperlinks in Excel (Easy Step-by-Step)
Working with a spreadsheet full of hyperlinks can be quite frustrating. Unless otherwise specified, Excel usually recognizes the formats of email addresses and URLs and automatically converts them to hyperlinks. …
How to Remove Leading Zeros in Excel (3 Easy Ways)
If you’re dealing with a spreadsheet that was not created by you, formatting hassles are quite likely. You might come across a list of phone numbers with leading zeros. It …
How to Find Merged Cells in Excel (2 Simple Ways)
You might have encountered times where you find Excel not letting you perform certain operations on your data due to the presence of merged cells. Merged cells are often so …
How to Insert Square Root Symbol in Excel (5 Easy Ways)
Every software in the Microsoft Office package comes with its own purpose and application. Just like MS Word was built for word processing, MS Excel has been created to work …
How to Calculate Standard Error in Excel (Step-by-Step)
Most people use spreadsheets software such as Microsoft Excel to process their data and carry out their analysis tasks. When performing an analysis of data, a number of statistical metrics …
How to Highlight Every Other Row in Excel (Conditional Formatting & VBA)
Working with rows after rows of data can sometimes get monotonous. Often times, it becomes difficult to differentiate one row from the other. The solution? Highlighting (or shading) alternate rows …
How to Filter as You Type in Excel (With and Without VBA)
Excel has some powerful Filter options (with inbuilt filter, advanced filter, and now the FILTER function in Office 365). But none of these options actually filter as you type (i.e., …