归档： Sandra
-
How To Batch Create Sheets In Excel?
Do you know how to create multiple sheets? There is a very easy way to quickly get it. Not only do you get a lot of workbooks quickly, but they are also well named. Ok, let’s get the ball rolling. Suppose we need to make a sales table for 2021, from January to December. Then […]
-
How To Merge The Contents Of Multiple Cells
Do you know how to combine these words into one sentence? In other words, how to combine the contents of multiple cells into one cell. That’s very easy. Select these cells firstly and go to Fill tab. Choose Justify in the list. Oh, you’re done.
-
How To Use The T Function In Excel?
It’s time for you guys to learn Excel Function. Today, we are going to learn a simple and new one, that’s T function. Syntax =T(value) Purpose: Filter text value only So, the T function aims to test whether the provided value is a text type, and if so, returns the text; otherwise, you will get […]
-
How to use the BAHTTEXT Function in Excel?
Do you know what’s the BAHTTEXT function? I don’t think many people use this function, and I haven’t used it in my daily office so far. But today, we are going to learn this. It’s very easy to understand and use. The BAHTTEXT function converts a number to Thai as a text value and appends […]
-
How To Create The Multiplication Table In Excel
Why Chinese people are good at math. That’s because they memorized the multiplication tables in primary school. Knowing the multiplication table will help you do math more efficiently. So if you have kids, make sure they learn multiplication tables at an early age. It will definitely make them smarter. Today, we are going to learn […]
-
How To Change Multiple File Extensions
We can observe the suffix of a file to determine what file it is. For example, a suffix of [.zip] is a compressed package, and a suffix of [.txt]is a notepad. So sometimes we can change the file type by changing the suffix. Usually, we will click the right mouse button and choose to rename […]
-
How To Insert Tick And Cross Mark Quickly In Excel
There are at least 6 ways to insert tick and cross symbols in Excel or Word. I guess you know at least one or two of these methods. But the method I want to talk about is the very unusual one. Let’s take the table below as an example. Select the area from cell B2 […]
-
How To Quickly Get Folder Names
If we need to get a lot of folder names quickly, how to do that? Let take the months as an example. There are 12 folders named after months in the Test folder. Now we create a new text document and name it. Open and type [Dir> 1.text] in this document, remember to save it. […]
-
How To Convert The Content On One Line Into Multiple Lines In Excel
When we are processing data, sometimes we need to change one line of content into multiple lines of content. Most people will use the copy and paste method to complete, but if you encounter a lot of content, it will be very troublesome and waste time. So is there a way to achieve this effect […]
-
How To Quickly Switch Worksheets In Excel
If there are multiple worksheets in an Excel workbook, we will need to switch these worksheets when using them. So how to switch worksheets quickly? In fact, there are several different types of switching worksheets in Excel. Let’s take a look. No.1 Just Click Most people use the mouse to click directly when switching between […]
