ExcelisHell Videos

Visit www.teachexcel.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to create custom error messages with this free Excel video tutorial. This shows you how to change the default data validation error messages to something that actually describes the error that was encountered. This is a particularly important feature to use when you need to let users know exactly what the error was that they caused so that they know how to correct the error. This tutorial shows ...

Tags: excel data validation error messages custom help problems worksheets pop up

Visit www.teachexcel.com for more, including Excel Consulting, Macros, and Tutorials. Excel video tutorial showing you how to use Data Validation in Excel in order to prevent a user from entering a space before or after text in a cell in Excel. This teaches you how to prevent leading or trailing spaces from being entered into cells. The benefit of checking for this and of preventing a user from entering such as value is so ensure that functions and formulas that reference the original cells ...

Tags: excel data validation trim prevent spaces entered cells leading trailing stop

Visit www.teachexcel.com for more, including Excel Consulting, Macros, and Tutorials. Excel video tutorial that teaches you how to run macros from drop down menus in Excel. This Excel video tutorial walks you through the steps you need to take in order to make a macro run when you select an option from a data validation drop down menu in Excel. This includes teaching you how to create the drop down menu in Excel; how to create the basic macro to run based off of the drop down menu; and, how ...

Tags: excel macros drop down menus lists data validation run view start automation

Visit www.teachexcel.com for more, including Excel Consulting, Macros, and Tutorials. Excel video tutorial that describes how to enter data into cells that contain drop down menus using data validation. This method teaches you how to be able to enter data into a data validated drop down menu cell that is not contained within the drop down menu. Basically, you will be able to enter values that are not contained in the drop down menu into a cell with a drop down menu. This allows you to simply ...

Tags: excel data validation drop down menus lists non valid values other accept enter free

Visit www.teachexcel.com formore, including Excel Consulting, Macros, and Tutorials. Neat Excel tip for adding extra lines to cells in Excel. This allows you to have paragraph style formatting for text within a cell whereby you can enter text on lines below other text within the same cell in Excel. This allows you to have better looking and better formatting spreadsheets in Excel. You can also use this technique to insert blank lines after or before text within a cell in Excel. This method ...

Tags: excel text multiple lines enter alt cells paragraph formatting

Visit www.teachexcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you to create dependent drop down menus lists in Excel using complex or multiple word names or phrases for the items in the first drop down menu. This concept may sound confusing at first but if you want to use multi word item names for the items contained in the first drop down menu in a series of connected and dependent drop down menus in Excel, you need to view this ...

Tags: excel drop down menu data validation lists in cell dependent multi word name items category categories

Visit www.teachexcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you how to create multiple dependent drop down menus in Excel. Multiple dependent drop down menus in Excel means in cell drop down menus that change depending on what is in another drop down menu. This is a great feature to use when you need to create a sort of 'drill-down' system whereby the user selects an item from a broad category and is then able to select items from ...

Tags: excel drop down menu dependent lists multiple reference rely data validatoin help

Visit www.teachexcel.com for more, including Excel Consulting, Macros, and Tutorials. Create drop down menus in Excel with source (list) data from separate tabs within Excel. This Excel video tutorial shows you how to create a drop down menu that uses data from separate worksheets within Excel. This is a great tutorial to view because of the fact that you can just point to a range in a separate worksheet in Excel through data validation. Instead, you have to use named ranges with data ...

Tags: excel drop down menu lists separate worksheets tabs data validation

Visit www.teachexcel.com for more, including Excel Consulting, Macros, and Tutorials. Step by step guide to creating drop down menus in Excel. This Excel video tutorial shows you how to use data validation in Excel in order to make a drop down menu that displays from any cell within a worksheet. This is a great tutorial for anyone who is not familiar with data validation but who still needs to make a drop down menu in Excel. The real benefit to using drop down menus in Excel is that you can ...

Tags: excel drop down menu list in cell data validation create make free video tutorial

Visit www.teachexcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you how to repeat title rows and columns in Excel for every page that is printed. This allows you to view the same rows at the top of a column on each page so that you know what every column stands for in the printed spreadsheet. You will also see how to do this for columns when your data is organized left to right instead of up to down. This is a great tutorial to view to ...

Tags: excel printing rows columns titles headers reapeat every page page setup easier to read