Different Methods to select Visible Cells only in Excel

In Excel, when we Copy-Paste from a dataset containing hidden rows, the hidden rows also get copied. In this blog post, we will see 3 different methods to select only the visible cells in Excel. Keyboard Shortcut Alt + ; is the shortcut to select visible cells in Excel. Select the cells and press Alt…

Different methods to Reverse a List in Excel

This article is about 3 different methods to Reverse a List in Excel. Following is a list of candidates applied for a job. Let’s see the different methods to reverse this list for scheduling the interview. 1. Reverse the list using a Helper column Create a helper column with sequential numbers (for example 1,2,3,..) adjacent…