归档： Sandra
-
How Do I Filter Weekend Days In Excel?
I’m always looking forward to weekend days. After all, few people like to work. In our previous tutorial. We can get all dates to show in Excel. So how to show only weekend days in Excel? Here are all dates in 2022. You can click here to know how to quickly get this table. Now […]
-
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 Fix Error Code 0x80190001 In Windows 10?
Have you ever received this unexpected error code 0x80190001, perhaps it happened while you trying to install a Feature Update in Windows 10? What does error code mean? and how to solve it? let’s get started. Firstly, this error code 0x80190001 means that there are some problems with the installation files. It’s a very common […]
-
How To Fill The Same Content In Word Table?
There is a table in a Word document if you need to fill all the cells with the same content. Will you choose to copy and paste them one by one? It’s time to get a new trick now. For example, let’s fill these blanks with the word “Happy”. Method 1: Just press Ctrl and […]
-
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? […]
