![]() |
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 |
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