Ever notice that your workbook is increasing in size at an alarming rate for no apparent reason? There are several causes of workbook bloat and some slimming solutions. Workbook bloat is a term for a workbook that has had so much done to it that it has swollen to such a size it can no longer function correctly.
You open your workbook and are prompted to “Update Links,” but there are no links! How can you update links when they don’t exist?
Relative and absolute references are two types of cell references in Excel formulas. A relative reference is a cell address that changes when you copy or move the formula to another location. An absolute reference is a cell address that stays the same no matter where you copy or move the formula. These references allow you to use spreadsheets effectively and efficiently.
People frequently have to identify duplicated data within a list or table. Doing this manually can be very time-consuming and error-prone. To make this job much easier, you can learn one of Excel’s standard features, conditional formatting.
You may want to let users change cells containing data without providing them access to change formulas. You can keep cells containing formulas under lock and key without having to protect your entire sheet or workbook.
If you move around your spreadsheet a lot, or if you have data you don’t want readers to explore, you might find it convenient to limit the visible area of your spreadsheet to only that which has actual data.
If you’ve spent much time in a workbook with many worksheets, you know how painful it can be to find a particular worksheet. An index sheet available to every worksheet is a navigational must-have. In this tutorial, you’ll learn to create an index in a couple of ways.
If you work on the same workbooks each day, you can make these workbooks open automatically whenever you start Excel.
Sometimes you want a worksheet that users can’t read or modify, you can use the Excel hide and unhide feature. You can also use the xlSheetVeryHidden constant in VBE to hide the worksheet tab so deep that it cannot be turned visible again unless you use the VBA or VBE.
Excel lets you protect a workbook’s structure so that users cannot delete worksheets, rearrange the order in which they appear, rename them, and so forth. Or you can use VBA code disable or limit the number of worksheets in a Workbook.