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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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: 172 ✭✭

Join Date: September 2018

Posts: 154

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