Ctrl+T: Create Table Box
"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 …
Category: Microsoft Excel
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 …
How to Highlight the Bottom 10 Items
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 …
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!" …