Ask Your Question

How do I delete rows or columns? [closed]

asked 2015-01-18 05:16:56 +0200

Milliways gravatar image

If I select a number of items (as I do in Excel) LibreOffice only wants to delete these cells. I would prefer some solution that I can put on a toolbar which I currently do in Excel.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-15 00:15:35.113669

1 Answer

Sort by » oldest newest most voted

answered 2015-01-18 07:23:26 +0200

RonJohn63 gravatar image

To delete a column in Calc, click on the column letter, and then right-click so that the pop-up menu appears. About half-way down is "Delete Selected Columns". To delete multiple columns, click-and-drag in the column letter "area" so as to select multiple columns. Then right-click as before.

Same to delete rows, except you click on the row numbers.

edit flag offensive delete link more


Additional to the above answer, you can add icons to the "formatting toolbar" to be able to add or delete row or columns. From Tools - Customize - Toolbars - Formatting, you can add the commands you need.

ratrace gravatar imageratrace ( 2015-01-18 10:54:16 +0200 )edit

Question Tools

1 follower


Asked: 2015-01-18 05:16:56 +0200

Seen: 9,750 times

Last updated: Jan 18 '15