Categories: Excel Tips
-
How to Freeze The First And Last Row in Excel?
When our Excel table is very long, we usually freeze the header row for browsing convenience. Freezing the header row is actually very simple, and people who often use Excel can do it. But what if you want to freeze the first and last rows at the same time? How to Freeze the Top Row? […]
-
How to Print a Long And Narrow Excel Table
Have you ever printed a long and narrow Excel sheet? It may takes a lot of paper to print such a form, but you will find it wasteful. Because most part of a piece of paper is blank. So today, the author will share you a useful method to print this kind of sheet. Step […]
-
How To Merge Multiple Excel Files Into One Workbook
When we counting some data, there may be multiple tables to count a variety of data, but the type of each table is the same. In order to facilitate access, it is necessary to merge multiple excels into one table, so that the data can be more clearly analyzed Statistics, but how to merge multiple […]
-
Create A Five-Star Rating System In Microsoft Excel
After often using some products or shopping online, we will judge the products or the shopping service, usually apply the five-star rating. We can give the number of stars according to our experience! In fact, you can also make a five-star rating effect in Excel. Let’s get started. Step 1: Frist, we need to prepare […]
-
How to Quickly Save Each Page as Separate Word Document?
The tips or tricks we have shared before are useful, today’s skill is powerful! So, you should not be miss this article, this is really can save you much time, and improve your office efficacy. I will use the Employee Information Form as an example. We will save each employee’s information page as a Word […]
-
How to Create a Special Histogram in Excel
It’s very easy to create a normal histogram in Excel. But the author wants to share with you a special histogram style. Let’s take a look at the renderings first. Step1 : Create A Colorful Chart Select the data and create a colorful histogram first. Step 2: Insert Triangle Shapes Go to insert and click […]
-
How to Separate Numbers and Text From a Cell In Excel
Today, we are going to learn how to separate numbers and text from a cell in Excel. Let’s divide this tutorial into three parts below. Ok, let’s get started. Situation 1: Numbers are in front of Text. This formula allows you quickly get numbers from cell B3. =-LOOKUP(0,-LEFT(B3,ROW($1:$15))) ROW($1:$15) indicates the maximum length of the […]
-
How To Check The Checkbox To Change The Cell Color
This is a very cool effect in Excel. When you checked each checkbox, the color of the related row would be changed at the same time. Ok, let’s get started. The content of this tutorial may be a lot, but it is not complicated. The author suggests you open an Excel sheet to have a […]
-
How to Record Macro and View Macro Code in Excel
I believe that many of the previous tutorials have taught you a lot. In today’s article. The author will teach you something new. That is how to record macro and view macro code in Excel. Excel provides an automatic code generation function, which is to record macros. The recording macro function can record the user’s […]
-
Loop Structure in Microsoft Excel Visual Basic
Loop structure in Visual Basic allows you to run the same code repeatedly. Sometimes we want a section of code to run more than once. Then, the loop structure run the code again and again until a condition is True or False. Maybe This concept is very abstract to you. So now the author will […]