

Category Archives for "Excel Tips"

5 [Quick Tip] How to Select 500 cells/rows in Excel (with a single click)

Watch Video – Select 500 cells/rows in Excel (with a single click) A few days ago I was working with a dataset where I had multiple sheets full of data. I had to select the first 500 cells at one go from each worksheet and copy it. I then had to paste this data into a tool I […]

5 Get a List of File Names from Folders & Sub-folders (using Power Query)

Combine Data from Multiple Workbooks - files from folder

Watch Video – Get a List of File Names from Folders & Sub-folders Some time ago I wrote an Excel Tutorial about getting a list of file names from a folder in Excel. In that tutorial, I showed various ways to get the list of file names from a folder (using the FILE function and VBA). However, the […]

4 3 Quick Ways to Select Visible Cells in Excel

Select Visible Cells in Excel - using keyboard shortcut ALT semicolin

Watch Video – 3 Ways to Select Visible Cells in Excel What do you do when you have to copy a range of cells in Excel and paste it somewhere else? In most cases, the below three steps get the work done: Select the cells that you want to copy. Copy the cells (Control + […]

0 How to Quickly Remove Hyperlinks from a Worksheet in Excel

Remove All Hyperlinks - Paste VBA code in module

Watch Video – How to Remove Hyperlinks in Excel I often find it quite frustrating when Excel automatically creates a hyperlink as soon as I insert an email id or a URL in a cell and hit enter. Now, when I try to select a cell (or double-click on it to get into the edit […]

1 How to Round to the Nearest Integer or Multiple of 0.5 / 5 / 10 in Excel

Watch Video – Round to the Nearest Integer or the Multiple of 0.5 / 5 / 10 in Excel Rounding a number to the nearest integer or the nearest 0.5 or 5 or 10 multiple is a common task for many people. For example, if you’re a project manager involved in effort estimate, you can’t […]

2 7 Quick & Easy Ways to Number Rows in Excel

Excel Table - Automatically Add row Number on adding a row

Watch Video – 7 Quick and Easy Ways to Number Rows in Excel When working with Excel, there are some small tasks that need to be done quite often. Knowing the ‘right way’ can save you a great deal of time. One such simple (yet often needed) task is to number the rows of a […]

85 Get the List of File Names from a Folder in Excel (with and without VBA)

On my first day in my job in a small consulting firm, I was staffed on a short project for three days. The work was simple. There were many folders on the network drive and each folder had hundreds of files in it. I had to follow these three steps: Select the file and copy its […]

« Previous 1 2 3 4 … 33 Next »