September 1, 2020

The articles and information featured on excelyogi.net depends on the version of Excel that you are using. A few steps can get added or eliminated based on Excel’s version. In this article, you will see couple of ways to determine which version of Excel are you using.

F...

August 30, 2020

When you have a file with hundreds of hyperlinks it makes sense to use macro to automate things. If you have a very few hyperlinks, you may well be interested in an easy way to do this. Follow below steps to remove hyperlinks from your excel file.

  1. Use the arrow keys...

August 30, 2020

We all know Excel's capabilities when it comes to filter the data. With few clicks we can filter out the data we want to see from thousands of lines. It's that easy! The filter we are talking here is 'horizontal' where we filter rows; how about doing it vertically? Can...

August 27, 2020

You must have noticed that when calculating, Excel's CPU usage peaks and the whole file goes for a toss. So, how do we enhance Excel's performance when performing 'heavy' calculations?

One way to change system resources that are devoted to a particular task, in this cas...

Please reload

Our Recent Posts

Find the version of your Excel

September 1, 2020

Remove hyperlinks from Excel file

August 30, 2020

Filtering data vertically in Excel?

August 30, 2020

1/1
Please reload

Tags

Please reload

©2020 by Excel Yogi