11

When looking at a numbered list that starts at the number 1, the row numbers are potentially confusing. (Assuming one has row 1 as column heading labels, item 1 will be on row 2, item 2 on row 3, and so on.)

Is there a way to turn off row and column headings, as there is in most spreadsheet programs?

In case I'm not making sense, the picture below should clear things up:

screenshot

7

No, it's not possible - see here. This sounds like a good feature request for Google Docs.

  • 2
    Still not possible in 2016 for anyone coming from a search. – Erik Humphrey Sep 14 '16 at 15:06
  • 2
    Still not possible in 2017 =D – Marcelo Bezerra Aug 21 '17 at 15:46
  • 3
    Still not in 2018! – Lokathor Jun 13 '18 at 22:42
  • 1
    Nov 2018. Still not possible :( – Saqib Ali Nov 6 '18 at 18:54
  • 1
    2019... still not possible :\ – chris_so Jan 26 at 8:42
1

Go to File > Publish to the Web, then under "Get a link to the published data" select "Web page", then the sheet you wish to publish. Then select the cells you wish to show. Then copy the generated link.

You may have to play with the sharing options (ie anyone with the link can edit).

  • That's a good suggestion....but perhaps needs a bit more facts. Can you show us a screenshot? – Jacob Jan Tuinstra Oct 10 '13 at 20:01
1

Yeah it's too bad Google aren't implementing this. I just put together a little JavaScript bookmarklet for this purpose here. Clicking once inserts a CSS style to hide the headers, clicking again removes the CSS and shows them again.

javascript:(function(){var hidecss = "body { margin-left: -45px; margin-top: -47px; } div.grid-table-container { width: 100% !important; } div.native-scrollbar.native-scrollbar-ltr.native-scrollbar-y { left: initial !important; right: 0px; } div.goog-inline-block.grid4-inner-container { width: 100% !important; }"; if (document.querySelector('#hidecss')===null){ var hidescript = document.createElement('style'); hidescript.type = 'text/css'; hidescript.id = 'hidecss'; hidescript.innerHTML = hidecss; document.head.appendChild(hidescript); } else document.getElementById('hidecss').remove();})();

May have to be tuned to other screen sizes but that's the gist of it !

Edit formatted JS:

var hidecss = "body { margin-left: -45px; margin-top: -47px; } div.grid-table-container { width: 100% !important; } div.native-scrollbar.native-scrollbar-ltr.native-scrollbar-y { left: initial !important; right: 0px; } div.goog-inline-block.grid4-inner-container { width: 100% !important; }";
if (document.querySelector('#hidecss')===null){
    var hidescript = document.createElement('style');
    hidescript.type = 'text/css';
    hidescript.id = 'hidecss';
    hidescript.innerHTML = hidecss;
    document.head.appendChild(hidescript);
}
else document.getElementById('hidecss').remove();

It's an ugly hack since Google doesn't make webapps that play well with user modification like this, so it's only visual (trying to click on cells brings you to different cells and the highlighting is messed up). I ended up not using it

  • Can you please reformat your code so that it is code (each line preceded by 4 spaces) rather than using backticks and blockquotes. I'd do it myself, but I can't work out where the linebreaks should go. – ChrisF Jul 2 '14 at 8:06
  • I just posted the bookmarklet code... the formatted CSS and JS is at the link if you want to see that – Louis Maddox Jul 2 '14 at 10:33
1

On the Google Sheets spreadsheet view is not possible.

One alternative is to publish to the web. It's worth to note that headers parameter could be used used to show/hide the headers. Use headers=true to show and headers=false to hide, if omitted the headers are hidden.

Example:

(The unique file id was replaced by ...)

https://docs.google.com/spreadsheets/d/e/.../pubhtml?headers=false

References

From the Google Docs Editors Official Help Forum

1

I added a blank column before my numbers and made my numbers BOLD so that my eyes are drawn there and not to the default google sheet numbers.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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