Excel Guides

Turning Off Worksheet Tabs in Excel

To turn off worksheet tabs in Excel, follow these steps:

  1. Open Microsoft Excel.
  2. Click on the File tab.
  3. Click on Options. This will open the Excel Options dialog box.
  4. Click on the Advanced option in the left sidebar.
  5. Scroll down to the "Display options for this workbook" section and check the box next to "Show sheet tabs". This will remove the check mark and disable the feature.
  6. Click on the OK button to save your changes and close the dialog box.



How to hide or unhide worksheet tabs in Excel (worksheet tab visibility options)

Hiding or unhiding sheet tabs is a quick way to organize your workbook or make it look more professional. You can also prevent users from accidentally deleting or renaming sheets by hiding their tabs. If you have a lot of sheets in a workbook, you can scroll through them more easily if their tabs are hidden.

Method 1: Hide all sheet tabs except active sheet tab using VBA code

Method 2 : Hide all sheet tabs except active sheet tab using macro

1.< / span >< / p > < p class = MsoNormal align = center style = 'text - align : center' > < span lang = EN - US > Open Microsoft Excel . Click on "Developer " tab . If you can not see Developer tab , please go to Method 3 . In "Developer " tab , click on "Visual Basic " button . This will open Visual Basic Editor window . In Visual Basic Editor window , double click on "ThisWorkbook " object in Project Explorer pane ( at left side ) . This will open code window for ThisWorkbook object . Copy and paste below code into code window and then save and close this file . Run this macro by pressing F5 key or by clicking on Run button . & nbsp ; & nbsp ; & nbsp ;  ;         ; & nbsp ; & nbsp ; & nbsp ; & nbsp ; & nbsp ; & nbsp ; & nbsp ;;

< p class = MsoNormal align = center \ r \ nstyle = 'text - align : center' > < span lang = EN - US \ r \ nstyle = 'font - size : 10\.0 pt \ r \ nsans - serif' > 2\. Open Microsoft Excel\. Click on Developer tab\. If you can not see Developer tab, please go to Method 3\. In Developer tab, click on Macro button\. This will open Macro dialog box\. In Macro dialog box, click on Options button\. This will open Macro Options dialog box\. Check Trust access to the VBA project object model option and then click OK button twice to close both dialog boxes\<\/span\ ><\/ p ><\/ td ><\/ tr ><\/ tbody ><\/ table >< p class = MsoNormal align = center \ r \ nstyle = 'text - align : center' > < span lang = EN - US \ r \ nsans - serif' > 3\< o : p / > Open Microsoft Excel\< br / > Click on File\< br / > Click on Options\< br / > In Excel Options dialog box , click on Customize Ribbon option in left sidebar\< br / > Check Developer option under Main Tabs section at right side and then click OK button\<\/span\ ><\/ p >< p class = MsoNormal align = center \ r \ nsans - serif' > 4\< o : p / > Now you can see Developer tab is visible at ribbon bar\< br / > Click on Developer tab\< br / > Click on Visual Basic button\< br / > This will open Visual Basic Editor window\< br / > In Visual Basic Editor window , double click on Sheet1 ( Sheet1 is default name of first worksheet ) object in Project Explorer pane ( at left side )\< br / > This will open code window for Sheet1 object\< br / > Copy and paste below code into code window and then save and close this file\<\/span\ ><\/ p >< table border = 1 cellspacing = 1 cellpadding = 1 width=\" 100 %\" bordercolor=\"#000000\" bgcolor=\"#FFFFFF\" \" \" \" \" \" \" \" \" \" \" \\t\\t\\t\\t\\t\\t\\t\\t \\t \\t \\t \\t \\t \\t \\t private sub worksheet_selectionchange(byval target as range)\\r\\n dim sh as worksheet\\r\\n for each sh in thisworkbook.worksheets\\r\\n sh.visible=true\\r\\n next sh\\r\\ntarget.parent.visible=false\\\\r\\\\nsaveandclose true\\\\r\\\\nexit sub\\\\r\\\\nerrorhandler::saveandclose false\\\\r\\\\nexitsub\\\\r\\\\nsaveandclose(byval flag as boolean) if flag then thisworkbook.save else thisworkbook.close end if end sub\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\">

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.