归档: Sandra
-
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 […]
-
Simple Excel Tutorial–How To Sum Multiple Excel Tables Across Sheet
Let’s say you are a class teacher, and the math teacher and chemistry teacher have each given you a report card. You need to sum up the class’s grades in math and chemistry. How to do this quickly? Highlight cell C2 and go to the Formulas tab. Click on the arrow of Math & Trig, […]
-
How To Batch Modify The Format Of Headings In Word
A lot of people still do not know how to bulk modify the title format, such as writing a paper, if you find your title format and requirements are wrong. Would you choose to adjust one by one or format brush? There’s actually a very quick way to do it. Even if you have thousands […]
-
How Do I Add 10 To All The Cells in Excel
Do you know how to add or subtract 10 from all the cells? I mean at the same time. If you haven’t mastered this technique yet, read on. Now we open an Excel sheet and enter some random numbers. Let’s take 10 as an example. Just type 10 in any cell. Select 10 and press […]
-
How To Change Mouse Sensitivity In Windows 10
Mouse sensitivity can directly affect the user’s experience, especially when playing some competitive games on the sensitivity of the requirements is higher, so how to adjust mouse sensitivity? Press the Win key or just click the Start option, then choose Settings. Or you can just press Win and I keys to quickly open the Windows […]
-
How to Use Data Validation for Entering Dates in Excel
When we want to enter data in Excel, in order to reduce data entry errors, we can use the data validation function to set the valid range of the data. Let’s take the below pic as an example. The picture shows the grades of the students. The score must be between 0 and 100. To […]
-
How to Use Excel Text Function in Microsoft Excel?
The TEXT function is one of the very frequently used functions, it can be used as a worksheet function in Excel. You can use the TEXT function to embed formatted numbers inside text. Syntax =TEXT (value, format text) Value: Value you want to format Format text: Format code you want to apply Now, Let’s learn […]