• 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 / Where Did My Column Letters and Row Numbers Go in Excel for Office 365?

Where Did My Column Letters and Row Numbers Go in Excel for Office 365?

July 24, 2019 By Matt Jacobs

By default there is a row of letters at the top, and a column of numbers at the left side of your Excel spreadsheet. This information makes it easy for you to identify particular cells when either referencing the data to someone else or using a formula.

But if you’ve opened a spreadsheet in Excel for Office 365 and found that those column letters and row numbers are gone, then that could be a problem for your workflow. Fortunately this doesn’t mean that anything is wrong with Excel, but rather that someone has adjusted a setting in the application. Our guide below will show you how to return these column and row headings to view.

How to Show Column Letters and Row Numbers in Microsoft Excel

The steps in this article were performed in the desktop version of Microsoft Excel for Office 365, but will work in most other recent versions of Excel as well.

Step 1: Open the file in Microsoft Excel.

Step 2: Select the Page Layout tab at the top of the window.

click the Page Layout tab

Step 3: Click the box to the left of View under Headings to restore the column letters and row numbers.

how to restore column letters and row numbers in Excel

Have you opened a Microsoft Word file, only to find that there are gridlines there, too? Find out how to remove gridlines in Word if you don’t need them for your document.

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 Remove Signature from Gmail

how to bring a picture to the front in Google Slides

How to Bring an Image to the Front in Google Slides

Can I Remove the Email Signature on My iPhone 11?

how to save Google Docs as PDF

How to Save a Google Doc as a PDF

How to Enable Automatic App Updates on an iPhone 7

How to Repeat the File Name on Every Page in Excel for Office 365

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