How to Paste in a Filtered Column Skipping the Hidden Cells
Copying and pasting are probably one of the most used actions in an Excel spreadsheet. But when it comes to filtered data, copy-pasting data is not always smooth. Ever tried …
Excel VBA / Macros
How to Make all Cells the Same Size in Excel (AutoFit Rows/Columns)
A neat looking worksheet is always better than a shabby and unorganized one. You can tell if a sheet has been handled repeatedly by different people by just one look …
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 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 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 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 …
How to Subtract Multiple Cells from One Cell in Excel
If you need to subtract a single value from a range of cells at the same time, there are multiple ways can do this in Excel. For example, suppose you …
How to Copy Multiple Sheets to a New Workbook in Excel
Using Excel for office work often requires copying sheets from one workbook to another. You might need to compile individual employee sales reports into a single workbook. Or, you might …
How to Delete a Sheet in Excel Using VBA
Deleting worksheets in Excel is a fairly easy task. All you need to do is just right-click on the sheet’s name at the bottom of the Excel window and hit …