- Article Title: Extensions/Projects/CopyVisiCells
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. To use 'Copy only visible cells', do the following steps:
Select the cell range, and click Kutools Select Select Nonblank Cells. See screenshot: 2. Then the nonblank cells are selected, press Ctrl + C to copy them, then go to select a cell where you want to output the paseted result, press Ctrl + V to paste selected nonblank cells. How to copy only visible cells The first step is to select the data as usual. But DO NOT copy it yet. Type F5 or Ctrl G – which opens the Go To Special dialog.
- install the extension;
- restart LibreOffice;
- open your sheet with hidden rows or columns;
- select a range;
- insted the simple copy button, click on 'Copy only visible cells' button;
- paste in your target document, for example, another sheet or a RTF text table. The hidden rows or columns won´t paste.
Notes:
- it´s not possible paste especial with 'DDE Link' option in Writer;
Download
Credits
Developed by Gustavo Pacheco.
Special thanks: Andrew Pitonyak, Stephan Wunderlich, Ryan Nelson, Paolo Mantovani,Christian Junker and Comune di Bologna.
Translations:
English (en) - 'Copy only visible cells'
Portuguese - Brazil (pt-br) - 'Copiar somente as células visíveis'
Italian - Italia (it) - 'Copiare solo le celle visibili'
Spanish (es) - 'Copiar sólo las celdas visibles'
German (de) - 'Kopieren sichtbarer zellen'
French (fr) - 'Copier uniquement les cellules visibles'
New contributions:
'Kopiraj le vidne celice' - Martin Srebotnjak - Slovenian - Slovenia (sl)
'Копирай само видимите клетки' - Lyudmil Vasilev - Bulgarian - Bulgaria (bg)
'Kopiera endast synliga celler' - Johnny Rosenberg - Swedish - Sweden (sv)
'Kopier kun synlige celler' - Leif Lodahl - Danish - Denmark (da-dk)
'Kopeeri üksnes nähtavad lahtrid' - Mihkel Tõnnov - Estonian - Estonia (et)
How To Select And Copy Only Visible Cells In Excel
'Csak a látható cellák másolása' - Andras Timar - Hungarian - Hungary - (hu)
'Kopijuoti tik rodomus langelius' - Rimas Kudelis - Lithuanian - Lithuania - (lt)
How To Copy Data In Filtered Cells In Excel
'Copiar apenas as células visíveis' - Carlos Moreira - Portuguese - Portugal (pt)