How to show formulas in cells and hide formulas completely in excel 2013

In case you want to maintain concentrate on working in a small a part of your worksheet in Excel, you could want to hide the unused cells, rows and columns for attaining it. Right here we’re going to information you to hide all unused cells, rows, and columns in Microsoft Excel 2007/2010 rapidly.

    (Four steps) (1 step)

Hide unused cells, rows, and columns with Hide & Unhide command

We are able to hide a complete row or column by Hide & Unhide command, and can hide all clean rows and columns with this command too.

Step 1: Choose the row header beneath the used working space in the worksheet.

Step 2: Press the shortcut keyboards of Ctrl + Shift + Down Arrow, and then you choose all rows beneath the working space.

Step 3: Click on the Residence > Format > Hide & Unhide > Hide Rows. Then all chosen rows beneath working areas are hidden instantly.

Step 4: Similar method to hide unused columns: choose the column header on the proper facet of used working space, press the keyboard shortcut of Ctrl + Shift + Proper Arrow, and click on Residence >> Format >> Hide & Unhide >> Hide Columns.

Now all unused cells, rows, and columns are hidden.

Hide unused cells, rows, and columns with Kutools for Excel

You probably have Kutools for Excel put in, you’ll be able to simplify the work and hide unused cells, rows, and columns with just one click on.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Free Trial Now!

Kutools for Excel – Combines greater than 300 Superior Features and Instruments for Microsoft Excel

Simply choose the used working space, and click on the Kutools > Show / Hide > Set Scroll Space, then it hides all unused cells, rows, and columns instantly.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Demo: hide unused cells, rows, and columns in Excel

Kutools for Excel contains greater than 300 useful instruments for Excel, free to strive with out limitation in 30 days. Obtain and Free Trial Now!

One click on to hide/unhide one or a number of sheet tabs in Excel

Kutools for Excel supplies many useful utilities for Excel customers to rapidly toggle hidden sheet tabs, hide sheet tabs, or show hidden sheet tabs in Excel. Full Characteristic Free Trial 30-day!

  1. Kutools >Worksheets : One click on to toggle all hidden sheet tabs to be seen or invisible in Excel;
  2. Kutools >Show / Hide >Hide Unselected Sheets : One click on to hide all sheet tabs besides energetic one (or chosen ones) in Excel;
  3. Kutools >Show / Hide >Unhide All Sheets : One click on to show all hidden sheet tabs in Excel.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

In case you want to maintain concentrate on working in a small a part of your worksheet in Excel, you could want to hide the unused cells, rows and columns for attaining it. Right here we’re going to information you to hide all unused cells, rows, and columns in Microsoft Excel 2007/2010 rapidly.

    (Four steps) (1 step)

Hide unused cells, rows, and columns with Hide & Unhide command

We are able to hide a complete row or column by Hide & Unhide command, and can hide all clean rows and columns with this command too.

Step 1: Choose the row header beneath the used working space in the worksheet.

Step 2: Press the shortcut keyboards of Ctrl + Shift + Down Arrow, and then you choose all rows beneath the working space.

Step 3: Click on the Residence > Format > Hide & Unhide > Hide Rows. Then all chosen rows beneath working areas are hidden instantly.

Step 4: Similar method to hide unused columns: choose the column header on the proper facet of used working space, press the keyboard shortcut of Ctrl + Shift + Proper Arrow, and click on Residence >> Format >> Hide & Unhide >> Hide Columns.

Now all unused cells, rows, and columns are hidden.

Hide unused cells, rows, and columns with Kutools for Excel

You probably have Kutools for Excel put in, you’ll be able to simplify the work and hide unused cells, rows, and columns with just one click on.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Free Trial Now!

Kutools for Excel – Combines greater than 300 Superior Features and Instruments for Microsoft Excel

Simply choose the used working space, and click on the Kutools > Show / Hide > Set Scroll Space, then it hides all unused cells, rows, and columns instantly.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Demo: hide unused cells, rows, and columns in Excel

Kutools for Excel contains greater than 300 useful instruments for Excel, free to strive with out limitation in 30 days. Obtain and Free Trial Now!

One click on to hide/unhide one or a number of sheet tabs in Excel

Kutools for Excel supplies many useful utilities for Excel customers to rapidly toggle hidden sheet tabs, hide sheet tabs, or show hidden sheet tabs in Excel. Full Characteristic Free Trial 30-day!

  1. Kutools >Worksheets : One click on to toggle all hidden sheet tabs to be seen or invisible in Excel;
  2. Kutools >Show / Hide >Hide Unselected Sheets : One click on to hide all sheet tabs besides energetic one (or chosen ones) in Excel;
  3. Kutools >Show / Hide >Unhide All Sheets : One click on to show all hidden sheet tabs in Excel.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

To maximise workspace, we might hide Formulation Bar in Excel. Nonetheless, Formulation Bar is important and useful once we edit formulas in cells. Listed below are some suggestions to change two display settings in Excel: displaying Formulation Bar and hiding Formulation Bar.

  • Show or hide the Formulation Bar with checking or unchecking Formulation Bar choice
  • Show or hide the Formulation Bar with Kutools for Excel
  • Show or hide Standing Bar/Formulation bar/Ribbon with only one click on

Show or hide the Formulation Bar with checking or unchecking Formulation Bar choice

We are able to show or hide the Formulation Bar below View tab in Excel Ribbon with Formulation Bar choice in the Show group.

If you need to show the Formulation Bar, test the Formulation Bar choice; if you’d like to hide the Formulation Bar, uncheck it.

Observe: You can too get this Show Formulation bar choice by clicking the File (or Workplace button) > Choices > Superior > Show > Show Formulation bar.

Show or hide the Formulation Bar with Kutools for Excel

Kutools for Excel‘s View Choices software is designed to show or hide spreadsheet settings, resembling Grid Strains, Web page Break, and many others. With it, we are able to simply show or hide the Formulation Bar in Excel:

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Free Trial Now!

Kutools for Excel – Combines greater than 300 Superior Features and Instruments for Microsoft Excel

1. Click on Kutools > Show / Hide > View Choices, see screenshot:

2. Within the View Choices dialog field, test or uncheck the Formulation Bar choice below the Software Settings part. See screenshot:

3. Click on Okay to apply the setting.(Observe: If you need to apply this feature to all of the worksheets, please click on Apply to all sheets.)

The View Choices makes it doable to show or hide most of Microsoft Excel settings rapidly, resembling Interior Tabs, Formulation Bar, Standing Bar, Home windows in Taskbar, Gridlines, Web page Breaks, Show Zeros, Vertical Scrollbar, Horizontal Scrollbar, Sheet Tab, … and many others. It should save your time in searching for these setting while you want to show or hide them.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Hide or Show Standing Bar/Formulation bar/Ribbon with only one click on

You probably have Kutools for Excel put in, its Work Space utility may also help you rapidly hide Standing Bar, Formulation Bar, or Ribbon simply in Excel, and additionally permits you to restore the default Excel view instantly.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Click on the Kutools > Work Space, it’ll routinely maximize the Excel window by hiding the Standing Bar, Formulation Bar, and Ribbon.

And you may also alter the view by buttons in the Work Space Dimension window. See display shot under:

In case you want to restore the default Excel window, simply click on the primary button in the Work Space Dimension window.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Demo: Show or hide formulation bar in Excel window

Kutools for Excel contains greater than 300 useful instruments for Excel, free to strive with out limitation in 30 days. Obtain and Free Trial Now!

In case you want to maintain concentrate on working in a small a part of your worksheet in Excel, you could want to hide the unused cells, rows and columns for attaining it. Right here we’re going to information you to hide all unused cells, rows, and columns in Microsoft Excel 2007/2010 rapidly.

    (Four steps) (1 step)

Hide unused cells, rows, and columns with Hide & Unhide command

We are able to hide a complete row or column by Hide & Unhide command, and can hide all clean rows and columns with this command too.

Step 1: Choose the row header beneath the used working space in the worksheet.

Step 2: Press the shortcut keyboards of Ctrl + Shift + Down Arrow, and then you choose all rows beneath the working space.

Step 3: Click on the Residence > Format > Hide & Unhide > Hide Rows. Then all chosen rows beneath working areas are hidden instantly.

Step 4: Similar method to hide unused columns: choose the column header on the proper facet of used working space, press the keyboard shortcut of Ctrl + Shift + Proper Arrow, and click on Residence >> Format >> Hide & Unhide >> Hide Columns.

Now all unused cells, rows, and columns are hidden.

Hide unused cells, rows, and columns with Kutools for Excel

You probably have Kutools for Excel put in, you’ll be able to simplify the work and hide unused cells, rows, and columns with just one click on.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Free Trial Now!

Kutools for Excel – Combines greater than 300 Superior Features and Instruments for Microsoft Excel

Simply choose the used working space, and click on the Kutools > Show / Hide > Set Scroll Space, then it hides all unused cells, rows, and columns instantly.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Demo: hide unused cells, rows, and columns in Excel

Kutools for Excel contains greater than 300 useful instruments for Excel, free to strive with out limitation in 30 days. Obtain and Free Trial Now!

One click on to hide/unhide one or a number of sheet tabs in Excel

Kutools for Excel supplies many useful utilities for Excel customers to rapidly toggle hidden sheet tabs, hide sheet tabs, or show hidden sheet tabs in Excel. Full Characteristic Free Trial 30-day!

  1. Kutools >Worksheets : One click on to toggle all hidden sheet tabs to be seen or invisible in Excel;
  2. Kutools >Show / Hide >Hide Unselected Sheets : One click on to hide all sheet tabs besides energetic one (or chosen ones) in Excel;
  3. Kutools >Show / Hide >Unhide All Sheets : One click on to show all hidden sheet tabs in Excel.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

To maximise workspace, we might hide Formulation Bar in Excel. Nonetheless, Formulation Bar is important and useful once we edit formulas in cells. Listed below are some suggestions to change two display settings in Excel: displaying Formulation Bar and hiding Formulation Bar.

  • Show or hide the Formulation Bar with checking or unchecking Formulation Bar choice
  • Show or hide the Formulation Bar with Kutools for Excel
  • Show or hide Standing Bar/Formulation bar/Ribbon with only one click on

Show or hide the Formulation Bar with checking or unchecking Formulation Bar choice

We are able to show or hide the Formulation Bar below View tab in Excel Ribbon with Formulation Bar choice in the Show group.

If you need to show the Formulation Bar, test the Formulation Bar choice; if you’d like to hide the Formulation Bar, uncheck it.

Observe: You can too get this Show Formulation bar choice by clicking the File (or Workplace button) > Choices > Superior > Show > Show Formulation bar.

Show or hide the Formulation Bar with Kutools for Excel

Kutools for Excel‘s View Choices software is designed to show or hide spreadsheet settings, resembling Grid Strains, Web page Break, and many others. With it, we are able to simply show or hide the Formulation Bar in Excel:

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Free Trial Now!

Kutools for Excel – Combines greater than 300 Superior Features and Instruments for Microsoft Excel

1. Click on Kutools > Show / Hide > View Choices, see screenshot:

2. Within the View Choices dialog field, test or uncheck the Formulation Bar choice below the Software Settings part. See screenshot:

3. Click on Okay to apply the setting.(Observe: If you need to apply this feature to all of the worksheets, please click on Apply to all sheets.)

The View Choices makes it doable to show or hide most of Microsoft Excel settings rapidly, resembling Interior Tabs, Formulation Bar, Standing Bar, Home windows in Taskbar, Gridlines, Web page Breaks, Show Zeros, Vertical Scrollbar, Horizontal Scrollbar, Sheet Tab, … and many others. It should save your time in searching for these setting while you want to show or hide them.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Hide or Show Standing Bar/Formulation bar/Ribbon with only one click on

You probably have Kutools for Excel put in, its Work Space utility may also help you rapidly hide Standing Bar, Formulation Bar, or Ribbon simply in Excel, and additionally permits you to restore the default Excel view instantly.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Click on the Kutools > Work Space, it’ll routinely maximize the Excel window by hiding the Standing Bar, Formulation Bar, and Ribbon.

And you may also alter the view by buttons in the Work Space Dimension window. See display shot under:

In case you want to restore the default Excel window, simply click on the primary button in the Work Space Dimension window.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Demo: Show or hide formulation bar in Excel window

Kutools for Excel contains greater than 300 useful instruments for Excel, free to strive with out limitation in 30 days. Obtain and Free Trial Now!

In case you want to maintain concentrate on working in a small a part of your worksheet in Excel, you could want to hide the unused cells, rows and columns for attaining it. Right here we’re going to information you to hide all unused cells, rows, and columns in Microsoft Excel 2007/2010 rapidly.

    (Four steps) (1 step)

Hide unused cells, rows, and columns with Hide & Unhide command

We are able to hide a complete row or column by Hide & Unhide command, and can hide all clean rows and columns with this command too.

Step 1: Choose the row header beneath the used working space in the worksheet.

Step 2: Press the shortcut keyboards of Ctrl + Shift + Down Arrow, and then you choose all rows beneath the working space.

Step 3: Click on the Residence > Format > Hide & Unhide > Hide Rows. Then all chosen rows beneath working areas are hidden instantly.

Step 4: Similar method to hide unused columns: choose the column header on the proper facet of used working space, press the keyboard shortcut of Ctrl + Shift + Proper Arrow, and click on Residence >> Format >> Hide & Unhide >> Hide Columns.

Now all unused cells, rows, and columns are hidden.

Hide unused cells, rows, and columns with Kutools for Excel

You probably have Kutools for Excel put in, you’ll be able to simplify the work and hide unused cells, rows, and columns with just one click on.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Free Trial Now!

Kutools for Excel – Combines greater than 300 Superior Features and Instruments for Microsoft Excel

Simply choose the used working space, and click on the Kutools > Show / Hide > Set Scroll Space, then it hides all unused cells, rows, and columns instantly.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Demo: hide unused cells, rows, and columns in Excel

Kutools for Excel contains greater than 300 useful instruments for Excel, free to strive with out limitation in 30 days. Obtain and Free Trial Now!

One click on to hide/unhide one or a number of sheet tabs in Excel

Kutools for Excel supplies many useful utilities for Excel customers to rapidly toggle hidden sheet tabs, hide sheet tabs, or show hidden sheet tabs in Excel. Full Characteristic Free Trial 30-day!

  1. Kutools >Worksheets : One click on to toggle all hidden sheet tabs to be seen or invisible in Excel;
  2. Kutools >Show / Hide >Hide Unselected Sheets : One click on to hide all sheet tabs besides energetic one (or chosen ones) in Excel;
  3. Kutools >Show / Hide >Unhide All Sheets : One click on to show all hidden sheet tabs in Excel.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

You probably have a worksheet with a number of knowledge together with numbers, texts and formulas, and you simply need to delete all knowledge however maintain the formulas in this worksheet, how will you do?

Chances are you’ll curiosity in:

Click on Enterprise > Worksheet Design to allow the Design tab, click on the Spotlight Formulas button, then all cells with formulas in the entire workbook are highlighted instantly. See under screenshot:

Kutools for Excel contains greater than 300 useful Excel instruments. Free to strive with no limitation in 60 days. Learn Extra Obtain the free trial now

  • Reuse Something: Add essentially the most used or complicated formulas, charts and anything to your favorites, and rapidly reuse them in the longer term.
  • Greater than 20 textual content options: Extract Quantity from Textual content String; Extract or Take away A part of Texts; Convert Numbers and Currencies to English Phrases.
  • Merge Instruments : A number of Workbooks and Sheets into One; Merge A number of Cells/Rows/Columns With out Shedding Knowledge; Merge Duplicate Rows and Sum.
  • Cut up Instruments : Cut up Knowledge into A number of Sheets Based mostly on Worth; One Workbook to A number of Excel, PDF or CSV Recordsdata; One Column to A number of Columns.
  • Paste Skipping Hidden/Filtered Rows; Depend And Sum by Background Colour ; Ship Personalised Emails to A number of Recipients in Bulk.
  • Tremendous Filter: Create superior filter schemes and apply to any sheets; Kind by week, day, frequency and extra; Filter by daring, formulas, remark.
  • Greater than 300 highly effective options; Works with Workplace 2007-2019 and 365; Helps all languages; Straightforward deploying in your enterprise or group.

Delete all knowledge however maintain formulas with Go To Particular perform in Excel

There isn’t a direct or one-click perform to delete all knowledge however formulas in Excel, however you need to use Go To Particular perform to choose all knowledge however formulas first and then delete them.

1. Choose the vary you need to delete all knowledge however formulas, press Ctrl + G keys simultaneusly to open the Go To dialog, then click on Special button in the dialog to open the Go To Particular dialog. See screenshots:

2. Then in the Go To Particular dialog, test Constants and click on OK to shut the dialog. See screenshot:

3. Now all the information however formulas are chosen, and press Delete button on the keyboard or proper click on to choose Delete to take away all knowledge besides forluma cells.

Delete all formulas however maintain knowledge with Kutools for Excel

Quite the opposite, in this part, we are going to show you ways to delete all formulas from chosen vary however maintain knowledge in Excel.

Earlier than making use of Kutools for Excel, please obtain and set up it firstly.

1. Choose the vary with formulas you need to take away however maintain the information, then click on Kutools > To Precise. See screenshot:

You’ll be able to see all formulas in chosen vary are eliminated instantly, however the calculated outcomes are saved in cells. See screenshot:

If you need to have a free trial ( 30-day) of this utility, please click on to obtain it, and then go to apply the operation in accordance above steps.

To maximise workspace, we might hide Formulation Bar in Excel. Nonetheless, Formulation Bar is important and useful once we edit formulas in cells. Listed below are some suggestions to change two display settings in Excel: displaying Formulation Bar and hiding Formulation Bar.

  • Show or hide the Formulation Bar with checking or unchecking Formulation Bar choice
  • Show or hide the Formulation Bar with Kutools for Excel
  • Show or hide Standing Bar/Formulation bar/Ribbon with only one click on

Show or hide the Formulation Bar with checking or unchecking Formulation Bar choice

We are able to show or hide the Formulation Bar below View tab in Excel Ribbon with Formulation Bar choice in the Show group.

If you need to show the Formulation Bar, test the Formulation Bar choice; if you’d like to hide the Formulation Bar, uncheck it.

Observe: You can too get this Show Formulation bar choice by clicking the File (or Workplace button) > Choices > Superior > Show > Show Formulation bar.

Show or hide the Formulation Bar with Kutools for Excel

Kutools for Excel‘s View Choices software is designed to show or hide spreadsheet settings, resembling Grid Strains, Web page Break, and many others. With it, we are able to simply show or hide the Formulation Bar in Excel:

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Free Trial Now!

Kutools for Excel – Combines greater than 300 Superior Features and Instruments for Microsoft Excel

1. Click on Kutools > Show / Hide > View Choices, see screenshot:

2. Within the View Choices dialog field, test or uncheck the Formulation Bar choice below the Software Settings part. See screenshot:

3. Click on Okay to apply the setting.(Observe: If you need to apply this feature to all of the worksheets, please click on Apply to all sheets.)

The View Choices makes it doable to show or hide most of Microsoft Excel settings rapidly, resembling Interior Tabs, Formulation Bar, Standing Bar, Home windows in Taskbar, Gridlines, Web page Breaks, Show Zeros, Vertical Scrollbar, Horizontal Scrollbar, Sheet Tab, … and many others. It should save your time in searching for these setting while you want to show or hide them.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Hide or Show Standing Bar/Formulation bar/Ribbon with only one click on

You probably have Kutools for Excel put in, its Work Space utility may also help you rapidly hide Standing Bar, Formulation Bar, or Ribbon simply in Excel, and additionally permits you to restore the default Excel view instantly.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Click on the Kutools > Work Space, it’ll routinely maximize the Excel window by hiding the Standing Bar, Formulation Bar, and Ribbon.

And you may also alter the view by buttons in the Work Space Dimension window. See display shot under:

In case you want to restore the default Excel window, simply click on the primary button in the Work Space Dimension window.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Demo: Show or hide formulation bar in Excel window

Kutools for Excel contains greater than 300 useful instruments for Excel, free to strive with out limitation in 30 days. Obtain and Free Trial Now!

To maximise workspace, we might hide Formulation Bar in Excel. Nonetheless, Formulation Bar is important and useful once we edit formulas in cells. Listed below are some suggestions to change two display settings in Excel: displaying Formulation Bar and hiding Formulation Bar.

  • Show or hide the Formulation Bar with checking or unchecking Formulation Bar choice
  • Show or hide the Formulation Bar with Kutools for Excel
  • Show or hide Standing Bar/Formulation bar/Ribbon with only one click on

Show or hide the Formulation Bar with checking or unchecking Formulation Bar choice

We are able to show or hide the Formulation Bar below View tab in Excel Ribbon with Formulation Bar choice in the Show group.

If you need to show the Formulation Bar, test the Formulation Bar choice; if you’d like to hide the Formulation Bar, uncheck it.

Observe: You can too get this Show Formulation bar choice by clicking the File (or Workplace button) > Choices > Superior > Show > Show Formulation bar.

Show or hide the Formulation Bar with Kutools for Excel

Kutools for Excel‘s View Choices software is designed to show or hide spreadsheet settings, resembling Grid Strains, Web page Break, and many others. With it, we are able to simply show or hide the Formulation Bar in Excel:

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Free Trial Now!

Kutools for Excel – Combines greater than 300 Superior Features and Instruments for Microsoft Excel

1. Click on Kutools > Show / Hide > View Choices, see screenshot:

2. Within the View Choices dialog field, test or uncheck the Formulation Bar choice below the Software Settings part. See screenshot:

3. Click on Okay to apply the setting.(Observe: If you need to apply this feature to all of the worksheets, please click on Apply to all sheets.)

The View Choices makes it doable to show or hide most of Microsoft Excel settings rapidly, resembling Interior Tabs, Formulation Bar, Standing Bar, Home windows in Taskbar, Gridlines, Web page Breaks, Show Zeros, Vertical Scrollbar, Horizontal Scrollbar, Sheet Tab, … and many others. It should save your time in searching for these setting while you want to show or hide them.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Hide or Show Standing Bar/Formulation bar/Ribbon with only one click on

You probably have Kutools for Excel put in, its Work Space utility may also help you rapidly hide Standing Bar, Formulation Bar, or Ribbon simply in Excel, and additionally permits you to restore the default Excel view instantly.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Click on the Kutools > Work Space, it’ll routinely maximize the Excel window by hiding the Standing Bar, Formulation Bar, and Ribbon.

And you may also alter the view by buttons in the Work Space Dimension window. See display shot under:

In case you want to restore the default Excel window, simply click on the primary button in the Work Space Dimension window.

Kutools for Excel – Contains greater than 300 useful instruments for Excel. Full characteristic free trial 30-day, no bank card required! Get It Now

Demo: Show or hide formulation bar in Excel window

Kutools for Excel contains greater than 300 useful instruments for Excel, free to strive with out limitation in 30 days. Obtain and Free Trial Now!