归档: Sandra
-
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 […]
-
How To Insert Tick And Cross Marks Quickly In Microsoft Excel
How do you usually insert tick or cross symbols in Excel? I’m sure you have your own way. The so-called multi-skills are not pressure. In our today’s tutorial, the author would introduce two methods about how to insert tick or cross marks in Excel. They are both interesting, and you probably haven’t used them yet. […]
-
How to Change the Color of the Gridline in Worksheet
Tired of looking at the same gridline colors, let’s pick a new color for your gridline in worksheet. Go to File tab and select Options. In the advanced category, and choose the color you want in the gridline color checkbox. Blue gridline.
-
How To Quickly Get The Windows Symbol
We all know there is a window key on our keyboard. This key is also used very frequently. The author sometimes may use the symbol to represent the win key. The symbol looks more interesting and intuitive. If you also encounter this situation, then hope this tutorial can be helpful to you. Step 1 : […]
-
How To Use The Subtotal Function In Microsoft Excel
Have you used the Subtotal function in Excel ever before? This can help you sort and sum data quickly. If you always handle tables or Excel worksheets. This is a really great command. Let’s take a simple example. Go to the Data and click on Subtotal. At each change in Sales Departments and add subtotal […]
-
How To Use REPT Function In Excel –Funny And Simple Tutorial
We have learned how to use the EXACT function in the last tutorial. Today, we are going to get something new—that’s the REPT function. The REPT function repeats characters or text a given number of times. Syntax: =REPT(text, number_times) Look at the example below. We type =REPT(“*”, A3) in cell B3 and press Enter key. […]
-
How to Change The First Letter to Lowercase in Microsoft Excel
In the last tutorial, we use the PROPER formula to capitalize the first letter in Excel. But how to change uppercase to lowercase?—that’s the Lower formula. Let’s take the same table as an example, and change the case into the yellow cells. Now, we type LOWER() in cell I1 and press Enter key. Then hit […]