How to Draw a Straight Line in Excel or Word
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 …
Category: Excel Basic
How to Change Time to Include Seconds and AM/PM
– 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 …
Why Borders are Thick When Saving Excel Tables to PDF
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, …
How to Save Excel to PDF
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 …
8 Common Errors in Excel
#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!" …
How to Find Merged Cells in Excel
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 …