归档： Sandra
-
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 […]
-
Microsoft Word 2016 Funny Tricks Tutorial
We have already learned some useful Word tips in previous tutorials. But skill is no burden. Today, the author will share with you more useful and funny tricks in Microsoft Word. Tip1: How to Change the Letter Case Quickly? If you want to change the case of letters quickly, you can just select the text […]
-
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 Fix Microsoft Store Page Could Not Be Loaded?
When you want to download some apps or software on your computer, you probably go to Microsoft Store. But sometimes the Store page could not be loaded in Windows 10. So this article would share with you guys several ways to solve this problem. Method 1: Try to create a new user account, and log […]
-
How to Put a Colorful Border Around Text in a Microsoft Word
Sometimes, we will add a border around the text, but the default text border color in Word is black. How to change its color? Ok ,this page will divided into two parts, you can open a Word document to have a try. How to crate a border to some text in Word document? Just click […]
-
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 […]
-
Office 2016 Tips And Tricks
If you are an office worker who often uses a computer, you should not miss this practical office tip. These tips can improves your ability to handle efficiently the daily affairs of life. Zoom-In And Zoom-Out Directly When you browse pictures or files on your computer, if there is something you can’t see clearly, we […]
-
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 […]
