0

We are displaying an excel sheet via excel web access web part on a sharepoint page. There is only 1 excel sheet containing 2 charts.

This appears like a normal excel doc with grid lines, 2 charts and tabs below for sheets. How do I remove the gridlines, row numbers, column headers, scroll bars and sheets tab from the excel web access webpart for better look?

  • Please don't post the same question more than once. Like grid lines, scroll bars, row and column headers are handled in Excel, as I explained in my answer below. – teylyn May 29 '15 at 7:57
  • duplicate here sharepoint.stackexchange.com/questions/144392/… – teylyn May 29 '15 at 7:58
  • @teylyn Thank you! I've merged these two questions into one. – Benny Skogberg May 29 '15 at 8:07
2

Best way is to make those charts as named Parts and then specify that name in Excel web access part . You should see only that Chart. Also in web part setting if you chose toolbar none, you wont see file tab or other excel function. It will be visible as plain Web chart and they wont know its actual excel file.

2

Use the Excel settings to hide the gridlines. Define a range that you want to display in web access web part and configure the web part to show that range only.

1

This has to be done in the actual Excel file.

Row and column headers are easy removed, to get rid of the scroll bars i think you have to use multiple sheet to keep the content size from generating a scroll bar, or if you can set the web part width and height in SharePoint so the whole sheet is visible and thus removing the scroll bar.

How to display or hide Row & Column Headers in Microsoft Excel?

Scroll bars in Excel services web part

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.