Related Posts
I am on bench from 1 nov 2022. I am PA.
Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.





Ctrl+C, then in sequence press ALT, E, S, F to paste special: formulas
You can also you paste special to paste values only, or formats, column widths from copied cells. Pressing ALT, E, S will bring up all the options for paste special
It's because you're using absolute/partial references (e.g., $a$1, a$1) or you're referencing the sheet that the formula cell is in (e.g., Sheet1!a$1). You never need the sheet reference for the cell you're in, it messes up your ability to sort. If you need the absolute/partial references on the new sheet, just Ctrl+h and replace the sheet reference (e.g.,Sheet1!) with nothing (e.g., ) after you paste it over.
You can also copy formulas in notepad, select all and paste in new sheet/workbook
Control + F. Make sure you’re searching for formulas on sheet, and then do replace all for the “[SHEET NAME]” with “”. This essentially removes the reference to old sheet.
I’ve done this before when format is exactly the same as old sheet.