Unable to insert column with correct formula inserted - I think!
I am trying to add a column in the left hand side of my accountancy pay in sheet and to the right hand side.
When i add columns on the right hand side all is ok, the formulas still work, but when i add columns on the left hand side they dont.
in the final column i have SUM(H4:Q4)-D4-G4 as an eample. So i would presume that if i added a column between D4-G4 it would work?
Welcome to the forum.
The best solution to this problem is to improve your working practices: don't insert columns to the left. Find a new way of presenting your data.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Good afternoon Ali, Many thanks for your quick and understandable response. I tried going to home and insert and it still inserted the column to the left and did not allow me to use the formula. I then went to the help section in excel and it told me how to put a column to the right and it did but the formula still does not work.
Is there anything else i should be doing please. Kind regards John
There are instructions at the top of the page explaining how to attach your sample workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks