D
David Shanks
I have several very large spreadsheets that get used
throughout the year. I do payroll and have to track a lot
of different things for our company and modify/add data as
new payrolls are processed. When the new year arrives I
just do a save as on the previous years file and change
the name to reflect the new year the delete the old years
data and start fresh. My question is, how can I reset the
scroll bar on the side of the worksheet. As you can
imagine the data is much smaller at the beginning of the
year than at the end and the scroll button is small
(reflecting the old data size) so I have to basically hunt
for the end of the data with the scroll button when I want
to sort/subtotal things.
thanks
Dave
throughout the year. I do payroll and have to track a lot
of different things for our company and modify/add data as
new payrolls are processed. When the new year arrives I
just do a save as on the previous years file and change
the name to reflect the new year the delete the old years
data and start fresh. My question is, how can I reset the
scroll bar on the side of the worksheet. As you can
imagine the data is much smaller at the beginning of the
year than at the end and the scroll button is small
(reflecting the old data size) so I have to basically hunt
for the end of the data with the scroll button when I want
to sort/subtotal things.
thanks
Dave