Page Down

[cleo]

Excel 2003 - I have a spreadsheet that is divided so that I have one employee
schedule per page (not per sheet). I have used page break to split the pages
up.

Some of the schedules are shorter than a computer screen and some are
longer. When I am looking through the schedules, I usually want to be able to
pop to the next employee without using my scroll or cursor.

Is there a way to just move down one page at a time instead of one computer
window at a time?

Thank you in advance.

 

[excelent]

Select Upper Left cells of emploe.1's page
In namebox type Page.1 + Enter
Select Upper Left cells of emploe.2's page
In namebox type Page.1 + Enter
and so on for all emploee's

Now u can select with dropdown arrow just to the right of namebox whis page
u wana go to

if u vant page to scroll, insert this kode in the sheet module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column > 1 Then Exit Sub
On Error GoTo ud
x = ActiveCell.Name
Application.Goto ActiveCell, True
ud:
End Sub



"cleo" skrev:

 

[excelent]

this is better 1,2,3,4 and so on

Select Upper Left cells of emploe.1's page
In namebox type Page.1 + Enter
Select Upper Left cells of emploe.2's page
In namebox type Page.2 + Enter
and so on for all emploee's

"excelent" skrev:

 

[Gord Dibben]

Instead of a pagebreak, how about leave a blank row between the sections?

CTRL + downarrow will take you to the next blank row.


Gord Dibben MS Excel MVP

 

[cleo]

Thank you both. I'll give these a try.

Instead of a pagebreak, how about leave a blank row between the sections?

CTRL + downarrow will take you to the next blank row.


Gord Dibben MS Excel MVP