Copy Visible Cells In Microsoft Excel

Excel

< Extensions
  • 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.

  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;
  6. paste in your target document, for example, another sheet or a RTF text table. The hidden rows or columns won´t paste.

Notes:

  1. 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'

Copy


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)

Links

Copy Visible Cells In Microsoft Excel Formula

Retrieved from 'https://wiki.documentfoundation.org/index.php?title=Extensions/Projects/CopyVisiCells&oldid=161262'