HOW DO I autofill when filtering...

S

sokevin

Hi, when i do autofilter.

i want to autofill only does cells that are visible.

however when i autofill, it also fills in the filtered cells.

thanks :
 
B

BrianB

You have to use copy/paste
Copy a cell
Select an area
Edit/Goto/special/visible cells
Past
 
G

Gord Dibben

sokevin

After you have your autofilter on, Edit>Go To>Special>
"Visible cells only".

With these cells selected try your Autofill.

Gord Dibben Excel MVP
 
Top