Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select. Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns. Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range. Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails. The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% The above two methods only are applied to the specific worksheet, but if you want to show or hide the outline symbols in the whole workbook, you just repeat the way one by one.īut if you have Kutools for Excel’s View Options utility, you can quickly toggle the outline symbols between hiding and showing either in a worksheet or a workbook. Then click OK, the outline symbols in the specified worksheet will be hidden or displayed at once. In the Excel Options dialog box, click Advanced, and go to Display options for this worksheet section, specify the worksheet that you want to show or hide the outline symbols from the drop down list, then check or uncheck Show outline symbols if an outline is applied as you need to show or hide the outline symbols.ģ. Open the Excel Options dialog box by clicking File> Options in Excel 2010/2013. In the Excel Options dialog box, you can turn the outline symbols on and off with clicks. Note: with this shortcut keys, you can only show or hide the outline symbols in the active sheet, if you want to apply it to the whole workbook, this way will not work. Where the 8 is only using the key under the function keys, not the key in the Num keypad.Īctive the worksheet which contains the outline symbols, then press ctrl + 8 keys repeatedly to toggle the outline symbols between hiding and displaying. This hide and display shortcut is ctrl + 8. Here is an easy way to help you to toggle the outline symbols between showing and hiding. Show or hide outline symbols with Kutools for Excel 
Show or hide outline symbols with Excel Options
Show or hide outline symbols with shortcut keys How could you turn the outline symbols on and off quickly in Excel? When you want to summarize or do some subtotals for the data in your worksheet, there will be the outline symbols that Excel normally displays at the left of the worksheet area (as following screenshots shown).Sometimes, you don’t need these outline symbols, but sometimes, you want to show it.
0 kommentar(er)
