归档： Sandra
-
How Do I Create Multiple Excel Workbooks Quickly
We have learned how to create multiple sheets in Excel, and how to batch create folders. Now, it turns to multiple Excel workbooks. If you are familiar with VBA, it’s a no-brainer for you. If you don’t, that’s okay. You can just save this post and take it out when you need it anytime. Let’s […]
-
How Do I Make A Scissor Line In Word?
We’ll see that some of the paper or some of the official documents will have a dotted line with a little schematic of the scissors in the middle, saying let’s cut this out. So how do we make this dotted line with little scissors in a Word document? it’s really easy, and let’s get the […]
-
How To Use Clipboard To Copy And Paste Multiple Items In Excel
If your superior asks you to copy from one worksheet to a specific location on another worksheet. What would you do? Will you choose to copy and paste one by one? Come on, that’s just a waste of time. There is a choice called Clipboard, I’ll show you how to use it. If we need […]
-
VBA Program Structure Tutorial
Today, the author would share something new about the VBA program structure In this article. It’s also a very important part of VBA. The concepts of variables, data types, and operators learned in the previous articles are the “static” part of VBA. In contrast, the program structure is the “dynamic” part of VBA. After learning […]
-
Four Ways to Insert Hyperlinks Quickly in Excel
Inserting hyperlinks into cells to link to other cells, worksheets, web pages, etc., is a common operation. There are actually four ways to insert hyperlinks in Excel, so let’s take a look. No.1 Suppose we need to insert a hyperlink in the green cell. Just right-click and choose the Link option in the list. Now, […]
-
10 Tips To Improve Your PowerPoint More Brilliant
Whether you are a student or an office worker, there are times when you need to make a speech. PowerPoint is also an important way for us to give speeches and share our ideas. So, in today’s tutorial, the author would like to share with you guys ten tips to help you. How to make […]
-
How To Calculate The Total Score Like The Olympics?
The Tokyo 2020 Olympics just ended. As an audience, I saw many wonderful performances. My favorite Olympic events to watch are diving and gymnastics. How about you? We all know that the athlete’s score is calculated on average after removing the highest and lowest scores from the judges. So, today we are going to learn […]
-
How Do You Unmerge Cells Correctly?
Are you serious? Just unmerge cells? Yeah, just unmerge cells. Isn’t it something that can be done with one click of the mouse? But what if, after canceling the merge, you still need to fill in all the extra cells with the same content? Let’s take a look. After we cancel merge cells, there would […]
-
How To Create Multiple Folders At Once— Simple And Effective Way
In our previous tutorials, we have learned how to create multiple worksheets in excel. And in today’s tutorial, we are going to learn how to create multiple folders at once. Let’s also take months as an example. If we need to create folders and name them by month, from January to December. We first type […]
-
How To Print Only The Selected Area In Microsoft Excel
It’s easy to print a table, but we usually print all of it. What if we only need to print one part of it? It can be as simple as breathing. Let’s take the following sheet as an example. Method 1： Just select the area you need to print and press Ctrl and P to […]
