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

Reverse the Contents of a Cell in Excel - UDF
Excel Tip
Reverse cell contents with this free Excel UDF (user defined function). This will mirror all cell contents regardless of the type of content contained in the cell. This includes numbers, text, or a mixture of both. The only argument for this function is the reference to the cell which you want to mirror and, as a result, this is a very easy to use ...
View Excel Tip
 
Open a Word Document from Excel
Excel Tip
This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word document on your computer. This is a small but cool macro; you can attach it to a button or checkbox and then, whenever a user clicks the button or checkbox, have a specified Microsoft word document open. You can change the word docume ...
View Excel Tip
 
Format Cells in The Short Date Number Format in Excel
Excel Tip
This free Excel macro applies the Short Date number format to a selection of cells in Excel. This number format displays the date like this: m/d/yyyy. The date is only in numbers and the month is the first number, day of month the second number, and the year represented in 4 digits is the last number. This macro is a great piece of vba code to use ...
View Excel Tip
 
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
 
Excel Forum