SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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


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