Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Is there an easy way (i.e without programming & deploying a custom webpart) to remove the column/row headers in an Excel webpart view on a MOSS 2007 site? Customer sees:

     A      B      C      D
1   xxxx    xxx   xx     xxx
2    ---      -    -      --

Just wants the data, not the a,b,c,d,1,2,... default column/row headers. Can't find the option/group of options to do this in the Modify Shared Web Part display options.

share|improve this question

3 Answers 3

Simply go into the spreadsheet, select the area to be displayed, right click, and give the range a name. Then go into the web part, and type in the named range. Poof, no more column and row headers.

share|improve this answer

It's a kludge, but you could hide them with jQuery on the client side if all else fails.

share|improve this answer

I did this by hiding the rows and column indicators in the original (source) spreadsheet in Excel.

share|improve this answer

Your Answer

 
discard

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