| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
make a page to have 100 lines only
is it possable to make a excel page only 100 lines??? How would it be done
using excel pro 2000? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
make a page to have 100 lines only
Hi,
You can select row number 101 and press Shift+Ctrl+Down Arrow, then right click any of the selected row numbers and choose Hide. You really aren't making the page only have 100 lines but it behaves that way. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "j5b9721" wrote: is it possable to make a excel page only 100 lines??? How would it be done using excel pro 2000? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
make a page to have 100 lines only
You could set a scroll area so you cant work outside the first 100 lines.
Worksheets(1).ScrollArea = "A1:Z100" use as a workbook open event. "Shane Devenshire" wrote: Hi, You can select row number 101 and press Shift+Ctrl+Down Arrow, then right click any of the selected row numbers and choose Hide. You really aren't making the page only have 100 lines but it behaves that way. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "j5b9721" wrote: is it possable to make a excel page only 100 lines??? How would it be done using excel pro 2000? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make all "lines" in my row print on the same page? | Excel Discussion (Misc queries) | |||
| How to make 5 first lines to reoccur on every page when printing? | Setting up and Configuration of Excel | |||
| How to take a cell that has 3 values and make 2 more new lines | Excel Worksheet Functions | |||
| How do I make two lines in one cell? | Excel Discussion (Misc queries) | |||
| How do I make the lines "smooth" in my 3-d pie chart? | Charts and Charting in Excel | |||
Hybrid Mode
