Take a Guess to Win Windows 10 Pro Key!
Categories: Excel Tips
-
How To Insert Bulk Image Links In Microsoft Excel
In this tutorial, we are going to learn how to insert bulk image links, so you can check and view these pictures quickly. Firstly, you need to create a new folder and save all your pictures and your Excel file in it. Remember to rename all these pics. Go to the Formulas tab and click […]
-
How To Hide Cell Contents In Excel
There are several ways to hide rows or columns. The simplest is to select the columns or rows and click Hide like below. It’s really simple and fast. But you can tell there are hidden traces. If there is important data, how do we hide it so that it is not so easy to find? […]
-
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 tests 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 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 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 […]
