Category: MS Excel

In Excel or Word, you can add a happy face by inserting a "happy face" shape, however, there is no sad or neutral face shape to insert to your …

You may get frustrated when you draw a horizontal line in Excel or Word and it is not straight. Actually, Microsoft has a trick for you to draw a …

"Ctrl+T" is the shortcut to display the "Create Table" dialog box, which is the quick way to turn your data range into a table. The shortcut Ctrl+L has the …

– How to Change Time Format– How to Change Time to Include Seconds When you type the time with the shortcut "Ctrl+Shift+;" in Excel, you will get the current …

When saving an Excel worksheet as a PDF file, the borders of the tables in the file become very thick. Most time you can leave them as they are, …

If you have an Excel file and you do not want other people to modify when you share with other people, you can save the Excel file as a …

Using conditional formatting, you can quickly highlight the cells with bottom 10 items or bottom 10% items. Please see below for details. However, if you need to highlight bottom …

#DIV/0!│#N/A Error│#NAME?│#NULL!│#NUM!│#REF!│#VALUE!│####### When working with Excel, one or more errors may appear in your data or analysis. Each error has its own reason. 1. What is #DIV/0! Error? "#DIV/0!" …

Merged cells are sometimes great in displaying some contents, however, it can be a trouble when you copy or sort the data that contains merged cells. You need to …

In the situation that you need to merge the currency with text to make a sentence in one cell, you are better not to directly put the currency and …