SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
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?
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.
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.
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?
