Categories：Excel Tips
-
How Do I Get Excel To Show All Dates?
2022 is coming. I need to create a new workbook that contains all dates of 2022. So how to get all dates in Excel? Enter 1/1/2022 in cell A1 and use handle fill? That’s too much trouble. There is a better way. Type A365 in Name Box and press Enter key. Cell A356 will be […]
-
How To Open Excel Sheet As Read-Only Mode
Sometimes, we need to protect the information in Excel sheet. So open the Excel file as “Read-only” can protect the table from being modified by others. So in this tutorial, we will get a little and useful skill. Go to the File tab and choose Info. Click on the arrow of Protect Workbook and choose […]
-
How To Use The LARGE Function In Excel?
We have learned a lot of usages of different functions in our previous tutorials. Today, we are going to learn the LARGE function. So, what does the LARGE function mean? and how to use it? What’s the Large function? The LARGE function can help you to get the kth largest value of a set of […]
-
How To Get Total Number Without Repetition?
I’ve got a list right now, and I need to know how many people are on it. I took a look and I knew there were 19 people, but I realized that there were a lot of names that were repeated. So how do I quickly figure out the total number of people without repetition? […]
-
Excel Easy Tutorial: How To Use The MEDIAN Function
Do you know the MEDIAN function in Excel? It’s different from the AVERAGE function. The AVERAGE function will take the average of a set of numbers. For example, the average of 2,4,4,6,7, and 10 is 5.5, but the median of 2,4,4,6,7, and 10 is 5. So the MEDIAN function will calculate the middle value of […]
-
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 test whether the provided value is a text type, and if so, returns the text; otherwise, you will get […]
