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

Hide Formulas in a Worksheet and Prevent Deletion
Excel Tip
This macro will hide all formulas within a workbook and not allow them to be deleted. The page will not be protected like a regular protected worksheet in excel; this means that you can still add content to the workbook without a problem and you can edit everything as long as it is not a formula. You can enter a new formula but you cannot then del ...
View Excel Tip
 
Sort Data With Headers in Ascending Order in Excel
Excel Tip
Macro that sorts data that has headers in ascending order in Excel. This macro assumes that you data has headers on it. This means that you data has a row that labels what the data underneath it is or stands for in the worksheet. The header row will not be sorted; however everything underneath that row will be sorted. Header rows are assumed to be ...
View Excel Tip
 
Delete Hidden Rows in a Workbook
Excel Tip
This macro will delete hidden rows from every worksheet in an entire workbook. However, note that this will only delete one hidden row from a group at once. This means that if you have rows 3-9 hidden on a sheet and rows 45-55 hidden on the same sheet, the last hidden rows (row 9 and row 55) will be deleted on that worksheet. This means that the e ...
View Excel Tip
 
Close a Workbook after a Time Limit is Reached
Excel Tip
This macro will automatically close the workbook in which it is located after that workbook has been opened for a certain period of time. This is a great feature when you are sharing workbooks that can't be open at the same time on more than one computer; in that situation this macro ensures that if someone forgets to close the file, it will autom ...
View Excel Tip
 
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Excel Tip
This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOut Method for Excel Macros and VBA in Excel. All of the arguments are explained below as well as how to use each argument and why you might want to use each argument. After reading this page, you will be able to create your own printing ...
View Excel Tip
 
Highlight Every Other Row in a Selection in Excel - Table Formatting
Excel Tip
This free Excel macro will highlight every other row in a selection of cells with a color that is specified within the macro. To use this macro, you must first select a range of cells or a table in Excel and then run the macro. From there, the first row and then every other row will have a background color. This allows you to easily navigate large ...
View Excel Tip
 
Open Microsoft Outlook from Excel
Excel Tip
This free macro will open the Microsoft Outlook program on your computer. You do need to have this program first. This will not open a specific email or attempt to send anything from excel or your computer; it simply opens the Microsoft Outlook program and nothing more. It can be attached to a button or checkbox or form and set to run when that it ...
View Excel Tip
 
Basic Web Query in Excel - Import Data from the Web into Excel
Excel Tip
Import data from the web into Excel with this macro. This is a basic web query macro that will import data from any website, as long as the data is contained within an html table, and put that data into a worksheet in Excel. This particular macro does not have auto refresh settings turned on and does not include and custom formatting options. This ...
View Excel Tip
 
Create a 12 Month Calendar With The Current Day Highlighted in Excel
Excel Tip
Create a 12 month formatted calendar on a new tab in Excel with the current day highlighted. This macro creates a nicely formatted 12 month calendar where all days in every month are listed and in date format. This means that you can immediately perform date related functions and formulas off of the dates created from this macro and calendar. This ...
View Excel Tip
 
Remove Comments from a Workbook in Excel - All Comments Deleted - Macro VBA
Excel Tip
Excel macro that will remove/delete all of the comments from an entire Excel workbook. This means that this macro will remove all of the comments from every worksheet within the current active workbook. This is a great macro to use in Excel to remove production or creation notes from a workbook or to simply clean up the workbook before it is sent ...
View Excel Tip
 
Excel Forum