Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

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 10:42AM

#1

jimjangles

Registered Users, Registered Users 2 Posts: 227 ✭✭

Join Date: September 2018

Posts: 205

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