How do I remove all lines after say line 60?

[Jamer]

How do I remove all lines after say line 60?

I have created a spreadsheet with 12 tabs at the bottom for each month but I only need to go down as far as line 60. I have created a border around it and removed the continuous formatting for a few lines beneath that but the formatting seems to go on forever, I just want to end each tab at line 30 and have nothing after that on each tab? How do I do this please?

[AndyLitch]

1. Go to the bottom of the table on the worksheet
2. Select the row select of the first "empty" row................ That's the grey row header at the very left
The whole row should be selected
3. Press Shift-CTRL and down arrow
All rows below the table should be selected
4. Right click on any row header and select "Delete"
5. Repeat for all worksheets

[Jamer]

That's brilliant! Thank you so much. One other question how do I end my sheet at 60 lines? Because at the moment you can still scroll to infinity...

[TMS]

You can't delete the rows as such, they are always there. Deleting them just clears them.

What you can do is hide them. Follow Andy's instructions for selecting the rows then choose Format | hide or unhide | hide rows.


Regards, TMS

[Jamer]

You guy's make it sound so simple lol I will give it a go. Thanks so much for your advice it is appreciated.

[Jamer]

I have anther quick question, I have sums (averages) between the same cells on each of my 12 tabs I have set them up on the first tab but before I manually start adding them to all the other tabs is there a quick way to apply the same to all tabs?

[martindwilson]

right click sheet 1 tab,select all sheets
then any formula you now enter on sheet 1 will be repeated on all sheets, then right click and ungroup
if you have already put the formulas in
you can still select all sheets double click the cell with a formula in it and press enter then un group

[Jamer]

Wicked! Thanks you so so much

[TMS]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[Xx7]

this is the final output of hiding them...