Reduce Workbook Size
Have you ever eaten so much that you can't function properly? Workbook bloat in Excel is much the same thing. Read more...
MS-Excel Tutorials
Subcategoreis
Excel 2003 Functions and Formula General Formatting Getting Started
Excel Techniques
In this excel tutorial you will learn find duplicate data using conditional formatting, find data that appears two or more times using conditional formatting, custom toolbars to a particular workbook. Read more...
Lock and Protect Cells Containing Formulas
When we create a spreadsheet, most of us need to use formulas of some sort. Sometimes, however, you might not want other users to tamper/delete/ overtype any formulas you included on your spreadsheet. Read more...
Limit the Scrolling Range of Your Worksheet
All Excel worksheets created in Excel 2007 have a column limit of 16,384 (256, A to IV, in previous versions) and a rowlimit of 1,048,576 (65,536 pre-2007). Read more...
Create an Index of Sheets in Your Workbook
You can create an index in a few ways: by hand, auto-generated by code, or as a context-sensitive menu option. Read more...
Customize the Templates Dialog and Default Workbook
Imagine you have a spreadsheet containing days of the year and formulas summarizing various data for the days. You have formatted this spreadsheet beautifully with your company colors, logo, and required formulas. Read more...
Prevent Unnecessary Prompts
The types of prompts we are talking about are those that ask you whether you want to enable macros (when you do not have any), or whether you are sure you want to delete a worksheet. Read more...
Prevent Users from Performing Certain Actions
You can manage user interactions with your spreadsheets by monitoring and responding to events. Events, as the term suggests, are actions that occur as you work with your workbooks and worksheets. Read more...
Enter Data into Multiple Worksheets
You can use Excel's tool for grouping so that data entered in one workbook can be entered into multiple worksheets simultaneously. Read more...
VBA Debugging Tips
Debugging your procedures can be a frustrating job, even during the best of times. Here are a few tips to keep in mind when tracking down programming problems. Following these sections: Read more...
VBA Functions
VBA boasts more than 160 built-in functions that cover data conversion, dates and times, math, strings, and much more. Read more...
VBA Tips
In this tutorial (with the possible exception of the section "Tips for Faster Procedures"), they're indispensable when you do need them. Read more...
Creating Custom VBA Dialog Boxes
This tutorial starts you off by showing you how to use VBA's Microsoft Forms feature to create custom dialog boxes and input forms. Read more...
Excel Programming
This tutorial looks closely at that interaction. You learn how to work with all the most common Excel objects, including the Workbook, Worksheet, and Range objects. Read more...
Controlling Your VBA Code
One of the advantages of writing your own VBA procedures instead of simply recording them is that you end up with much more control over what your code does and how it performs its tasks. Read more...