Skip to content. | Skip to navigation

Personal tools


You are here: Home / Extensions / Copy only visible cells

Copy only visible cells

This extension provides an alternative to the 'Select Visible Cells' command in Microsoft Excel. It´s useful to use with subtotals or ranges with hidden columns or rows.

Project Description

To use Copy only visible cells, do the following steps:

1. install the extension;

2. restart LibreOffice;

3. open your sheet with hidden rows or columns;

4. select a range;

5. insted the simple copy button, click on Copy only visible cells button (or Edit -> Copy only visible cells menu);

6. paste in your target document, for example, another sheet or a RTF text table.

The hidden rows or columns won´t paste.

Note: it´s not possible paste especial with 'DDE Link' option in Writer.

Available on 16 languages: Bulgarian, Catalan, Danish, Dutch, English (default language), Estonian, French, German, Hungarian, Italian, Lithuanian, Portuguese (Brazil), Portuguese (Portugal), Slovenian, Spanish and Swedish. Special thanks: Andrew Pitonyak, Stephan Wunderlich, Ryan Nelson, Sheila Tozatti, Paolo Mantovani, Christian Junker and Comune di Bologna.

Current Release
Copy only visible cells 1.2

Released Sep 01, 2016 — tested with LibreOffice 5.0, LibreOffice 5.1, LibreOffice 5.2

Added 5.x compatibility.
More about this release…

Download file Get Copy only visible cells for All platforms
If you don't know, how to install an extension in LibreOffice, see our howto about installing extension for detailed instructions.

All Releases

Version Released Description Compatibility Licenses Status
1.2 Sep 01, 2016 Added 5.x compatibility. More about this release…
LibreOffice 5.0
LibreOffice 5.1
LibreOffice 5.2
LGPL-v3+ final
1.1 Mar 07, 2014 Big ranges copy bug fixed. More about this release…
LibreOffice 4.1
LibreOffice 4.2
LGPL-v3+ final
1.0.5 Nov 18, 2011 New Catalan and Dutch translations. More about this release…
LibreOffice 3.3
LibreOffice 3.4
LGPL-v2.1 final

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Legal Disclaimers and Limitations | Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0. License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License v2.0.

"LibreOffice" and "The Document Foundation" are registered trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.