My Microsoft Office Tips Mon, 17 May 2021 06:29:53 +0000 en-US hourly 1 163763071 How to Move (Swap) Rows or Columns in Excel Mon, 17 May 2021 16:24:00 +0000 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 columns to other positions and then copy and paste them again.

Let’s get to a simple and fast way.

Highlight or select the B column first.

Press and hold the Shift key, then drag the B column.

Remember to put the mouse pointer to the edge of the selection until it changes from a regular cross to a 4-sided arrow cursor.

If you want to move rows’ position, do it in this same manner.

Ok, congratulations, you have improved your work efficiency. And there’s nothing wrong with saving yourself some time.

]]> 0 34410
How to Fix Microsoft Store Page Could Not Be Loaded? Fri, 14 May 2021 15:59:00 +0000 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 in to the computer with the newly created account to check whether the Microsoft Store is normal.

Method 2:

Press Windows and R keys to quickly open the Run window. Type “ wsreset ” and Press Enter to reset the store.

Method 3:

Press Windows + X key to get this list and choose Windows PowerShell (Admin),  then enter “ netsh Winsock reset” in the pup-up window and make it run.

Method 4:

You can also type this code in Administer: Windows PowerShell box.

DISM.exe /Online /Cleanup-image /Scanhealth

DISM.exe /Online /Cleanup-image /Restorehealth

That’s all the methods. Hope your Microsoft Store can return to normal.

]]> 0 34353
How to Put a Colorful Border Around Text in a Microsoft Word Wed, 12 May 2021 15:51:00 +0000 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 the left mouse button to select the text, and click [Character Border]in the toolbar.

How to change the color of character border?

Step1: Click the triangle next to [Borders] and choose [Borders and Shading]

Step2: Now you can change the style and color of the border. Remember to choose [Apply to text].

]]> 0 34343
How to Extract Hours/Minutes/Seconds from Time in Excel Mon, 10 May 2021 15:42:00 +0000 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?


Enter ‘=hour (B4)’ in cell C4 and press Enter key.


Enter ‘minute(B4)’ in cell D4 and press Enter key.


Enter ‘second(B4)’ in cell E4 and press Enter key.

So you can extract not only hour part, but also minute or second part of time in this manner. It’s really simple and effective, hope this can be helpful to you.

]]> 0 34337
Office 2016 Tips And Tricks Fri, 07 May 2021 16:18:00 +0000 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 can enlarge it.

You only need to press the Windows key and “+” to zoom in the screen, of course, press Windows and “-” to zoom out the screen.

Quick Lock Screen

Our computers store a lot of trade secrets or personal privacy. You could be snooped on every time you go to the bathroom.

So remember to press the Windows key and the L key when you leave your seat, so that you can quickly lock the computer screen.

Recover Deleted Data By Mistake

Sometimes we are so busy that we delete words by mistake. Don’t panic. Press the shortcut key Ctrl and Z to retract to the previous step and resume immediately.

Screen Record Function

Sometimes we need to record a computer operation video, are you using a mobile phone to record it? In fact, you only need to press the shortcut keys Windows and R, then enter “Psr.exe” in the pop-up text box, and then press Enter. The computer can start recording.

Quickly Close Web Pages

If you’re browsing a website that’s not related to work and your boss walks in. Would you slowly close down one page at a time in a panic? I think it might be too late.

In fact, you can quickly close the current page by pressing the shortcut key Ctrl and W.

]]> 0 34319
How To Enter The Same Data Or Text In Multiple Cells In Excel? Wed, 05 May 2021 16:05:00 +0000 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 Area and Press F5. Pressing F5 can quickly open the Go To box, then click on Special.

Select the Blanks in the window, and hit ok.

Now, you can find that all the blank cells in this area are grayed.

Just enter the data or text in one of the blank cell and press Ctrl and Enter keys.

In this way, you have completed the quick input of repeated data.

Congratulations, you’ve learned a new skill!

]]> 0 34266
How To Calculate Time In Excel-Simple Tutorial Mon, 03 May 2021 15:48:00 +0000 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 date and time?

Just type =A1+B2 in cell C2 and press enter key.

Split Date And Time

If you want to split the data that is combined with date and time, what should you do?

Just type =INT(A2) in cell D2 and press Enter key.

Type =C2-D2 in cell E2 and press Enter key.

Remember to change the format of E2 into time.

Calculate The Interval In Hours

How to calculate how many hours are between two times?

Subtract the start time from the end time, and then multiply it by 24.

Calculate The Interval In Minutes

How to calculate how many minutes are between two times?

Subtract the start time from the end time, and then multiply it by 1440.

This tutorial only explains a few simple but very commonly used methods for calculating dates. We will introduce other methods to you in later tutorials. See you next time.

]]> 0 34256
How Do You Switch Between Tasks/Applications Quickly? Fri, 30 Apr 2021 16:38:00 +0000 When we are working on a computer, many software or windows may be opened at the same time. If you want to switch between them. You need to lift your hand from the keyboard and click with the mouse. Actually, there is a fast way.

Method 1:


You just need to press and hold the Alt key, then press Tab key once. Each time you press the Tab key, a window will switch out on the screen.

Method 2:

Windows + Number Key

In fact, the applications on the taskbar are sorted, from left to right as 1.2.3…. So if we press the shortcut keys Windows and 1, the application at position 1 will be opened immediately.

For example, when we press Windows key and 3, Skype will be opened up immediately.

Ok, that’s all for today’s tutorial. Hope this can be helpful to you.

]]> 0 34252
How To Extract URLs From Hyperlinks In Excel Wed, 28 Apr 2021 16:21:00 +0000 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 inserted with hyperlinks, and now we need to extract the URLs of the hyperlink to the cells of column B. Go to the developer and click on Macros and create.

You can just copy and paste the code in following.

Function GetAdrs(Rng)

Application.Volatile True

        GetAdrs = IIf(.Address = “”, .SubAddress, .Address)
   End With

End Function

Now, we back to the sheet and enter =getadrs(A1) in cell B1 and press enter key, then drop down to fill.

Ok, you have made it. Call it a day!

]]> 0 34231
How Do You Rotate A Chart In Excel? Mon, 26 Apr 2021 16:36:00 +0000 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 this method implements chart rotation, the changed data cannot be retained. So today the author wants to introduce a method that many people don’t know—That’s Camera Command.

If you can’t find a camera logo at the upper left corner of Quickly Access Toolbar. You need to add this command first.

Click on the triangle and choose More Commands.

Find Camera in the list and add into Quick Access Toolbar, then hit OK.

Now, we highlight the area behind the chart, then click on Camera, and Press Enter key. You will find a picture appears, which is the area we just selected.

This picture can be rotated and resized.

And we can crop the picture to remove the parts you do not need.

The most important point is that when we change the data in the cells, the chart in the picture would also change along.

Well, that’s all for today. Hope this tutorial can help you.

]]> 0 34207