Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
104
Views
Topic starter
Hi, I have a sheet with a column with the same sumif formula in all the cells. I want to amend a formula to be divided by 12 but when I do that it changes all the formulas in the column, how do I just change individual cells please?
Posted : 05/06/2020 10:48 am
Sounds like you have the data setup as a proper excel table
Purfleet
Posted : 05/06/2020 1:43 pm
Hi Sally,
As Purfleet says, sounds like you have the data in a table. When you change a formula in a cell this change is copied down the column.
You could change the table back to a range : from the Ribbon -> table Design -> Convert to Range but not sure why you have data in a table then?
Regards
Phil
Posted : 05/06/2020 7:09 pm
Topic starter
Thank you. That helps.
Kind regards,
Sally
Posted : 11/06/2020 1:20 pm
