Scroll Bar Usage in Excel

Location: http://www.mvps.org/dmcritchie/excel/scrollbar.htm Home page: http://www.mvps.org/dmcritchie/excel/excel.htm [View without Frames]

You can't hold mouse on scroll bar and scroll down and see the content pass through while you do that as in Word. If you do that in Excel all you see change is the Row number change until you release the button. In Excel use the scroll arrows to see what you are scrolling through.

To scroll faster and perhaps with a bit more control, hold the SHIFT key which will make the scroller smaller and pertain to the entire sheet rather than the used area.

You can move the cursor to the position you want it to end up at and hold down the left button. The scroll bar will quickly move toward the cursor and stop there. Approximately what you asked for but again there is no control on the speed.

Wheel Mouse:
You can configure the mouse wheel to scroll one full screen at a time. This setting is located in the Control Panel, Mouse, Wheel tab, on the first option "Turn on the wheel" click on [Settings] and choose "scroll one 'screen' at a time". More information on the mouse usage and on Mouse Wheel and Button Settings for various applications (text page) can be found on other pages.

This is really the same as placing the cursor anywhere above or below the scroll bar to move up or down one page at a time by clicking on the left mouse button.

Slow or Fast hands off scrolling: (panning)
With the wheel mouse you can also push down on the wheel button and them move the mouse slightly down do scroll slowly down or move further away to scroll faster, turn off by pressing wheel again.

More information in HELP on some of the above
HELP --> ans. wiz. --> scrolling --> Scroll and Zoom

"Scroll and zoom on a Microsoft Excel sheet by using the Microsoft IntelliMouse pointing device"

Missing scrollbar (#missing)

Tool Options, View, Horizontal and Vertical options.

Size of Scrollbar (#size)

The size of the scrollbar, and of the sheet tabs is determined by the size of the scrollbars, which is set in
Control Panel, Display, Appearance (tab), item: Scrollbar (mine is 16).

Shift Key used with ScrollBars (#shiftscroll)

Hold the shift key down when scrolling to speed up scrolling. This will make the scroller smaller. The size of the scroller is normally despendent on the the number of used rows. If you don't have much data and have a small scroller, it is an indication of of your lastcell (Ctrl+End) incorrectly set. To fix last cell problems see particularly Reset_lastcell and MakeLastCell macros. More information on Scrollbars.

The following applies to my system: Excel 2000 running on Windows 2000.

Don't know if you can control the font type for the worksheet tabs
Item: "scrollbar" controls size of font and scrollbar (Mine is 16). Applies to worksheet tab fonts for both active and inactive worksheet tabs.
Item: "Message Box" controls color for the active worksheet tab, name box, formula entry area, along with text in notepad, emails, filename on your desktop icons, etc. etc. (Tahoma, 8, Black). Does not control other font information in Excel (font type, font size).
Item: "3D Objects", Upper color is the background for inactive sheettabs.
lower color (font) controls The color of the inactive worksheet tabs and also controls color of your email, filename on your desktop icons, color of area where scrollbar is not active, etc, etc.

Toggle Scrollbars on and off (#toggle)

The following macro will toggle between hiding and unhiding sheet tabs, vertical and horizontal scrollbars. This is not something I would do but it came up in a request (2006-02-20, setup).
Sub Macro23_toggle()
    With ActiveWindow
      If .DisplayHorizontalScrollBar = True  AND _
             worksheet.count > 1 then
        .DisplayHorizontalScrollBar = False
        .DisplayVerticalScrollBar = False
        .DisplayWorkbookTabs = False
      Else
        .DisplayHorizontalScrollBar = True
        .DisplayVerticalScrollBar = True
        .DisplayWorkbookTabs = True
      End If
    End With
End Sub

Scrolling Problems in the VBE (#vbe)

If you have Intellipoint mouse driver check the advance tab, and remove Visual Basic and Internet Explorer from the exceptions. Other possibilities follow:
Any Visual Basic Users Having Mouse Scrolling Problems?, Chip Pearson, 2004-04-26, You need to use Version 4 of the Intellimouse drivers (the latest is version 5).
VBScroll, Gasanov.net (Shahin Gasanov), VBScroll solves the problem with mouse wheel scrolling in Visual Basic IDE and VBA editor in Microsoft Office applications such as Word, Excel and etc. Microsoft IntelliPoint 4.12 (not newer versions) mouse driver does the same, but in some situations it's impossible to install or use
FreeWheel, FreeWheel supports the 'default' mode of operation, where rotating the wheel causes the active (focus) window to scroll, and an alternative mode where the window (within the foreground application) directly underneath the mouse pointer is scrolled

Scrollarea based on a range (#scrollarea)

This will toggle between range1 as scroll area and removing the scroll area limitations on mouse, arrow keys, scrolling, etc. You can use something like "B5:G10" instead of a named range.
Private Sub Worksheet_BeforeRightClick(ByVal Target _
           As Range, Cancel As Boolean)
   Cancel = True
   If ActiveSheet.ScrollArea = "" Then
      ActiveSheet.ScrollArea = "range1"    
   Else
      ActiveSheet.ScrollArea = ""
   End If
End Sub

Mouse Problems (#mouse)

This Section has been moved to Fill Handle & Mouse page.

sorting worksheet tabs, see buildtoc.htm and buildtoc2.htm
Why do my scrollbars go to row 500 -- my data ends in cell E50?, contextures.com, Debra Dalgleish [also see my lastcell page.]

You are one of many distinguished visitors who have visited my site here or in a previous location since this page was created on August 03, 2000. Return to TOP.

Visit [my Excel home page] [Index page] [Excel Onsite Search] [top of this page]

Please send your comments concerning this web page to: David McRitchie send email comments