Free Stuff
Video Tutorials
Free Macros
Excel 2007 Resources
Keyboard Shortcuts
Forum
Contact/About
Macros
How to Use a Macro
|
Macros Tutorials
|
Macros Forum Section
Macros added December 1
Free Macros
Reverse Data Order in Rows and Columns in Excel
Delete Only Completely Empty Rows in Excel
Delete Rows with Empty Cells in Selected Column
Convert Text to Uppercase
Convert Text to Lowercase
Convert Text to Proper Case - First Letter Capitalized
Protect and Unprotect all Worksheets at Once
Prevent Saving a Workbook under a Different File Name - Though can still Save in a Different Location
Disables the "Save As" Feature in Excel
Get Source Data/Values from a Chart
Email Current Workbook & or Other Attachments
Email (from Excel) using Email Addresses from Excel and text from Word
Delete Duplicate Rows
Delete Rows Based on Predefined Textual Criteria
Delete Hidden Rows in a Workbook
Delete Hidden Worksheets in a Workbook
Print all Embedded Charts in the Entire Workbook
Print All Embedded Charts That are in a Worksheet
Bubble Sort Ascending or Descending
Replace Formulas with their Values for all Worksheets in the Workbook
Highlight the Active or Selected Cell Automatically
Close a Workbook after a Time Limit is Reached
Delete Multiple Named Ranges Quickly
Delete Empty or 'Broken' Named Ranges (#REF!)
Sort Worksheet Tabs - Ascending or Descending Order
Name Worksheets Based on a Cell within the Worksheet
Hide Formulas Only, in a Worksheet, and Prevent Deletion
Quickly Change Formulas to Absolute or Relative References
Enter Text/Characters with a Double-Click of the Mouse
Notify When a Cell Reaches a Certain Value or Contains Certain Text
Notify When a Range of Cells Reaches a Certain Average
Delete All Text from Selected Cells
Delete Empty Columns
Delete (Remove) Hyperlinks from Worksheets
Reverse Cell Contents (Mirror)
Highlight Cells with Text or Formulas (non-empty cells)
Highlight Cells with Formulas
Highlight the Row and Column of the Selected Cell Automatically
Highlight the Row of the Selected Cell Automatically
Highlight the Column of the Selected Cell Automatically
Combine Multiple Workbooks into One
Open any Program on Your Computer from Excel
Open a Word Document from Excel
Open a PowerPoint Presentation from Excel
Open Microsoft PowerPoint from Excel
Open Microsoft Word from Excel
Open Microsoft Outlook from Excel
Most Recent Tutorials
Nov. 25
Group and Ungroup Cells in Excel (Easily Hide and Unhide Data)
Absolute and Relative Cell References & INDIRECT() Function
Sep. 20
Bond Pricing and Valuation
Calculate the Future Value of a Retirement or Savings Plan
Calculate the Net Present Value of Future Cash Flows
Build a Loan/Mortgage Payment Calculator
Calculate Interest and Principal Payments on a Loan
Sep. 10
FIND() LEN() Functions - Extract Text from Cells - Intermediate
FIND() LEN() Functions - Extract Text from Cells - (2 Parts) - ADVANCED
VLOOKUP() Between Separate Worksheets and Workbooks
