|
» Grouping/ Ungrouping Sheets
CATEGORY: Excel Worksheet, Workbook |
VERSIONS: All Microsoft Excel Versions |
|
Grouping sheets has the following advantages: Allows setting the print options for a number of sheets at once. Allows changing an item from the View tab in the Options dialog box (Tools menu). Allows applying formats to many sheets. Allows unhiding of rows and/or columns simultaneously. Allows typing/inserting text or formulas for the same cell address in all grouped sheets. To group all sheets in the workbook: Select the first sheet in the workbook, hold the Shift key and click the last sheet tab in the workbook. OR From a sheet tab shortcut menu, select Select All Sheets. To group continuous sheets: Hold the Shift key and click a different sheet tab. To group non-continuous sheets: Hold the Ctrl key, click a different sheet tab and add it to the group. To ungroup sheets: Hold the Shift key and click the active sheet tab. |
|
RATING:
4.36
VIEWS: 20339 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Positioning: The Battle for Your Mind
- The Fall of Advertising and the Rise of PR
- Not-for-Profit Accounting Made Easy
- The Basics of Finance: Financial Tools for Non Financial Managers
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
