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
How to split text from one cell into multiple cells quickly and easily in Excel.  This includes how to split names, part numbers, really anything you want.  You can split the text based on spaces in the text, commas, periods, or anything you specify. We will use the Text to Columns feature to do this. Desired Result: Steps to Split Text into Multip ...
 
Excel Tip
How to copy all of the formatting of a single cell to other cells in the spreadsheet without having to re-apply each formatting element separately.  This will save you a lot of time when formatting spreadsheets. Steps to Quickly Copy Cell Formatting to Other Cells Select the cell that contains the formatting that you want to replicate: On the Home ...
 
Excel Tip
How to show a smaller number that looks better without sacrificing decimal places or precision in the actual number. This has to do with formatting a number instead of actually rounding it.  The great thing about this is that when we format the number to have fewer decimal places, it will visually round the number for us while keeping the actual nu ...
 
Excel Tip
How to round a number up or down and also to a specified number of decimal places in Excel.  This will allow you to create more useful mathematical functions and formulas. Don't forget to download the accompanying workbook to follow along. Sections: Round a Number Up in Excel Round a Number Down in Excel Round a Number to a Specified Number of Digi ...
 
Excel Tip
How to calculate the payment amount for a loan or similar financial instrument that has a series of constant payments and a constant interest rate. This works great when calculating how much you will pay for a loan.  You will be able to find out the size of the payments that you will make, including interest and principal. Syntax PMT(rate, nper, pv ...
 
Excel Tip
How to limit the amount that a user can enter into a range of cells in Excel.  This works great for budgeting worksheets and really any type of worksheet where you need to force a user to keep values within a certain range or limit. To achieve this result, we will use the Data Validation feature of Excel. Here is our sample budget spreadsheet: Step ...
 
Excel Tip
How to generate random whole numbers (integers) that are between two numbers.  This allows you to set a minimum and maximum possible value and then generate random numbers within that range. Make sure to download the accompanying workbook to follow along. Sections: Steps to Generate Random Numbers within a Range in Excel Quickly Make a List of Rand ...
 
Excel Tip
How to prevent a user from entering any spaces within text in Excel.  This allows you to keep data clean when a user is entering something in Excel and helps to prevent data corruption. We will use data validation in Excel in order to achieve this result. Steps to Prevent Spaces Being Entered in Text in a Range in Excel Create the custom formula th ...
 
Excel Tip
How to quickly delete all empty cells or rows from a range in Excel.  This allows you to quickly clean your data to remove worthless blank sections that only serve to annoy you and break other features in Excel, like using the quick-fill handle to copy formulas down a column. Steps to Remove Blank Cells or Rows from a Range in Excel Select the colu ...
 
Excel Tip
How to quickly change all text to upper case or lower case in Excel.  This allows you to change the case of text without having to manually type in the text. I will show you how to change the case of text and also how to make the results of the functions we will use actual text instead of function/formula output. Also, check out our tutorial on how ...
 
Excel Forum