i cant reduce the size of the active workbook

bigdan

Well-known Member
Joined
Oct 5, 2009
Messages
822
Office Version
  1. 2013
Platform
  1. Windows
With this one workbook I'm using I'm having trouble with various tabs here. The active range is all the way until AZ1048576 and I just cant seem to change that. I've tried deleting a few thousand rows at the bottom but it's just not changing. As a result this one file which only has data until row 10,000, has a size of 80 MB!!

Can anyone explain how to fix this?


In another tab in the workbook the scrollbar takes up the entire area from top to bottom (i dont know proper terminology here. essentially what I'm saying is, when I want to scroll down in most normal workbooks, I goto the bar in the top right, and drag lower down to where I want to go. in this case there's just one long bar so I cant drag it down). How would I fix that?
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Radoslaw Poprawski

Active Member
Joined
Jun 19, 2021
Messages
326
Office Version
  1. 365
Platform
  1. Windows
im not quite sure what ur asking.
usually the right side bar and horizontal ones are as big as you data set.
if you need to go beyond that use page down to well, go down
or the right arrow to go, well right, or don't drag the bar, but click the arrow from the bar
 

Forum statistics

Threads
1,148,367
Messages
5,746,283
Members
424,006
Latest member
Metal_warrior

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top