How to Hide a Spreadsheet Column in LibreOffice Calc Software & Sites 06 APR 2012

Seeing as Ubuntu ships with LibreOffice (forked from OpenOffice) as its default office suite these days, I guess I should try and get a little more familiar with its various time-saving tips and tricks, like this one noted here today.

(And If you don’t know what I’m talking about, then: “LibreOffice is the power-packed free, libre and open source personal productivity suite for Windows, Macintosh and GNU/Linux, that gives you six feature-rich applications for all your document production and data processing needs: Writer, Calc, Impress, Draw, Math and Base.”)

Anyway, Calc is LibreOffice’s spreadsheet application (similar to Microsoft Office’s Excel), and today’s handy little user interface tip shows us how to quickly and efficiently hide unwanted columns which you still want present, but just not visible in order to save on screen real estate.

To hide a column, grab with your mouse pointer the targeted column’s right hand edge, and begin resizing it like you normally would. In this case you want to shrink it, so in other words, drag towards the left. If you stop and release the mouse button before reaching the column’s left hand edge, the column will be shrunk to a smaller width.

And here is where it gets fun. Keep on resizing until you drag the right hand edge past the left hand edge! Releasing the mouse at this point will result in the column instantly hiding itself!

Which of course is pretty nifty! :)

Related Posts:

About Craig Lotter

Software developer, husband and dad to two little girls. Writer behind An Exploring South African. I don't have time for myself any more.