Office File Recovery

2 Ways to Batch Move All Charts from All Existing Worksheets to a New Created One in Excel Workbook

If each worksheet in an Excel workbook contains several charts and now you would like to batch move all charts to a new created worksheet, you can refer to this post. Here we will introduce you 2 easy ways. After creating charts for the data in each worksheet of an Excel workbook, so as to better analyze data according to these charts, you may want to gather all these charts to a same worksheet. In other words, you may hope to move all of them to a new worksheet. If there are few charts, you...

Read more »

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 »