Search TeachExcel

New Excel Help Service!

We need your input to help create a new Live Online Excel Help service.

Please take our survey and let us know your thoughts!

Excel Survey

Have a great day!

Don


Featured Excel Content


Excel Tip
Tutorial showing you how to make a user enable macros in a workbook in order to view the workbook. This is very important when macros make-up a critical part of the workbook and not having them can stop the workbook from performing correctly or allow users to mess-up or corrupt the data and functionality of the spreadsheet. There are a few steps i ...
 
Excel Tip
How to make a macro run automatically after a workbook is opened and before anything else happens. You need this macro code: Private Sub Workbook_Open() 'simple message box that will pop-up and say "Hi!" to show you that the macro is working MsgBox "Hi!" End Sub The trick is that you must put this macro code into ThisWorkbook Steps to Make a Macro ...
 
Excel Tip
Display numbers in Excel as zip/postal codes and phone numbers in order to make them easier to read and retain any leading zeros if they exist. (make sure to download the sample workbook so you can follow along) Sections: Displaying Zip/Postal Codes in Excel Displaying Phone Numbers in Excel Custom Phone Number Formatting Zip Codes with Text Other ...
 
Excel Tip
How to remove the #N/A error from Vlookup and replace it with a friendly message or a blank cell. Fix the Vlookup Error in Excel 2007, 2010, 2013, and Later Fix the Vlookup Error in Excel 2003 The Problem You get the #N/A error when Vlookup can't find any data or when you haven't entered a value for the lookup_value argument.   The Vlookup functio ...
 
Excel Tip
Here, I'll teach you what the errors in Excel mean.  There are many errors that you can get and each one means something. (make sure to download the accompanying spreadsheet so you can follow along and learn how to fix these errors) Quick Links to Each Error Section: ###### #DIV/0 #N/A! #NAME? #NULL! #NUM! #REF! #VALUE! ###### When your column isn ...
 
Excel Tip
I'll show you 2 ways to add and keep leading zeros in front of numbers in Excel. These two methods are very simple to use and will help keep your data from getting corrupted. Method 1 - Add Apostrophe The first way to keep leading zeros in front of numbers is to put an apostrophe ' in front of the number. Notice how I input '0123 and not just 0123 ...
 
Excel Tip
This feature allows you to make an Excel file that tells everyone that it is the final version, the completed version. This is great when you need to send a file to someone while at the same time letting them know that no further changes need to or should be made to the workbook. Note: this feature does not prevent a user from making changes to th ...
 
Excel Tip
I will show you a few ways to change negative numbers to positive numbers and back again in Excel. Don't forget to download the accompanying workbook so you can follow along with the tutorial. Method 1 - Convert Negative Values to Positive Values You can use the "paste special" method to change numbers from negative to positive or positive to nega ...
 
Excel Tip
I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situation often happens when you export data from another program to Excel and it can wreak havoc in your spreadsheets. Here are three simple ways to converts numbers to their proper number format: (Don't forget to download the accompanying workbook so you can follow ...
 
Excel Tip
How to use the Vlookup function when your data has extra spaces in it. This happens when the lookup data is imported with leading or trailing spaces and it will break your formulas and functions. This tutorial assumes that you are already familiar with Vlookup; if you are not, first read our vlookup tutorial for Excel. The Problem Everything shoul ...
 
Excel Forum