It was the default behavior of the Ctrl+D shortcut not long ago, but as it seems, some update changed this. Now, everytime I hit Ctrl+D to extend the function or just to repeat the value of the first row/cell the format is extended too, messing with the format of the cells below.
Most of the times I have an already formatted table, and just want to extend the formula of the function, for example, but I always forget about this, then I have to undo, copy the function, select the range I want, paste the funciton and hit Alt+Enter. Many times it’s easier to just extend the function using the “Fill cells” tool, but that behavior really annoys me.
Posible answer to related question:
A long time ago, back in the last millennium, this is exactly why office suites started to include the ability to write and run macros. Do you know what exactly you want to do? Do it yourself.
Select any cell below the first row (so that you can press the up arrow a little later), launch the macro recorder. Press the up arrow (as if you were selecting the cell you want to copy), press Ctrl+C, then the down arrow (to return to the cell you want to paste the copy into), press Ctrl+Shift+V to open the Paste Special menu, uncheck the Formats checkbox and press OK. Stop recording the macro, check if it works correctly on different cells and different data. Assign the Ctrl+D key combination to this macro.
3 Likes