Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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: enter image description here

share|improve this question
add comment

3 Answers

up vote 4 down vote accepted

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

share|improve this answer
add comment

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).

share|improve this answer
    
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
add comment

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

share|improve this answer
    
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 at 8:06
    
I just posted the bookmarklet code... the formatted CSS and JS is at the link if you want to see that –  lmmx Jul 2 at 10:33
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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