Solutions

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 »

In-depth Understanding of the Power of Macros in Access

Macros are powerful tools that you can use to automate repetitive actions. You can use them on almost all of the different Access tools: forms, controls, and reports. The macro is an incredibly powerful tool that gives you a way to automate tasks that you do all of the time. They make it so that your work is considerably more efficient and that there are fewer errors when doing tasks. This article introduces you to what macros are and how they work. The following articles will provide...

Read more »