If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel using autofill on filtered cells

jimjangles · 2024-11-25 10:42:52

I'm not that experienced with Excel to be honest. What I've learned in a year of using it is it can be a pain to use and can do crap on you that you don't want it to do, so it annoys me and scares me what it can unintentionally do. For example using copy and paste on filtered cells copies and pastes from the cells that are…

25-11-2024 11:42AM

#1

jimjangles

Registered Users, Registered Users 2 Posts: 182

✭✭

Join Date: September 2018

Posts: 164

I'm not that experienced with Excel to be honest.
What I've learned in a year of using it is it can be a pain to use and can do crap on you that you don't want it to do, so it annoys me and scares me what it can unintentionally do. For example using copy and paste on filtered cells copies and pastes from the cells that are hidden and unfiltered and I've completely screwed up one Excel I was working on using that and had to redo it.
Anyway my question is can I use autofill on filtered cells or will that screw things up and copy data into hidden or unfiltered cells? Can I safely use autofill on filtered cells? By autofill I mean where you drag down to copy data from one cell into the cells below it.

0

Welcome!

It looks like you're new here. Sign in or register to get started.