reducing size of worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2967634%22%20slang%3D%22en-US%22%3Ereducing%20size%20of%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2967634%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CUL%20class%3D%22%22%3E%3CLI%3E%3CP%3EThe%20size%20of%20a%20scroll%20bar%20indicates%20the%20proportional%20amount%20of%20the%20used%20area%20of%20the%20sheet%20that%20is%20visible%20in%20the%20window.%3C%2FP%3E%3C%2FLI%3E%3CLI%3EMy%20scrollbar%20indicates%20I%20have%20very%20many%20more%20active%20columns%20on%20my%20worksheet%20than%20I%20am%20using.%26nbsp%3B%20This%20makes%20my%20scroll%20bar%20not%20useful%20for%20scrolling%20through%20the%20actual%20size%20of%20my%20worksheet%20(about%2020%20columns)%3C%2FLI%3E%3CLI%3EI%20have%20tried%20selecting%20all%20of%20the%20columns%20to%20the%20right%20that%20are%20not%20being%20used%20in%20my%20worksheet%20and%20deleting%20all%20of%20them%2C%20but%20this%20has%20not%20solved%20the%20problem.%3C%2FLI%3E%3CLI%3ESuggestions%20please%3F%3C%2FLI%3E%3C%2FUL%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2967634%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2968386%22%20slang%3D%22en-US%22%3ERe%3A%20reducing%20size%20of%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2968386%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1219448%22%20target%3D%22_blank%22%3E%40nokycard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMake%20sure%20that%20you%20delete%20the%20columns%20and%20not%20just%20the%20cell%20contents.%3C%2FP%3E%3CP%3EClose%20the%20workbook%20and%20save%20it.%3C%2FP%3E%3CP%3EOpen%20the%20workbook%20and%20it%20should%20be%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
  • The size of a scroll bar indicates the proportional amount of the used area of the sheet that is visible in the window.

  • My scrollbar indicates I have very many more active columns on my worksheet than I am using.  This makes my scroll bar not useful for scrolling through the actual size of my worksheet (about 20 columns)
  • I have tried selecting all of the columns to the right that are not being used in my worksheet and deleting all of them, but this has not solved the problem.
  • Suggestions please?
3 Replies

@nokycard 

Make sure that you delete the columns and not just the cell contents.

Close the workbook and save it.

Open the workbook and it should be fine.

 

 

Thanks for tip.  I thought I had already tried that, but guess I missed some step.

 

Was careful to follow your suggestion in detail, and it worked.  Thx again for your help.

 

@Detlef Lewin 

use ctrl+end to see where your end cell is, then delete any blank cells
2. Reduce conditional formatting (try to avoid it unless necessary)
3. reduce formulas (if you can use values)
4. if using pivot table , dont save a copy of your data with pivot table, as it is already stored in pivot cache