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


Excel Tip
Hide comments in Excel with this macro. Comment indicators will still appear in the cells and users will also be able to view the comments when hovering over a cell that contains a comment. This macro serves as a way to put comments back to their default behavior in Excel and is great to use when you have a lot of comments set to permanently show ...
 
Excel Tip
This free excel macro allows you to print the entire workbook in Excel. You can easily set this macro to a button within the spreadsheet and allow users to more easily print the entire workbook or Excel file. Where to install the macro:  Module Print Entire Workbook in Excel Macro Sub Print_Current_Workbook() 'Prints the current active workbo ...
 
Excel Tip
This macro will allow you to specify certain criteria and then to delete rows based upon that criteria. You will choose the Row, Column, and Sheet where you want to delete the rows; then you will select what you want to look for to delete a row - you type in keywords, which, if present in a cell, will cause that row to be deleted. This is a little ...
 
Excel Tip
This macro will print every embedded chart in the active workbook. If you have an embedded chart in any worksheet within the workbook, it will be printed. This macro will print the charts on separate pages so that each chart will be on its own page. Where to install the macro:  Module Print all Embedded Charts in the Workbook Sub PrintEmbedde ...
 
Excel Tip
This free Excel macro allows you to apply filter settings to a data set, list, or range of data in Excel. This will not actually filter the data but it will put the filter "arrows" into the header row of the data set. This lets people know that the data set is ready to be filtered and makes it easier to filter the data when needed. If you already h ...
 
Excel Tip
This macro will delete rows that appear twice in a list or worksheet. If two cells are identical, this macro will delete every row with an identical cell which is underneath the first occurrence. The first instance will still remain, but all identical cells in the rows underneath the original cell will be deleted. In order to run the macro, you ne ...
 
Excel Tip
This macro for Microsoft Excel allows you to combine multiple workbooks and worksheets into one new workbook and worksheet. When the macro runs, it prompts you to select which excel files from your computer you would like to combine and, once you select them and press ok, this macro will pull data from pre-specified worksheets in the selected workb ...
 
Excel Tip
This UDF (user defined function) calculates the Future Value of Compound Interest in Excel. The mathematical formula that is behind this function is PV * (1 + r) ^ N. This is a great function to include in your workbook if you often work with financial calculations such as the future value of invested sums of money or other assets. This adds funct ...
 
Excel Tip
This Excel macro filters data in Excel without the filter "arrow" appearing in the column that is being filtered. This macro can be used to make a filtered data set appear more aesthetically pleasing ot to simply to try mask the fact that data has been filtered or make it harder for the user to re-filter the data in Excel. However you want to use t ...
 
Excel Tip
This is a WEEKNUM UDF for Excel. This allows you to determine the number of the week in the year on which a particular date falls. This UDF allows you to use the WEEKNUM function (standard in Excel 2007) in previous versions of Excel and across different regional versions or languages of Excel. This function is exactly the same as the WEEKNUM() fu ...
 
Excel Forum