Only Copy Visible Cells
Assume you have hidden a few rows or columns in a cell
range. Now you want to copy only the visible cells.
OpenOffice.org behaves differently depending on how you hid
the invisible cells and what you intend to do with them.
Method and Action
Cells were filtered by AutoFilters, standard filters or
advanced filters. Copythe visible cells using copy and paste
through the clipboard, or using the middle mouse button, or
by drag-and-drop while pressing the Ctrl key.
Result
Only the visible cells are copied.
Method and Action
Cells were filtered by AutoFilters, standard filters or
advanced filters. Movethe visible cells, using cut and paste
through the clipboard or by drag-and-drop without pressing
an additional key.
Result
All cells, including the hidden ones, are moved.
Method and Action
Cells were hidden using the Hide command in the context menu
of the row or column headers, or through an outline. Copy or
move the visible cells.
Result
All cells, including the hidden ones, are copied or moved.
tc
lindamurphy wrote:
Hello
This week I had the open office program installed to my work computer.
I have been unable to source how too:
Copy and paste - visable cells only.
Can anyone please provide me with this information?
Linda Mary Murphy
19 Oatberry Crescent
Shailer Park
Brisbane
Australia 4128
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]