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 …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Remove Commas in Excel
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
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
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?
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?
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?
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?
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., …
How to Select Alternate Columns in Excel (or every Nth Column)
When dealing with databases in Excel, you might come across spreadsheets that have data organized in particular patterns. For example, census data usually consists of alternating columns of actual data …