make a page to have 100 lines only

J

j5b9721

is it possable to make a excel page only 100 lines??? How would it be done
using excel pro 2000?
 
S

Shane Devenshire

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.
 
A

Atishoo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Excel --> Word 4
Removing Line Numbers 4
Visio Utilizing 100% Memory - Troubleshooting 0
Unwanted line across top of pages; how to delete? 0
Margin from bottom edge of a page to the last line of the last paragraph 1
Mail merge labels 8 per page, but 84 is not divisible by 8 3
Have 4 email addresses Want to auto forward all in one of them 0

Top