Adjust the number of lines when pressing page down
 

How do I adjust the number of lines when pressing the page down key? Excel
2007 seems to default to 40 lines and I want to adjust it to 41 lines per
page down key stroke. I'm working with some 5-minute averaged data with 288
lines being one day of data. 7 page down key stokes puts me at 281 lines but
need to get to 288. Is there any way to make the adjustment? I've tried
changing the font and font size without any luck.

Appreciate any help or advice.

Adjust the number of lines when pressing page down
 

If I'm not mistaken, just select the entire sheet, then try reducing the row
height a little (experiment)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Caveman" wrote:
How do I adjust the number of lines when pressing the page down key? Excel
2007 seems to default to 40 lines and I want to adjust it to 41 lines per
page down key stroke. I'm working with some 5-minute averaged data with 288
lines being one day of data. 7 page down key stokes puts me at 281 lines but
need to get to 288. Is there any way to make the adjustment? I've tried
changing the font and font size without any luck.

Appreciate any help or advice.

Adjust the number of lines when pressing page down
 

Hi Max,

This does change the number of lines displayed on a page down key stroke.
Still experimenting on the size that hits the line number I need. Wish there
was a setting that would let you enter some number of lines to advance. I'll
work with it for a while and see if I get lucky.

"Max" wrote:

If I'm not mistaken, just select the entire sheet, then try reducing the row
height a little (experiment)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Caveman" wrote:
How do I adjust the number of lines when pressing the page down key? Excel
2007 seems to default to 40 lines and I want to adjust it to 41 lines per
page down key stroke. I'm working with some 5-minute averaged data with 288
lines being one day of data. 7 page down key stokes puts me at 281 lines but
need to get to 288. Is there any way to make the adjustment? I've tried
changing the font and font size without any luck.

Appreciate any help or advice.

Adjust the number of lines when pressing page down
 

You could also tinker with View Zoom (custom)
Adjust the percentages a little to, say: 95% ?

Pl click YES below if the response helped in any way
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Caveman" wrote:
Hi Max,

This does change the number of lines displayed on a page down key stroke.
Still experimenting on the size that hits the line number I need. Wish there
was a setting that would let you enter some number of lines to advance. I'll
work with it for a while and see if I get lucky.

Adjust the number of lines when pressing page down
 

I did try using the zoom feature yesterday without success. Tried all values
from 75% to 120% and it just would not come in were I needed it. It did
change the number of lines on a page down but well under or well over the 288
lines I needed. About the best I can do is press 7 page downs then press 7
more down arrow strokes to get to the line I need. Little bit of a pain as
I'm dealing with anywhere from 8064 to 8928 lines of data a month but guess
I'll have to get used to it. The 2003 version of Excel worked perfectly and
fortunately I still have that at the office so will probably just try and get
all of this editing completed at the lab.

Really appreciate the responses though, if you think of anything else would
appreciate a post.

"Max" wrote:

You could also tinker with View Zoom (custom)
Adjust the percentages a little to, say: 95% ?

Pl click YES below if the response helped in any way
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Caveman" wrote:
Hi Max,

This does change the number of lines displayed on a page down key stroke.
Still experimenting on the size that hits the line number I need. Wish there
was a setting that would let you enter some number of lines to advance. I'll
work with it for a while and see if I get lucky.

Adjust the number of lines when pressing page down
 

Welcome. Don't have anything further to offer you. Hang around awhile, maybe
other responders might pop by here with their views for you.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Caveman" wrote in message
...
I did try using the zoom feature yesterday without success. Tried all
values
from 75% to 120% and it just would not come in were I needed it. It did
change the number of lines on a page down but well under or well over the
288
lines I needed. About the best I can do is press 7 page downs then press
7
more down arrow strokes to get to the line I need. Little bit of a pain
as
I'm dealing with anywhere from 8064 to 8928 lines of data a month but
guess
I'll have to get used to it. The 2003 version of Excel worked perfectly
and
fortunately I still have that at the office so will probably just try and
get
all of this editing completed at the lab.

Really appreciate the responses though, if you think of anything else
would
appreciate a post.