Office Solutions

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 »

How to Quickly Export Outlook Tasks in Different Statuses to Different Worksheets in an Excel Workbook

Sometimes, you may need to separate and export your Outlook tasks in different statuses to different worksheets in an Excel workbook. This article will introduce an effective and easy method to you. Perhaps you have multiple tasks in Outlook. And they are in different statuses, including "Not Started", "In Progress", "Complete", "Deferred" and "Waiting for someone else". Under this circumstance, if you would like to export your tasks to an Excel workbook's different sheets on basis of the...

Read more »

3 Quick Ways to Get a List of All Worksheet Names in an Excel Workbook

If you have an Excel workbook that has hundreds of worksheets, and now you want to get a list of all the worksheet names, you can refer to this article. Here we will share 3 simple methods with you. Sometimes, you may be required to generate a list of all worksheet names in an Excel workbook. If there are only few sheets, you can just use the Method 1 to list the sheet names manually. However, in the case that the Excel workbook contains a great number of worksheets, you had better use the...

Read more »