ExcelBanter - how do I copy only visble cells in office10

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I copy only visble cells in office10 (https://www.excelbanter.com/excel-worksheet-functions/252519-how-do-i-copy-only-visble-cells-office10.html)

Tantalus24

how do I copy only visble cells in office10

i can't remember how this is done in this version

Eva

how do I copy only visble cells in office10

Click Go to then special and "visible cells only" and then CTRL+C (copy)

Click yes if helped
--

Greatly appreciated
Eva

"Tantalus24" wrote:

i can't remember how this is done in this version

RyGuy

how do I copy only visble cells in office10

Ctrl+g Special Visible Cells Only OK

"Eva" wrote:

Click Go to then special and "visible cells only" and then CTRL+C (copy)

Click yes if helped
--

Greatly appreciated
Eva

"Tantalus24" wrote:

i can't remember how this is done in this version

Ashish Mathur[_2_]

how do I copy only visble cells in office10

Hi,

Select the range and press Alt+; to select visible cells

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Tantalus24" wrote in message
...
i can't remember how this is done in this version

All times are GMT +1. The time now is 07:18 AM.