HOW DO I autofill when filtering...

  • Thread starter Thread starter sokevin
  • Start date Start date
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 :
 
You have to use copy/paste
Copy a cell
Select an area
Edit/Goto/special/visible cells
Past
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill defaults 4
Cannot use autofill after filtering 4
cannot use autofill after filtering 1
how can i use series autofill when I use autofilter? 1
Seat arrangement of students in Exam 1
Autofill column values in formulas 4
Macro to autofill from a specific row to a specific row 2
Question on Excel AutoFill command 1

Back
Top