MS-Excel - General Formatting Tutorials

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.

Have you ever eaten so much that you can't function properly? Workbook bloat in Excel is much the same thing.

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.

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.

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).

You can create an index in a few ways: by hand, auto-generated by code, or as a context-sensitive menu option.

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, and you need to use it on a daily basis.

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.

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.

You can use Excel's tool for grouping so that data entered in one workbook can be entered into multiple worksheets simultaneously.