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

Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
Excel Tip
This Excel macro allows you to filter a data set on multiple columns and criteria at once. This means that you can filter the data based on values in column A and then Column B etc. You can also have separate criteria for every column. This allows you to be able to narrow your data sets down to just exactly what you need to view; this is similar t ...
View Excel Tip
 
Add Background Photos / Images to Comments in Excel
Excel Tip
Add background images and photos to your comments in Excel with this macro. This macro uses a really cool feature in Excel that allows you to set a photo or image from your computer as the background image for a comment. This allows you to spruce up your comments to make them less boring or simply in line with the them of your workbook or workshee ...
View Excel Tip
 
Create a Bar Chart With a Macro in Excel
Excel Tip
Create a bar chart in Excel with this macro. You will be able to quickly and easily turn any range of numbers and data into an Excel bar chart. This is a great macro because it is so simply and therefore easy to integrate into any existing projects of macros for Excel. This macro has a hard-coded (static) range as the reference for the source data ...
View Excel Tip
 
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
Excel Tip
Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a great little macro that allows you to automatically add a drop down menu to any cell within a worksheet in Excel. This is part of the data validation features in Excel and this macro, since it is self-contained, is very easy to add to any other macro you may be u ...
View Excel Tip
 
Send Emails through Outlook using Email Addresses from Excel and text from Word
Excel Tip
This macro allows you to send an email to a list of recipients through excel. The email will be sent through Outlook and the list of recipients is in excel. The message or body of the email is a word document located anywhere on your computer. The entire macro is run through excel and the email addresses used are listed in excel. When you run the ...
View Excel Tip
 
Create a Line Chart with a Macro in Excel
Excel Tip
Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from a selection of data on the worksheet. As this macro is currently set, the range from which the line chart will be created is a static range that is hard-coded into the macro. This is a bare-bones version of this macro and is in th ...
View Excel Tip
 
Automatically Run a Macro at a Certain Time - i.e. Run a Macro at 4:30PM every day
Excel Tip
Automatically run an Excel macro at a certain time. This allows you to not have to worry about running a macro every day. This macro will, on its own, run another macro in your workbook at a certain time in the day. This is a great macro to use to automate your Excel spreadsheets. This macro only works in the ThisWorkbook vba section and not a mod ...
View Excel Tip
 
Automatically Run a Macro so Many Seconds, Minutes, or Hours After an Excel Workbook has been Opened
Excel Tip
Run a macro after a certain amount of time has passed since the Excel workbook was opened. This means that you can set this macro to run another macro after the Excel workbook has been open for 10 seconds, 25 minutes, 1 hour, etc. This allows you to run times sensitive macros in Excel, such as time based warnings - i.e. "You have 15 minutes left f ...
View Excel Tip
 
Format Cells as a Percentage in Excel Number Formatting
Excel Tip
This free Excel macro formats a selection of cells as a Percentage in Excel. This simply changes a cell's number format to the Percentage number format. That will multiply any number by 100 in order to display the correct percentage number, which is what Excel does when you change the number format to Percent. This Excel macro is great for quickly ...
View Excel Tip
 
Filter Data to Show the Bottom X Number of Items in Excel - AutoFilter
Excel Tip
This free Excel macro filters a data set to show the bottom X number of items from that data set. This macro is really great because you can easily customize it to choose how many items you want to be displayed after you run the filter. To determine the number of items to display simply replace the "#" sign in the macro with the number of items wh ...
View Excel Tip
 
Excel Forum