ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel thinks blank columns have data? (https://www.excelbanter.com/excel-discussion-misc-queries/143085-excel-thinks-blank-columns-have-data.html)

Mark Brown

Excel thinks blank columns have data?
 
Hi,

I just pasted a fairly large web page with several images into an Excel
sheet, and though it only stretches from columns A through R and rows 1
through 118, my scroll bars seem to think there's data in all the empty space
off to the right and at the bottom. I have miniscule little "scrollers"
that, when taken to the far end, take me to column XFD, row 1048464.

How can I make my scrollers go back to their usual inch-or-so size and end
where the data actually ends?

Thanks,
Mark

Mark Brown[_2_]

Excel thinks blank columns have data?
 
Nevermind, I fixed it! Turns out it was a couple pie charts that I'd pasted
in - for some reason, even though they were the small size they should be,
Excel seemed to think they were the maximum size of the sheet. I just
deleted them and my scroll bars went back to normal.

"Mark Brown" wrote:

Hi,

I just pasted a fairly large web page with several images into an Excel
sheet, and though it only stretches from columns A through R and rows 1
through 118, my scroll bars seem to think there's data in all the empty space
off to the right and at the bottom. I have miniscule little "scrollers"
that, when taken to the far end, take me to column XFD, row 1048464.

How can I make my scrollers go back to their usual inch-or-so size and end
where the data actually ends?

Thanks,
Mark



All times are GMT +1. The time now is 06:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com