Categories：Excel Tips
-
How to Enter An ‘±’ Sign in Microsoft Excel
Today I saw someone on Quora asking how to enter the sign’±’ in Excel. He said that he copied and pasted it from the Internet every time. so, maybe this is very easy for you, but I guess some people still don’t know. Today, the author would share with you guys two common methods. Method […]
-
How to Declare Variables and Assign Them Value in VBA
Actually, declaring the variables and assigning them value is the starting and basic part of running a code. A good declaration way and a correct assignment process are fundamental to writing accurate and efficient code. This article will share with you what’s the declared variables and some basic syntax. In the previous article, we have […]
-
How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial
It’s definitely easy for you guys to autofill number serial in cells. The fastest way is to type 1 in cell A1 and 2 in cell A2 then fill it. But how to autofill number serial in merged cells like below. If you do the same way, it will remind you that [ To do […]
-
How To Use EXACT Function In Excel—Simple Tutorial
The EXACT is not a very common function, but it’s actually quite useful. If you want to fully master this function, the first step is to understand what it does and how to use it. The EXACT function will compares two text strings. If the two stings are the same, EXACT will returns TRUE. If […]
-
How to Move (Swap) Rows or Columns in Excel
When we find that the two columns of data in the Excel table are in the wrong position, what method should be used to swap the positions of the two columns of data? Take the B and C columns in the following figure as examples. Before I know the method, I even cut the two […]
-
How to Extract Hours/Minutes/Seconds from Time in Excel
When we are making an Excel table, we need to keep all the time in the table only in hours instead of minutes and seconds. So what should we do in this situations? Hour Enter ‘=hour (B4)’ in cell C4 and press Enter key. Minute Enter ‘minute(B4)’ in cell D4 and press Enter key. Second […]
-
How To Enter The Same Data Or Text In Multiple Cells In Excel?
Sometimes we need to enter a lot of repeated data or text in the Excel table. It would be a waste of time if we fill in one form one by one. So how should we improve efficiency? In other words, how should we enter a large amount of repeated data at once? Highlight the […]
-
How To Calculate Time In Excel-Simple Tutorial
I often see netizens on Quora asking how to calculate time in Excel. So I sorted out several related calculation methods and shared them with you guys. Merge Date And Time As shown in the figure below, how to merge the date in column A and the time in column B into data with both […]
-
How To Extract URLs From Hyperlinks In Excel
If you need to save the URLs from hyperlinks. Will you click these hyperlinks one by one and save these URLs each time. Today, Sandra will introduce a very easy and fast way to quickly make it, that’s VBA. As shown in the picture above, the data in the cells of column A have been […]
-
How Do You Rotate A Chart In Excel?
If you click on the chart in excel, you will find that only the size of the chart can be adjusted, not rotation. So how do you rotate the chart? I guess someone would choose the screenshot function to take a screenshot of the chart into a picture and then you can rotate it. Although […]
