Deleting existing text boxes in .xlsx

English
#1

Hi everyone,

I’m trying to use LibreOffice for the first time having been an MS Office Excel user (middle skill level) for a number of years. I’m trying to do my tax using a custom spreadsheet (in .xlsx format) from my accountant. The first thing I need to do is remove a standard text box that is taking up the entire screen and preventing me from properly being able to use the spreadsheet for all the columns/rows that sit behind the text box. In MS Office I just click the edge of the box and it selects it as a whole object and then just hit delete and problem solved. In Calc, however, it doesn’t seem to highlight the text box as an object for manipulating when I bring my mouse cursor anywhere on the box.

I’ve found no relevant guidance in the LibreOffice inbuilt help after searching for “delete a text box”, and amazingly I haven’t been able to find any useful guides in either a standard net search for “Delete a text box in Libreoffice Calc” or a youtube search! I’ve not been this frustrated in years. Can someone please explain how to delete an existing textbox in LibreOffice Calc!

Thanks in advance,

#2

Can someone please explain how to delete an existing textbox in LibreOffice Calc!

One try: Open the sidebar ( Ctrl+F5 ) and select the navigator there. In the navigator right-click on the name “Drawing objects” and then “Text frame n” and double-click and now press delete.

I’m trying to do my tax using a custom spreadsheet (in .xlsx format) from my accountant.

Are you switching to LibreOffice?
My Transition from MS-Office to LibreOffice

1 Like
#3

Thanks Hrbrgr. I did find this option early in my search to resolve the issue, but have only now tried the double click option as a means of bringing up the ‘delete’ dialogue box. When I cilck “ok” to delete it, however, it says the cells are protected, and so I’m unable to delete. I looked up how to “unprotect” cells but it demands a password which I don’t have. PS: Even though I double click the “Textbox 2” that relates to this pic, I note that the cell reference seems to be one of the normal cells within the spreadsheet that I don’t actually want to modify. When I double click “Text Box 2” a second and third time the text box does move around the screen to different positions though, so is this confirmation that it is indeed selecting the text box? This is so frustrating. Thanks in advance for your help thus far and any further so I can get this working. I honestly believe it will be smooth sailing once I can delete this text box!

#4

So you actually asked the wrong question here as you did know your answer. Your real question is to get rid of the password protection?
.
As your described how to remove the textbox in Excel, are you not asked for the password?

1 Like

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.