“Sheets” utilities
Language:
In the Excel menu choose ASAP Utilities » Sheets to access these 23 utilities:
- Add new worksheet (fill in a name)... (2 screenshots »)
- Insert multiple sheets (uses the cell values as sheet names)... (2 screenshots »)
- Rename current sheet... (1 screenshot »)
- Change name of selected sheets to selected cell's value (2 screenshots »)
- Insert sheet(s) name in selected cell(s) (2 screenshots »)
- Create an index page with links to all sheets (clickable)... (3 screenshots »)
- Print multiple sheets at once... (1 screenshot »)
- Remove all empty worksheets
- Unhide all sheets
- Hide selected sheets
- Hide selected sheets extra (xlVeryHidden)
- Sort all sheets... (3 screenshots »)
- Set print area on selected worksheets (3 screenshots »)
- Clear the print area on selected sheets (3 screenshots »)
- Remove all page breaks on the selected worksheets
- Put together rows or columns from several sheets... (1 screenshot »)
- Protect multiple sheets at once... (1 screenshot »)
- Unprotect multiple sheets at once... (1 screenshot »)
- Remove all unused styles on every sheet
- Freeze panes on multiple sheets at once
- Unfreeze panes on multiple sheets at once
- Remove unused empty ending rows/columns (2 screenshots »)
- Reset Excel's last cell (1 screenshot »)
Submenu screenshot
« Return to the list of tools.
© 1999-2010 - Bastien Mensink - ASAP Utilities - Excel tools - A Must in Every Office BV - The Netherlands 