Ending a Sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Is there a way to end an excel sheet? For example, end it at row 100?

Thanks!
 
you can hide all the rows below it

click on row 101 (to the left, where it will select the entire row)
hit
Ctrl+Shift+down arrow
will highlight all rows down to row 65536
right click somewhere in the black part (where the numbers are) of the
highlighted rows and choose "hide".
:)
susan
 
If it's for printing purposes you can change the page break to stop at row
100 and it would only print rows 1 --100.
 
You must log in or register to reply here.

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

add hyperlink using sheet names and cells(i,j) 3
Array 1
move worksheet to end of another workbook 3
Excel Macro to copy a row to another sheet based on date 0
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Match and delete rows on two different sheets from reference numbers 4
Sumproduct Question Working With Start and End Date Range 1
Delete 3 end row 6

Back
Top