Category: Excel

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.

Learn how to grant people access to your workbook while removing their ability to print its content. Also, how to use VBA to disable printing for the entire workbook or a particular worksheet.

You can specify that any workbook be saved as read-only by checking the “Read-only recommended” checkbox to prevent a user from saving any changes he might make to the file.
You also can prevent users from being able to save a copy of your workbook to another directory or folder with or without a different name.

Although manually grouping and ungrouping sheets is easy, you must remember to group and ungroup your sheets as needed or else you will inadvertently overtype data from another worksheet. You can overcome these shortcomings by using some very simple VBA code.

It’s fairly ordinary to have the same data appear in multiple worksheets simultaneously. You can use Excel’s tool for grouping so that data in one workbook can be entered into multiple worksheets at the same time.

Learn how to arrange workbooks so they don’t overlap each other and you’re able to view or edit their data without having to switch from one workbook to another.