I have been handed over an excel spreadsheet that is used to keep track of the employee point system at work. I have taken off all the old dates we no longer need to have on the system but now I have stuff everywhere. Long story short I was wondering if there was a to shift the cells over without having to retype all the data and will not mess up the existing formulas that are in the spreadsheet. Below may help you better understand what I am talking about.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Shifting cells over without messing up formulas
- Thread starter gruff
- Start date
Jeffrey Mahoney
Well-known Member
- Joined
- May 31, 2015
- Messages
- 2,825
- Office Version
- 365
- Platform
- Windows
When you say "Shift the cells over", do mean moving cell contents from one column to another?
How are you forming your formula? It looks like this is an Excel Table. Using the table reference instead of the traditional R1C1 reference should help. Meaning, when you create a formula on table data, Excel uses column headers instead of cell names. =[@[Date 1]]+[@Days] instead of =A1+C1.
How are you forming your formula? It looks like this is an Excel Table. Using the table reference instead of the traditional R1C1 reference should help. Meaning, when you create a formula on table data, Excel uses column headers instead of cell names. =[@[Date 1]]+[@Days] instead of =A1+C1.
Upvote
0
Similar threads
