Extract Data from a Corrupt Workbook
Workbooks sometimes become corrupt for no apparent reason. This can cause all sorts of problems, especially if the workbook is vital and for whatever reason you have no backup. Read more...
MS-Excel - General Formatting Tutorials
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...
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...