Only Copy Visible Cells

Assume you have hidden a few rows in a cell range. Now you want to copy, delete, or format only the remaining visible rows.

LibreOffice behavior depends on how the cells were made invisible, by a filter or manually.

विधि व क्रिया	परिणाम
कक्षों को स्वतःफ़िल्टर, मानक फ़िल्टर तथा विस्तृत फ़िल्टर द्वारा फ़िल्टर किया जाता है Copy, delete, move, or format a selection of currently visible cells.	सिर्फ दिखाई देने वाले कक्षों के चयन ही नक़ल किए, मिटाए, खिसकाए व फ़ॉर्मेट किए जाएंगे.
Cells were hidden using the Hide command in the context menu of the row or column headers, or through an outline. Copy, delete, move, or format a selection of currently visible cells.	By default, all cells of the selection, including the hidden cells, are copied, deleted, moved, or formatted. Restrict the selection to visible rows choosing Edit - Select - Select Visible Rows Only or to visible columns choosing Edit - Select - Select Visible Columns Only.

विधि व क्रिया

परिणाम

कक्षों को स्वतःफ़िल्टर, मानक फ़िल्टर तथा विस्तृत फ़िल्टर द्वारा फ़िल्टर किया जाता है

Copy, delete, move, or format a selection of currently visible cells.

सिर्फ दिखाई देने वाले कक्षों के चयन ही नक़ल किए, मिटाए, खिसकाए व फ़ॉर्मेट किए जाएंगे.

Cells were hidden using the Hide command in the context menu of the row or column headers, or through an outline.

Copy, delete, move, or format a selection of currently visible cells.

By default, all cells of the selection, including the hidden cells, are copied, deleted, moved, or formatted. Restrict the selection to visible rows choosing Edit - Select - Select Visible Rows Only or to visible columns choosing Edit - Select - Select Visible Columns Only.

Applying Filters

Applying AutoFilter

Applying Advanced Filters