Posts Tagged 'Excel VBA'

3 Easy Ways to Batch Open Multiple Hyperlinks in Your Excel

If you'd like to batch open multiple hyperlinks in Excel, you can refer to this article. Here we'll introduce you 3 handy methods. Each of them has its pros and cons. You can choose any as per your needs. In some cases, when viewing an Excel file that consists of lots of hyperlinks, you may wish to batch open multiple hyperlinks. If there are only three or so links to be opened, you can just use the Method 1 below. Yet, if you want to batch open all links in your wanted ranges, you can use...

Read more »

2 Quick Ways to Get the Data Size of Each Worksheet in an Excel Workbook

If you want to quickly get the data size of each worksheet in an Excel workbook, you can refer to this article. Here we will share 2 handy methods with you. At times, when dealing with an Excel workbook which consists of a great amount of worksheets, you may want to get the data size of each worksheet. However, there is not a native feature for this requirement. So, you need to use some workarounds, such as the following Method 1. Or you can use the much smarter Method 2 to get all...

Read more »

2 Simple Methods to Select All Non-blank Cells in an Excel Worksheet

In an Excel worksheet, if data is entered in nonadjacent cells, you may discover it a bit troublesome to select and copy the data in non-blank cells. Now, in this post, we will introduce 2 ways to quickly select all non-blank cells. Excel users are frequently required to copy and paste data. However, sometimes, there may be some troubles. For example, there are multiple discontinuous blank cells in an Excel worksheet. In this case, it is a bit hard to select all the cells which have content....

Read more »