Email:      Pass:    Pass?
Featured Excel Content




Excel Tip
I'll show you how to completely remove the entire Quick Access Toolbar from Excel. This will allow you to have a streamlined Excel interface and to prevent users from accessing menu shortcuts.  This method will also remove the Ribbon Menu and either the File or Office buttons from the top of the window, depending on your version of Excel. Here is ...
Added: Aug 28, 2015
 
Excel Tip
I'll show you how to hide worksheets in Excel so that a user cannot see them but you can still access data on them. This method is the simplest way to hide a sheet and it will still allow you to easily access it when you need to.  This is especially good when you want to hide a source data tab or simply reduce clutter in the workbook. Hide a Works ...
Added: Aug 27, 2015
 
Excel Tip
I'll show you how to completely remove the entire Ribbon Menu from Excel. This will allow you to have a streamlined Excel interface and to prevent users from accessing any menu in Excel.  As well, this method will hide the quick access toolbar and the Office or File buttons (depending on your version of Excel). Here is the normal Excel interface: ...
Added: Aug 26, 2015
 
Excel Tip
I show you how to prevent duplicate values being entered into Excel using Data Validation. Let's say we have a list of part numbers and we want to make sure that there are no duplicates, that a part number is not put into the list more than once. First, select the range where you will be entering the list: Make sure to select enough rows so that a ...
Added: Aug 25, 2015
 
Excel Tip
I'll show you how to make formulas and functions that automatically update when more data is added to a range in Excel.  A simple example is when you want to sum a range that will have more data added to it over time.  You don't want to have to continue to update your formulas and functions, so you want dynamically updating formulas and functions. ...
Added: Aug 24, 2015
 
Excel Tip
I'll show you how to make a drop down list menu in a cell in Excel.  This allows you to have a list appear when you click a cell and you can then select an item from the list to have it appear in the cell. This is a great way to make it easier for a user to enter a correct value in a cell. Here is what we want to have: There are two simple ways to ...
Added: Aug 21, 2015
 
Excel Tip
The OFFSET function in Excel returns a cell or range reference that is a specified number of rows and columns away from a particular cell.  You can also specify how large the returned range reference will be. This can sound confusing so let's look at an example: Here I used the OFFSET function to return 1759, the value in cell C3, while using cell ...
Added: Aug 20, 2015
 
Excel Tip
How to create a named range that expands automatically when a new value is added to the range. This is a great little trick and it will save you a lot of time from updating your named ranges in Excel. The Problem When you create a named range in Excel, it will not update when you add a new value to that range or list. The Solution The solution is ...
Added: Aug 19, 2015
 
Excel Tip
I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Excel. All 3 methods are multi-step, but there is no way around this. Here is the issue: 3 ways to Remove Blanks from a Data Validation Dropdown Menu List Sorting Method (easy) Remove Blanks Quickly (easy) Complex Formula (complex) Sorting Method The sorting method ...
Added: Aug 18, 2015
 
Excel Tip
Data Validation is a tool in Excel that you can use to limit what a user can enter into a cell.  It is a great tool for creating forms or really anything where you want to ensure that erroneous values are not entered into a spreadsheet. What is Data Validation in Excel? Here is a simple example of Data Validation used to create a drop-down menu th ...
Added: Aug 17, 2015
 
Subscribe for Free Excel tips & more!
E-mail: