Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Basically what I'm trying to do is load my excel spreadsheet into SharePoint without having the scroll bars. (I have disabled the scroll bars in excel itself, but thanks to the un-used space, they are still there.

I have set the print area and tried to 'delete' the remaining white cells around it, but when I save it, the extra white cells in the page show up. Any suggestions?

share|improve this question
add comment

2 Answers

I don't have a SharePoint here to test, but try hiding all the rows and columns that are blank.

To hide rows (similar to columns) : -Select all the rows from the first one blank. -Right click on the selection (on the title of it) -click Hide.

More info on hiding and unhiding: http://spreadsheets.about.com/od/excelformatting/qt/070814_hide.htm http://www.accountingweb.com/topic/technology/tricks-hiding-and-unhiding-excel-rows-and-columns

share|improve this answer
    
Thanks! How do you hide them? –  cait Oct 17 '12 at 15:09
add comment

I guess your goal is to hide scroll in SharePoint that's related to the Excel Web Access Web Part.

If you want to correct this:

  1. In the web part properties you can set the size of the web part (in pixels or percent).
  2. You can set the number of rows and number of columns that you want to load and show every time you scroll.
share|improve this answer
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.