Or, how do I get rid of the column labels altogether?

My table has nothing at all to do with the ABC's. I want it to look professional and not have column names. How do I delete them?

  • Related: Rename Column in Google Spreadsheets
    – ale
    Commented Oct 3, 2016 at 15:55
  • 1
    Need more input. Look professional where? When it's printed, published to web, etc. How/where is the spreadsheet being viewed.
    – Damainman
    Commented Jul 6, 2017 at 22:22

2 Answers 2


There is no way to do this. When you print your spreadsheet, the column and row labels won't show. But on-screen, they will.

If a spreadsheet is what you need, then just type in your own headings in the top row of a table, and format them in bold - maybe use shading or a larger font too.

Alternatively, if a different look is extremely important, maybe you should use a Document instead of a Spreadsheet.


To keep your header row visible as you scroll through your spreadsheet do the following...

Go to the View menu. (view) Then, point your mouse to Freeze rows… or Freeze columns…. (freeze) Select one of the options. When you scroll, you'll notice the frozen row(s) or column(s). (1 row)

  • 1
    Welcome. This post isn't answering the question as it's not about keeping the header row visible, it's about using a custom column IDs instead of letters (A, B, C, and so on). Commented Oct 10, 2018 at 22:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.