Forum Discussion
How can I copy a formula down a whole column without destroying the layout.
Hi, I need some help. In the new version of Excel its no longer possible to copy a formula down a whole column without destroying the layout. In the past after copying you got an option at the bottom...
Select and copy the first cell.
Select the target range.
Click the lower half of the Paste button on the Home tab of the ribbon.
Select the Formulas option under Paste (the fx button).