XLSior logo
XLSior Online Help

Getting started
Overview
Requirements
Installation
Removal
Conventions
Limitations
Troubleshooting
Preferences
Setting preferences
User
Updating
Sort AutoDocs
Add information to worksheets
Printing
Add sheets to workbooks
Workbook
Updating
Sort AutoDocs
Add information to worksheets
Printing
Testing
Defining tests
Test sheet
Test set
Test data
Test conditions
Running Tests
Tips
Automated Documentation
Sheets
Names
Cell comments
External links
Advanced techniques
Summary sheet
Formatting
Input range
Heading range
Check range
Warning range
Manual range
Comments box
Timestamp
Documentation
Notes Sheet
Comments Box
Print Footer
Timestamps
Operating on sheets
Protecting sheets
Hiding sheets
Ordering sheets
Saving versions and releases
Versions
Releases
Automated importing
Defining imports
Updating imports
Programming with XLSior
Preferences
Testing
Automated documentation
Documentation
Formatting
Operating on sheets
Saving versions and releases
Automated importing
Help

Operating on sheets

Dealing with worksheets can be fiddly and time consuming in Excel. Many operations can be performed only one sheet at a time, requiring you to go through a series of menu selections and dialogs for each.

XLSior provides timesaving methods of operating on many sheets in your workbook at once. With XLSior you can hide or protect a group of sheets with a few clicks of the mouse, and unhide and unprotect sheets in the same way. You can also reorder the sheets in your workbook from one easy screen.

The menu XLSior > Operate on Sheets has the following commands:

Protect Sheets...
Choose the sheets in your workbook that should be protected or unprotected.
Hide Sheets...
Choose the sheets in your workbook that should be hidden or made visible.
Order Sheets...
Choose the order in which the sheets in your workbook should appear.

Related topics