Question Locked

Excel Formula that doesn't repeat when you use drag and fill

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'd like to create a formula for a spreadsheet and populate all the line items without having the formula repeat over and over. Someone did it in one of their spreadsheets but would not share how he did it.

Thanks,
Susan

2 replies

by locolobo

Do you want to copy the value the formula returns? If you want to do that you can use "Copy" then "Paste Special".

Do you want the auto fill to not increment references? Just use "Copy" then "Paste".

Or did you want to turn it off? Go to "Tools" - "Options" - "Edit", then deselect "Allow Cell Drag & Drop".

This discussion is closed to new replies.