How to remove Multiple Hyperlinks from Openoffice Calc at Once

You have landed at the right article if you want to remove hyperlinks from open office from a field or multiple field at once. Here , i will tell you the fastest way with which you can remove hyperlink in OpenOffice.

How to remove a Single Hyperlink from a field in Openoffice Calc

1 – Do a right click on the particular hyperlink you wish to remove.



2 – From the context menu , just click on Default formatting

3 –  You have successfully removed the hyperlink.

Openoffice Calc Remove Hyperlink

How to remove Multiple Hyperlinks from a field in Openoffice Calc

Suppose you wish all hyperlinks from given columns at once. Here is how to do it.

1 – Do a right click on any hyperlink in that column.

2 – From the context menu , just click on Default formatting

3 – Now, select the required column , or press CTRL + A to select whole document at once (In case you want to remove hyperlinks from everywhere.)

4 – Finally Press CTRL+SHIFT+Y together.

Thats it. All the hyperlinks will be removed at once.

 



Remove All Hyperlinks At Once Openoffice Calc

 

Note: Actually Pressing CTRL + Shift + Y together actually does a Repeat: Reset attributes on the document.