Multiple column scroll

[dmanlat]

I have researched for 2 days but cannot locate a solution. I have
spreadsheet where I have frozen the first 2 columns and the first tw
rows. To the right are columns of data in pairs. 2 columns represent
day and data is entered across both columns. We are having trouble wit
multiple users entering data across the wrong 2 columns and splittin
days. I want to be able to use the scroll bar and have the spreadshee
advance 2 columns instead of the standard 1 to keep the days in pairs.
am at a loss

 

[Living the Dream]

Just a thought

Have you considered color-coding each pair of columns, thus indicating
to the user that they represent the same grouping.

 

[GS]

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

 

[dmanlat]

Yes, I have thought if exactly that, color coding, as well as adding
small grayed-out column for separation. I even deleted the scroll ba
and set up the tab button to page across, which should work depending o
resolution settings. I think resolution can be controlled by commonizin
the tablets used for data entry. However, I am told there is a way t
set it up for the scroll bar to advance 2 columns instead of the defaul
1. I'm puzzled. I don't give up easily but I'm throwing in the towel
Thanks anyway!!!

;1611139']> I have researched for 2 days but cannot locate a solution.
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.discussio

 

[GS]

However, I am told there is a way to

set it up for the scroll bar to advance 2 columns instead of the
default
1. I'm puzzled.

Why not just ask whomever told you this to explain how to do it?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[dmanlat]

Ha! He only says he "knows" there is a solution, but he has no idea wha
it is.

;1611203']> However, I am told there is a way to-

set it up for the scroll bar to advance 2 columns instead of the
default
1. I'm puzzled.-

Why not just ask whomever told you this to explain how to do it?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussio