Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have researched for 2 days but cannot locate a solution. I have a
spreadsheet where I have frozen the first 2 columns and the first two rows. To the right are columns of data in pairs. 2 columns represent 1 day and data is entered across both columns. We are having trouble with multiple users entering data across the wrong 2 columns and splitting days. I want to be able to use the scroll bar and have the spreadsheet advance 2 columns instead of the standard 1 to keep the days in pairs. I am at a loss. You can scroll left/right one screen at a time using PgUp/PgDn while holding down the *Alt* key. (PgUp=left; PgDn=right) -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Link Scroll Bar to multiple cells | Excel Worksheet Functions | |||
One column stays while others scroll | Excel Discussion (Misc queries) | |||
can I fix 1 column & scroll across others? | Excel Discussion (Misc queries) | |||
Scroll locked in multiple worksheets | Excel Programming | |||
Scroll thru multiple spreadsheets | Excel Programming |