归档: Sandra
-
How to Add Borders Automatically to Cells in Excel?
We usually add borders to cells by clicking on the borders button. Have you ever tried to add borders automatically on your worksheet while you are entering values in a cell? This trick can improve your work efficacy and funny. Let’s check this out. Select the area where we need it and go to the […]
-
How to Fix a Black Screen with Just a Cursor?
Why there’s only a cursor on your desktop screen when you start up your computer? So, in our today’s tutorial, we’ll learn how to solve this problem. Let’s check this out. Method 1 Press the Win key and R together to open the Run Window. Type “explorer.exe” in the open box. Hit OK. Method 2 […]
-
How to save a PowerPoint slide as a picture?
We learned how to extract images from PowerPoint in the last tutorial. But do you know how to save a PowerPoint slide as an image? Here we go. Go to the File and click on Save as. Save as JPEG File Interchange Format (*.jpg) Choose all slides or just the slide you want. We choose […]
-
How to Extract Images from PowerPoint
Are you still right-clicking and saving the pictures in PowerPoint one by one? if you want to extract only one or two images, you can save them in this way, but if there are lots of pics? In this article, we’ll talk about a way to extract images from PowerPoint in only several seconds!! Find […]
-
How to Create a Gradient Slide in PowerPoint
Most of us would not set the background color of the slide. Or just set a pure color. Actually, we can create a gradient effect to beautify our PowerPoint slides. Go to the Design tab and choose Format Background. Check the Gradient fill in the Fill list. We can set the numbers of gradient stops, […]
-
How to remove all hyperlinks in Excel?
In our today’s tutorial, we’ll learn how to remove multiple hyperlinks from an Excel worksheet at the same time. If we want to remove hyperlinks but keep the text. We can select all the links and right-click to choose Remove Hyperlink in the list. Or we can highlight the hyperlinks area and click on Remove […]
-
How To Use Advanced Filters In Microsoft Excel
When we talk about the filters in Excel, many people know that it can quickly find information or data that fits certain criteria in the clutter. In addition to the filter, there is a feature called an advanced filter. Someone may not have used it, but what does this advanced filter do? In our today’s […]
-
How To Create Dynamic Table in Excel
We’ve known how to create a dynamic graph in Excel. In our today’s tutorial, we are going to know how to create a dynamic table in Excel. Here is a fruit sale table from Monday to Friday. We first select the table area and press Ctrl + T to create the table dialog box. Go […]
-
How to Prevent Duplicate Entries in Excel?
Duplicates would be one of the reasons for wrong data entry. So, how should we prevent duplicate entries in Excel when entering data? Let’s take an example. Here is a school report. Now we need to prevent duplicate names in the Name column. Highlight the name column and go to the Data tab. Choose Custom […]
-
How to Compare Two tables in Excel
We have learned a tutorial on how to compare two Excel worksheets side by side. But if we want to compare two tables in Excel, I mean the two tables are in one Excel worksheet, is there a fast and simple method? There is. Let’s pick a simple example. Here are two monthly test reports […]