Select all sheets in excel ở đâu
In general, we can easily select one sheet tab by clicking it on the Sheet Tab bar in Excel. However, sometimes you may need to select multiple or all sheet tabs at the same time, how could you get it done? There are two easy solutions for you!
Select multiple or all sheet tabs with hotkeysYou can select multiple or all sheet tables with the Ctrl key or the Shift key in Excel. Holding the Ctrl key, you can select multiple nonadjacent sheet tabs by clicking them one by one. Holding the Shift key, you can select multiple adjacent sheet tabs by clicking the first sheet tab and the last one. Navigation Pane: quickly select and activate opening workbooks and their sheets in ExcelKutools for Excel’s Navigation Pane lists all opening workbooks and corresponding worksheets vertically as below screenshots. (1) Clicking a workbook in the Workbook section will switch to this workbook window; (2) while clicking a worksheet in the Worksheet
section will skip to open this worksheet. Full Feature Free Trial 30-day! Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now Select all sheet tabs by right-clicking menuApart from the Ctrl key or Shift key, you can also select all sheet tabs easily with the right-clicking menu in Excel. Now you will see all
sheet tabs are selected in bulk. See screenshot: Related articles:The Best Office Productivity ToolsKutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
Comments (0) No ratings yet. Be the first to rate! |