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 where you could show to just copy formula without changing the layout. This is no changed into a new formatting box with a lot of options but no option to keep the layout.
Do anyone have a solution for this?
From the picture you can see that I try to copy the cell with the number 9 down the column, but it changes the layout (removing the blue colour) the suggested options does not give me any opportunity to keep the layout.
I hope anyone out there could help me with this problem. It would be highly appreciated since I have a huge spreadsheet that I update every month and the new version completely destroys the layout
