• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Support Your Tech

Instructions and tutorials to help you get the most from your applications and devices

  • Android
  • Excel
  • Word
  • iPhone
  • Mac
  • Docs
  • Slides
  • Sheets
  • Streaming
You are here: Home / Excel / How to Hide the Formula Bar in Excel 2013

How to Hide the Formula Bar in Excel 2013

November 27, 2018 By Matt Jacobs

The formula bar above the cells in your Excel spreadsheet provides a convenient, centralized location for you to view and create formulas in your cells. But, depending on how you use Excel, you may not actually be using or need that space, as you are able to type formulas directly into your cells.

If you find the formula bar to be unnecessary and would prefer to move your spreadsheet up a little higher on the screen so that you can see more of it, then you might be looking for a way to get rid of the formula bar in Excel 2013. Our tutorial below will show you where to find and change this setting to remove Excel’s formula bar from view.

 

How to Remove the Formula Bar Above the Spreadsheet in Excel 2013

The steps in this article are going to show you how to hide the formula bar that appears above your cells in an Excel spreadsheet. This is a program-wide setting, so changing it once will affect the display of the formula bar for every other spreadsheet that you open in Excel 2013. Note, however, that this won’t prevent you from using or creating formulas. It just remove the formula bar.

Step 1: Open Excel 2013.

 

Step 2: Click the File tab at the top-left corner of the window.

how to hide the formula bar in excel 2013

 

 

Step 3: Click Options in the left column.

can i delete excel's formula bar

 

 

Step 4: Select the Advanced tab in the left column of the Excel Options window.

get rid of formula thing above spreadsheet

 

 

Step 5: Scroll down to the Display section of the menu, click the box to the left of Show formula bar to remove the check mark, then click the OK button at the bottom of the window.

excel 2013 how to remove formula bar

 

 

The formula bar should no longer be visible.

 

Having trouble getting your spreadsheet to print properly? Our guide will show you how to change the setting for a spreadsheet so that all of the columns automatically fit on one page when you go to print your spreadsheet.

Matt Jacobs

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Primary Sidebar

Recent Posts

  • How to Show Contact Photos in Messages on an iPhone 11
  • How to Sign Out of Spotify on an iPhone
  • How to Flip a Picture in a Microsoft Word Document
  • How to Announce Messages with Siri on an iPhone 11
  • How to Clear Spotify Cache on an iPhone

Featured Posts

How to Skip a Slide in Google Slides

How to Add a Dollar Sign in Excel for Office 365

How to Insert a Page Break in the Google Docs iPhone App

How to Remove Borders from a Table in Microsoft Word for Office 365

how to print all columns on one page in excel 2013

How to Fit All Columns on One Page in Excel 2013

How to Disable Emotes in MTG Arena

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us

SupportYourTech.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Copyright © 2021 SupportYourTech.com