ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Scrolling in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/248614-scrolling-excel.html)

Bensum

Scrolling in Excel
 
Please help

My spreadsheet has a 'frozen' row at the top containing column headers, when
I scroll down through my rows below, excel scrolls down 3 rows at a time. Now
because my data in the rows below is in sections (1 section contains 5 rows)
sometimes I end up viewing 2 different sections (half of one and half of the
one below) at the same time.

Is there anyway you can instruct excel to only jump down so many lines when
you scroll down?

Many thanks
--
Bensum

Bob I

Scrolling in Excel
 
Change the mouse wheel settings in the Control Panel of the operating
system you use.

Bensum wrote:

Please help

My spreadsheet has a 'frozen' row at the top containing column headers, when
I scroll down through my rows below, excel scrolls down 3 rows at a time. Now
because my data in the rows below is in sections (1 section contains 5 rows)
sometimes I end up viewing 2 different sections (half of one and half of the
one below) at the same time.

Is there anyway you can instruct excel to only jump down so many lines when
you scroll down?

Many thanks



Luke M

Scrolling in Excel
 
Yes, but its not a property of XL. From the Windows Start menu - control
Panel - Mouse, Wheel tab, you can select how many lines you want to scroll.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bensum" wrote:

Please help

My spreadsheet has a 'frozen' row at the top containing column headers, when
I scroll down through my rows below, excel scrolls down 3 rows at a time. Now
because my data in the rows below is in sections (1 section contains 5 rows)
sometimes I end up viewing 2 different sections (half of one and half of the
one below) at the same time.

Is there anyway you can instruct excel to only jump down so many lines when
you scroll down?

Many thanks
--
Bensum



All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com