+ Reply to Thread
Results 1 to 5 of 5

Reason for Extremely Tiny Bottom Horizontal Scroll Bar With Nothing Past Column AG

  1. #1
    Forum Contributor
    Join Date
    06-08-2008
    Location
    USA
    MS-Off Ver
    Mac Excel 2016
    Posts
    103

    Reason for Extremely Tiny Bottom Horizontal Scroll Bar With Nothing Past Column AG

    I know this is super general and not very helpful without specifics -- but I'm hoping somebody could let me know some general reasons why something like this might occur so I don't have to go through and remove all the sensitive information in the spreadsheet to post here.

    Basically, my workbook has a sheet where (just like all the other sheets within the workbook) the column data doesn't extend past AG (and nothing past row 336) -- but for some reason the bottom horizontal scrollbar is super small so I can scroll very quickly to the final column (XFD) very quickly. But since there's no data past AG, I would like for the horizontal scroll to incorporate that -- because when I send this report out to much less tech-savvy people, I want to make sure they don't have a difficult time scrolling left-and-right to see all the data (don't want to give them any excuse to not look at this).

    Some things about this spreadsheet:
    • It has multiple sheets (no others with similar data are having this problem);
    • I use conditional formatting on a lot of it (but none go beyond Column AG);
    • I also use subtotals for a lot, if that helps; and
    • I've highlighted everything from Column AH to the right and tried "Clear >> All," but it did nothing.

    Looks like this:
    Screenshot_2_18_15__6_02_PM.jpg

    All others look like this:
    Screenshot_2_18_15__6_04_PM.jpg

    Hope that was enough for some ideas! Thanks for the help.

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Reason for Extremely Tiny Bottom Horizontal Scroll Bar With Nothing Past Column AG

    Sorry - couldn't resist, but glad I actually opened this thread so that I could see the thread title in full!

    I use Google Chrome at 150% zoom a lot of the time, and I nearly spilled my beer when I saw your thread on the forum New Posts page!

    Apologies! Anyway, if you can post an actual workbook then I'm sure we'll be able to help.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: Reason for Extremely Tiny Bottom Horizontal Scroll Bar With Nothing Past Column AG

    Instead of using Clear All, press the Delete icon on the ribbon. Good idea to save, and possibly close the workbook, and then re-open it.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Contributor
    Join Date
    06-08-2008
    Location
    USA
    MS-Off Ver
    Mac Excel 2016
    Posts
    103

    Re: Reason for Extremely Tiny Bottom Horizontal Scroll Bar With Nothing Past Column AG

    Thank you!

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: Reason for Extremely Tiny Bottom Horizontal Scroll Bar With Nothing Past Column AG

    You're welcome. Thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel horizontal scroll column sticking
    By refuelled in forum Excel General
    Replies: 1
    Last Post: 11-06-2013, 09:12 AM
  2. Replies: 5
    Last Post: 02-21-2013, 02:41 PM
  3. [SOLVED] Can't scroll down past row 260, or past column Y in Excel 2003....
    By damianberry in forum Excel General
    Replies: 2
    Last Post: 12-11-2012, 01:00 AM
  4. [SOLVED] Cannot scroll up past a certain row
    By C- in forum Excel General
    Replies: 3
    Last Post: 03-23-2005, 04:06 PM
  5. TINY TINY SMALL FONT IN Excel tabs
    By CIA in forum Excel General
    Replies: 0
    Last Post: 03-16-2005, 03:50 PM

Tags for this Thread

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