Office Solutions

How to Present Your Data in a Half Pie Chart in Excel

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 corresponding sales volume. And here you need to create two separate half pie charts for every half year. Below we will show you the steps to create the two half pie charts. Arrange the Data Before you create a half pie chart, you need to arrange the...

Read more »

How to Quickly Insert a Blank Row/Column into Every Two Adjacent Rows/Columns in Your Excel

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 one by one, you may also follow the methods below. Insert Rows Input the number “1” into cell D2 in this range. Secondly, input number “2” into cell D3. After that, select the two cells. And then double click the fill handle...

Read more »

2 Methods to Quickly Save Each Excel Worksheet as a Separate PDF File

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 to save your Excel files as PFD files. And the method of saving as PDF files is very easy. Save Excel Worksheets as PDF Files. To save Excel worksheets as PDF files is very easy. Here are the steps of saving a worksheet as a PDF file. Come to...

Read more »