How do I truly delete rows and columns, like in Google Sheets?

edit

When you right-click the row header you get a menu that gives you some options :

** Delete Selected Rows

** Delete Row Contents

Each command does as it says .

Same thing with the columns .

Addition to my answer

After reading your comments :

1) Check this image . Is that what you are looking for ?

2) To do this , you have to select the rows and hide them ,

and then select the columns and hide them .

3) Selecting rows 9 till end of file is done like karolus wrote :

selecting header of row 9 , then pressing shift+ctrl+end+arrow down .

4) In selecting columns , you press shift+ctrl+end+arrow left .

5) All the information in the hidden cells still exists there ,

and you don't get smaller size files just because you don't exhibit some cells .

6) What possessed you to think that someone didn't bother to read your question before answering it ?

My English is as bad as your English !

YES IT DELETEs THE ENTIRE ROW|COLUMN[S] but obviously the next Row|Column[s] below|right will move up|left, as everybody except you will expect.

Propably, YOU want to hide the Row|Columns[s]

IMO, the functionality of a cloud based spreadsheet is different than a spreadsheet program that runs on a computer. With Google Spreadsheets, the rows are deleted and appear to be (and probably are) removed from the spreadsheet. I would guess this means less data needs to be transferred from the server to your browser. Perhaps even blank rows/columns have some information, or perhaps ARE the information to be transmitted.

With LO on your computer, the file size isn't affected with one million empty rows.

In Excel online in an empty spreadsheet, as I page down there is a “WORKING” displayed in the bottom left of the window. So it must be transferring data even with empty rows.

As for LO, I concur with the other two answers, right clicking on the header for the row/column, delete row/column, deletes everything in the row/column including the formatting and the contents.