Categories：Excel Tips
-
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 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 […]
-
How To Capitalize First Letter In Microsoft Excel-Simple Tutorial
We have mentioned methods of how to quickly change the case of a Word in a previous Microsoft Word tutorial. But that doesn’t work in Excel. Let’s take the words in the green cells as an example, capitalize them in the blue cell. Now, we type PROPER() in cell E1 and press Enter key. Then […]
-
Microsoft Excel Quick Analysis Tool–Super Powerful Feature
There is a really useful and amazing tool in Microsoft Excel. That’s Quick Analysis. You can just press Ctrl and Q to open it or click on the right mouse button. This feature contains a number of shortcut options (Formatting, Charts, Totals, Tables, Sparklines) which can greatly improve the efficiency of our rules. No.1 Formatting […]
-
How To Use VBA To Insert Blank Row After Every Row In Excel?
In our previous tutorial, we have learned how to insert blank rows in every (alternate) row. But, today, we will get to learn a better and advanced way. if you are familiar with VBA, this method may be very easy for you, if not, that’s fine. just go ahead. Prepare a sheet and press Alt […]
