--- description: Read useful articles in Excel solutions category, including solutions, tips, how-to guides, introduction, overview and other resources. title: Excel Solutions Archives - Page 19 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 19) # Excel Solutions ### [3 Methods to Quickly Switch between Multiple Excel Workbooks](https://www.datanumen.com/blogs/3-methods-quickly-switch-multiple-excel-workbooks/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 You will certainly need to work with many workbooks. Here we will demonstrate 3 methods to switch between multiple Excel workbooks. If you need to deal with many Excel workbooks at the same time, you will certainly switch between those... [**Read more »**](https://www.datanumen.com/blogs/3-methods-quickly-switch-multiple-excel-workbooks/) ### [2 Practical Methods to Find Merged Cells in Your Excel](https://www.datanumen.com/blogs/2-practical-methods-find-merged-cells-excel/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 Sometimes you need to find merged cells in Excel. And here we have found 2 methods to find merged cells in Excel worksheet. Merged cells will interrupt you if you need to use references in formulas or other places. In the image below, you can... [**Read more »**](https://www.datanumen.com/blogs/2-practical-methods-find-merged-cells-excel/) ### [How to Use Different Average Functions in Excel](https://www.datanumen.com/blogs/use-different-average-functions-excel/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 In using Excel functions, you will certainly need to use the different average functions. In this article, we will explore the usages of all the average functions. There are 4 variants of average functions: AVERAGE, AVERAGEA, AVERAGEIF and... [**Read more »**](https://www.datanumen.com/blogs/use-different-average-functions-excel/) ### [How to Present Your Data in a Half Pie Chart in Excel](https://www.datanumen.com/blogs/present-data-half-pie-chart-excel/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 Sometimes you need to present data in a pie chart. And in this article, we will show you how to present your data in a half pie chart. Suppose now you need to present the sales volume in a half pie chart. There are 12 months with the... [**Read more »**](https://www.datanumen.com/blogs/present-data-half-pie-chart-excel/) ### [How to Quickly Insert a Blank Row/Column into Every Two Adjacent Rows/Columns in Your Excel](https://www.datanumen.com/blogs/quickly-insert-blank-rowcolumn-every-two-adjacent-rowscolumns-excel/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 In this article, we will introduce a method to quickly insert rows or columns into every two adjacent rows/columns quickly. In the image below, now you are going to input rows into to every two adjacent rows in this range. Instead of add rows... [**Read more »**](https://www.datanumen.com/blogs/quickly-insert-blank-rowcolumn-every-two-adjacent-rowscolumns-excel/) ### [2 Methods to Quickly Save Each Excel Worksheet as a Separate PDF File](https://www.datanumen.com/blogs/2-methods-quickly-save-excel-worksheet-separate-pdf-file/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 Sometimes you need to save Excel files as PDF files. And in this article, we will introduce two methods to save worksheets as separate PDF files. PDF is a widely spread file format among users due to its character. Therefore, sometimes you need... [**Read more »**](https://www.datanumen.com/blogs/2-methods-quickly-save-excel-worksheet-separate-pdf-file/) ### [How to Add and Disable Add-Ins for Your Excel Files](https://www.datanumen.com/blogs/add-disable-add-ins-excel-files/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 You can use add-ins in Excel to fulfill some complex task. And in this article, we will introduce how to add and disable add-ins in Excel. If you need to use add-ins in Excel, you need to add and activate it into Excel. On the other hand, if you... [**Read more »**](https://www.datanumen.com/blogs/add-disable-add-ins-excel-files/) ### [How to Make Your Cell Values More Intuitive via Icon Sets in Excel](https://www.datanumen.com/blogs/make-cell-values-intuitive-via-icon-sets-excel/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 In Excel, you can use the icon sets to mark cells with different values. And in this article, we will talk about how to use this feature in Excel. Icon sets is a very useful feature in Excel. It is also a small feature of the conditional... [**Read more »**](https://www.datanumen.com/blogs/make-cell-values-intuitive-via-icon-sets-excel/) ### [2 Methods to Create a Chart in an Excel Chart Sheet](https://www.datanumen.com/blogs/create-a-chart-in-excel-chart-sheet/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 If you want to create a chart in an Excel chart sheet, you can use the 2 methods in this article. You will certainly create a chart for a range in Excel. Sometimes instead of putting the chart in the same worksheet, you need to input the chart... [**Read more »**](https://www.datanumen.com/blogs/create-a-chart-in-excel-chart-sheet/) ### [How to Use the Different Count Functions in Excel](https://www.datanumen.com/blogs/use-different-count-functions-in-excel/) [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 Count functions are the most frequently used functions in Excel. In this article, we will discuss about the different 5 count functions in detail. There are 5 variants of count functions: COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS. Below we... [**Read more »**](https://www.datanumen.com/blogs/use-different-count-functions-in-excel/) Page 19 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/18/) [15](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/15/) [16](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/16/) [17](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/17/) [18](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/18/)19 [20](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/20/) [21](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/21/) [22](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/22/) [23](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/23/) [Next ›](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/page/20/) [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\/19\/","name":"Excel Solutions Archives - Page 19 of 23","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/19\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/19\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/11\/1-an-example-to-stwtch-multiple-workbooks.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\/19\/#breadcrumb"},"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/19\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/11\/1-an-example-to-stwtch-multiple-workbooks.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/11\/1-an-example-to-stwtch-multiple-workbooks.jpg","width":686,"height":183,"caption":"An Example to Stwitch Multiple Workbooks"},{"@type":"BreadcrumbList","@id":"https:\/\/www.datanumen.com\/blogs\/category\/solutions\/office-solutions\/excel-solutions\/page\/19\/#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"]}]} ```