make a page to have 100 lines only

  • Thread starter Thread starter j5b9721
  • Start date Start date
J

j5b9721

is it possable to make a excel page only 100 lines??? How would it be done
using excel pro 2000?
 
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.
 
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

how can i disable save i need save as only 3
macros randbetween formulas 4
converting line-delimited text into cells 2
I am trying to put two Rows together 1
Lookup problem in Excel 2003 1
Pasted Text Won't Fill Page - Please Help 2
Using header on first page only 2
Excel Moving data from one line to another 0

Back
Top