Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pressing TAB cursor moves a page to the right and not only 1 cell | Excel Discussion (Misc queries) | |||
how do i change the number of cells advanced when pressing tab | Excel Discussion (Misc queries) | |||
cannot adjust page breaks | Excel Discussion (Misc queries) | |||
How to adjust spacing between lines of wrapped text ? | Excel Discussion (Misc queries) | |||
Typed number is always divided by 100 after pressing enter | Excel Discussion (Misc queries) |