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.
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"
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.
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.
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
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
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
Copyright © 1997 - 2004, F. David McRitchie, All Rights Reserved