归档: Sandra
-
How To Adjust The Width And Height Of All Tables In A Word Document?
In today’s tutorial, the author would like to share with you guys the fastest way to adjust the width and height of tables in a Word document. Let’s take an example. There are four tables of different sizes, and we need to adjust them to the same size quickly. Go to the Developer tab and […]
-
The Perfect Color Matching And Combinations In Excel.
When we use Excel to make bar or pie charts, matching colors really tests our aesthetic skills. If the color is not chosen properly, it will look very messy. So, the author would share with you more than ten sets of color combinations (Of course it’s totally for free). Remember to bookmark this site, so […]
-
How To Use Nested IF Functions In Excel-Simple Tutorial
IF function is perfectly used in our daily work. And the nested IF is just two more IF statements in a formula. When you have multiple conditions to meet, nested IF is powerful. Let’s take a simple example to show you how to use it well. Here’s a transcript of math and chemistry. If the […]
-
How To Rename Multiple Files At The Same Time
Sometimes we need to rename some files, such as after a trip. We import the pictures from the camera into the computer. Changing photo names one by one is a waste of time. So how do you quickly rename a group of travel photos? There is a way. Let’s make this a little bit more […]
-
How to Add Prefix or Suffix Batches in Microsoft Excel
If you need to add the same prefix and suffix to many cells, would you choose to add them one by one? This will definitely add to your workload. So today I want to share with you guys an easy skill for auto-adding prefixes/Suffix or changing prefixes/Suffix to existing text. Method 1: Highlight the cells […]
-
How To Use Ctrl + E In Microsoft Excel?
There are a lot of really useful shortcut keys in Excel. Ctrl + E is one of the most powerful keyboard shortcuts. This can help us flash fill, split, merge and extract data. Lets’ stop here and see the examples. Merging Data We first copy and paste the name “Marry” and number “001” into cell […]
-
How To Merge Multiple Excel Files Into Only One Sheet
It is common to combine multiple Excel Worksheets into one in our daily work. Many friends may choose to open each table in turn and then copy and paste them together. This only works with a small number of files, but too many files can be a huge waste of time. So today I’m going […]
-
How To Start Your PC In Safe Mode In Windows 10
If you use a computer a lot, then you are familiar with the word safe mode. Safe mode is a special mode in the Windows operating system. But there are a lot of people who don’t know what security mode is for. In safe mode, users can easily fix some system errors, such as the […]
-
Word to PDF – Convert DOC to PDF Online For Free
Converting word files to PDF is extremely important, especially if you have to share your documents between different devices having different operating systems. You should know that PDF format has its sanctity. You would surely understand its importance while sending memos, invoices, records, statements, and other confidential documents. You can indeed convert word to PDF […]
-
How To Convert Negative Number Into Positive Quickly In Excel
If you need to change all the negative numbers in the Excel sheet into positive, what should you do? In today’s tutorial, we are going to learn two ways to convert negative numbers into positive ones. Method 1 Insert Function Select a blank cell and go to Formulas, Choose Insert Function. Choose ABS in the […]