归档： Sandra
-
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 […]
-
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 […]
-
How Do I Replace Pictures With Words In Microsoft Word?
It’s actually a very simple skill, and many people do not often do this in their daily work, but multi-skills are not pressured. Some tricks come in handy when you need them. Now we prepare a paragraph and the picture. I want to turn all the words “dogs” into a pic of a cute dog […]
