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
Make a macro run when you click a button in the worksheet in Excel. This allows you to create a button and put it anywhere in the spreadsheet and then to have a macro run when that button is clicked. Steps to Have a Macro Run When a Button is Clicked Create the button.  Go to the Insert tab and click the Shapes button and select the desired button ...
 
Excel Tip
How to increment a value, number, percent, etc. every so many rows in Excel. This tutorial teaches you how to build the formula needed to increment a value or, really, do anything every so many rows in Excel. Section: The Formula That Knows in Which Row You are in Excel How to Increment a Value Based on Which Row You are in Excel Data Set Not on Ro ...
 
Excel Tip
How to calculate the number of periods required for an investment in order to get the desired return.  The number of periods required for the investment tells you how long the investment must last.  This is based on a constant interest rate, a present value, and an optional future value. Syntax =NPER(rate, pmt, pv, [fv], [type]) Argument Descriptio ...
 
Excel Tip
Quickly find all rows in Excel that contain a certain value and then delete those rows. This is a simple technique for quickly searching an entire worksheet to locate specific rows that you can then delete without having to individually search a data set and delete each row. Steps to Delete All Rows that Contain a Specific Value Go to the workshee ...
 
Excel Tip
I'll show you the top keyboard shortcuts for Excel that are sure to increase your productivity. These shortcuts are easy to learn and are ones that I use almost every day. Move Between Worksheets Ctrl + Page Down Move to the next worksheet to the right. Ctrl + Page Up Move to the next worksheet to the left Move Up, Down, Left, or Right After Enteri ...
 
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 Forum