+ Reply to Thread
Results 1 to 6 of 6

Make scroll bar end at the last column of data

  1. #1
    Registered User
    Join Date
    08-26-2019
    Location
    Arizona
    MS-Off Ver
    2016
    Posts
    3

    Make scroll bar end at the last column of data

    My current spreadsheet ends at column BJ. When I use the scroll bar at the bottom of the spreadsheet and drag it to the right, it will scroll past BJ to DJ, (an extra 53 columns of unused blank columns). How can I eliminate the extra columns so that the scroll bar ends at BJ?

    I tried using the Find & Select/Go to Special/Blanks and trying to delete them, to no avail. Got a better idea?

  2. #2
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Make scroll bar end at the last column of data

    Usually when that happens, something was typed into those columns at some point and Excel remembers it. if you select the last empty column, the whole column, then press CTRL+SHIFT+Right Arrow, it will select every column to the right of your data. Right click on any of the letters on the top and select Delete. Now when you save the file and reopen it, Excel should forget that data was ever over there.
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.

  3. #3
    Registered User
    Join Date
    08-26-2019
    Location
    Arizona
    MS-Off Ver
    2016
    Posts
    3

    Re: Make scroll bar end at the last column of data

    Thanks so much for your reply!
    Following your steps, the additional columns still remain. I saved the changes, exited the file and returned, only to find the same problem.
    Any suggestions?

  4. #4
    Valued Forum Contributor
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    446

    Re: Make scroll bar end at the last column of data

    I usually use the Workbook_Open event to keep screen area under control.
    As per example.
    torachan.
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-02-2019
    Location
    Warsaw, Poland
    MS-Off Ver
    7
    Posts
    15

    Re: Make scroll bar end at the last column of data

    I would simply hide unused blank columns and your problem is solved. :-)

  6. #6
    Valued Forum Contributor
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    446

    Re: Make scroll bar end at the last column of data

    Setting the sheet size stops the right & down scroll arrows going past the viewable sheet limit.
    The sheet can be taken beyond the viewable limits if only hidden.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1