3 Methods to Create a List of Hyperlinks to All Worksheets in an Excel Workbook

When an Excel workbook has many worksheets, in order to access them quickly, you may want to create a list of hyperlinks to all worksheets. In this article, we will share 3 methods with you. If you have an Excel workbook which contains a great amount of worksheets, you may find it troublesome to locate and access your desired worksheet. In this case, you can create a list of hyperlinks to all worksheets, which can let you jump to a specific worksheet simply by clicking on a hyperlink. It's...

Read more »

How to Auto Block Outlook Emails from Those Not In a Whitelist

If you've stored hundreds of safe senders in a text file, namely a whitelist, you may wish Outlook to auto block the emails from the senders who aren't included in this whitelist. Now, in this article, we will introduce you a smart way to get it. In the previous article – "How to Auto Block Unwanted Outlook Emails with the Blacklist in a Text File", you can learn a method to block the emails from those in a blacklist. Similar to that, you may also want to auto block the emails from those...

Read more »

3 Methods to Batch Export All Charts in an Excel Workbook to a Windows Folder

You have an Excel workbook which contains a lot of charts spread in all of its Excel worksheets. Now, if you want to batch export all the charts to a Windows folder, you can use any of the 3 methods introduced in this article. After creating multiple charts for the data in an Excel workbook, you may want to export these charts to a local folder as JPEG image files, too. In this case, of course, you can use the following Method 1 to manually save the charts one by one. Yet, it will be tedious...

Read more »