Ask Your Question
0

Where is the GoTo Special Equivalent in LibreOffice Calc?

asked 2017-10-30 03:38:43 +0200

DoctorFareswell gravatar image

Hi,

I'm new to LibreOffice and I'm trying to select all the blank cells in a column. In Excel this is accomplished by highlighting the column, hitting F5, choosing "GoTo Special" and then marking "blanks." I am having difficulty locating this in navigator. I'm sure it's quite simple and I am just overlooking it.

Thanks in advance for any help you can provide!

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2017-10-30 09:43:24 +0200

pierre-yves samyn gravatar image

Hi

AFAIK it is not possible with navigator.

What follows works in my environment (windows & Version: 5.4.2.2) but did not work in previous versions (I do not know from which version it was introduced).

  • Click the column header
  • Ctrl+H (or EditFind & Replace)
  • Find: ^$
  • Other options: tick Current selection only & Regular expressions
  • Find All

Note: The selection stops at the last filled cell, which seems normal (given the number of lines: 1048576)

HTH - Regards

edit flag offensive delete link more
0

answered 2017-10-30 10:47:54 +0200

You could try SpecialCells by Villeroy (here is possibly latest version) - don't know if it works with recent LO though.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-10-30 03:38:43 +0200

Seen: 1,199 times

Last updated: Oct 30 '17