--- description: Read useful articles in Excel solutions category, including solutions, tips, how-to guides, introduction, overview and other resources. title: Excel Solutions Archives - Page 11 of 23 --- - - - [Home](https://www.datanumen.com/blogs/) > [Solutions](https://www.datanumen.com/blogs/category/solutions/) > [Office Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/) > Excel Solutions (Page 11) # Excel Solutions ### [2 Simple Methods to Select All Non-blank Cells in an Excel Worksheet](https://www.datanumen.com/blogs/2-simple-methods-to-select-all-non-blank-cells-in-an-excel-worksheet/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 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... [**Read more »**](https://www.datanumen.com/blogs/2-simple-methods-to-select-all-non-blank-cells-in-an-excel-worksheet/) ### [2 Effective Methods to Batch Convert Multiple Excel Workbooks to PDF Files](https://www.datanumen.com/blogs/2-effective-methods-to-batch-convert-multiple-excel-workbooks-to-pdf-files/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 Sometimes, you may want to convert multiple Excel workbooks to PDF files. Here, in this article, we will introduce 2 methods to get it in batches. In some cases, you may need to convert an Excel workbook to a PDF file in that a PDF file cannot be... [**Read more »**](https://www.datanumen.com/blogs/2-effective-methods-to-batch-convert-multiple-excel-workbooks-to-pdf-files/) ### [2 Easy Methods to Prevent Duplicate Values in a Column in Your Excel](https://www.datanumen.com/blogs/2-easy-methods-to-prevent-duplicate-values-in-a-column-in-your-excel/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 If you want to avoid entering duplicate values in a column in Excel, you can refer to this article. Here we will share you 2 simple approaches. At times, when you edit an Excel worksheet, you may want to ensure the data in a column are unique,... [**Read more »**](https://www.datanumen.com/blogs/2-easy-methods-to-prevent-duplicate-values-in-a-column-in-your-excel/) ### [3 Methods to Create a List of Hyperlinks to All Worksheets in an Excel Workbook](https://www.datanumen.com/blogs/3-methods-to-create-a-list-of-hyperlinks-to-all-worksheets-in-an-excel-workbook/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 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... [**Read more »**](https://www.datanumen.com/blogs/3-methods-to-create-a-list-of-hyperlinks-to-all-worksheets-in-an-excel-workbook/) ### [3 Methods to Batch Export All Charts in an Excel Workbook to a Windows Folder](https://www.datanumen.com/blogs/3-methods-to-batch-export-all-charts-in-an-excel-workbook-to-a-windows-folder/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 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... [**Read more »**](https://www.datanumen.com/blogs/3-methods-to-batch-export-all-charts-in-an-excel-workbook-to-a-windows-folder/) ### [How to List Sheet Names in Excel: 12 Easy Methods \[2026 Guide\]](https://www.datanumen.com/blogs/3-quick-ways-to-get-a-list-of-all-worksheet-names-in-an-excel-workbook/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) January 16, 2026 List sheet names in Excel with 12 easy ways, from simple manual methods to advanced VBA automation. Step-by-step guide for all skill levels. 1. Introduction Managing complex Excel workbooks with numerous worksheets can become overwhelming,... [**Read more »**](https://www.datanumen.com/blogs/3-quick-ways-to-get-a-list-of-all-worksheet-names-in-an-excel-workbook/) ### [How to Run VBA Code in Your Excel](https://www.datanumen.com/blogs/how-to-run-vba-code-in-your-excel/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 VBA is an excellent tool in Microsoft Office suite, including MS Excel application. It can assist you to accomplish a lot of tasks not supported by the native features in Excel. Now, in this article, we will teach you to run VBA code in Excel step... [**Read more »**](https://www.datanumen.com/blogs/how-to-run-vba-code-in-your-excel/) ### [2 Easy Ways to Consolidate Rows in Your Excel](https://www.datanumen.com/blogs/2-easy-ways-to-consolidate-rows-in-your-excel/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 When analyzing the data in Excel, you may find it contains multiple duplicate rows. In this case, perhaps you'll want to quickly consolidate the rows. This post will offer 2 quick means to get it. Many users frequently need to merge the duplicate... [**Read more »**](https://www.datanumen.com/blogs/2-easy-ways-to-consolidate-rows-in-your-excel/) ### [3 Handy Methods to Batch Add Prefix to Multiple Cells in Excel Worksheet](https://www.datanumen.com/blogs/3-handy-methods-to-batch-add-prefix-to-multiple-cells-in-excel-worksheet/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 If you would like to batch add a specific prefix to multiple cells, you can refer to this article. Here we will introduce you 3 easy methods. Each has its own pros and cons. You can choose one as per your needs. At times, you may need to add a... [**Read more »**](https://www.datanumen.com/blogs/3-handy-methods-to-batch-add-prefix-to-multiple-cells-in-excel-worksheet/) ### [2 Fast Means to Split an Excel Worksheet’s Contents into Multiple Workbooks Based on a Specific Column](https://www.datanumen.com/blogs/2-fast-means-to-split-an-excel-worksheets-contents-into-multiple-workbooks-based-on-a-specific-column/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 At times, in data analysis, you may need to split the contents of an Excel worksheet into multiple Excel workbooks according to a specific column. Now, in this post, we will teach you 2 quick ways to get it. Many users frequently need to split an... [**Read more »**](https://www.datanumen.com/blogs/2-fast-means-to-split-an-excel-worksheets-contents-into-multiple-workbooks-based-on-a-specific-column/) Page 11 of 23 [« First](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) [‹ Previous](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/10/) [7](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/7/) [8](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/8/) [9](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/9/) [10](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/10/)11 [12](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/12/) [13](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/13/) [14](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/14/) [15](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/15/) [Next ›](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/12/) [Last »](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/23/) ![Data Recovery Blog]() Follow or like us on Facebook, LinkedIn and Twitter to get all promotions, latest news and updates on our products and company. - - - ### Featured Products - [DataNumen Outlook Repair](https://www.datanumen.com/outlook-repair/) - [DataNumen SQL Recovery](https://www.datanumen.com/sql-recovery/) - [DataNumen Exchange Recovery](https://www.datanumen.com/exchange-recovery/) - [DataNumen Access Repair](https://www.datanumen.com/access-repair/) - [DataNumen Excel Repair](https://www.datanumen.com/excel-repair/) - [DataNumen PDF Repair](https://www.datanumen.com/pdf-repair/) - [DataNumen Word Repair](https://www.datanumen.com/word-repair/) - [DataNumen Zip Repair](https://www.datanumen.com/zip-repair/) ### Popular posts ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"CollectionPage","@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/","url":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/11\/","name":"Excel Solutions Archives - Page 11 of 23","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/11\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/11\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/06\/go-to.jpg","description":"Read useful articles in Excel solutions category, including solutions, tips, how-to guides, introduction, overview and other resources.","breadcrumb":{"@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/11\/#breadcrumb"},"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/11\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/06\/go-to.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/06\/go-to.jpg","width":683,"height":374,"caption":"Trigger \"Go To\""},{"@type":"BreadcrumbList","@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/11\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Solutions","item":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/"},{"@type":"ListItem","position":2,"name":"Office Solutions","item":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/"},{"@type":"ListItem","position":3,"name":"Excel Solutions"}]},{"@type":"WebSite","@id":"https:\/\/www.datanumen.com\/blogs\/#website","url":"https:\/\/www.datanumen.com\/blogs\/","name":"Data Recovery Blog","description":"Discuss every aspect of data recovery","publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datanumen.com\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.datanumen.com\/blogs\/#organization","name":"Data Recovery Blog","url":"https:\/\/www.datanumen.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","width":296,"height":397,"caption":"Data Recovery Blog"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataNumen","https:\/\/x.com\/DataNumen","http:\/\/www.linkedin.com\/company\/datanumen","https:\/\/myspace.com\/datanumen\/","http:\/\/www.pinterest.com\/datanumen\/","https:\/\/www.youtube.com\/channel\/UCVIIuuKfUBHSJauUaVP13tw"]}]} ```