Default Excel F4 Keyboard Assignment in Excel for Mac In Excel for Mac the F4 key is assigned to the Pastecommand, which is driving me crazy so I decided to do something about it. The F4 key in Excel for Windows is normally a shortcut key to Repeat the last command. Get over 200 Excel shortcuts for Windows and Mac in one handy PDF. In later versions of Excel on Windows, Control + P has the same result. Use this shortcut to open the print preview window. Although either method should force an update of the cell formating, I would lean. The second option is to copy a value of 1 and paste it into the cells using the Paste Special - Multiply option. The first is to use the Text to columns functionality even though there is nothing in the column to split. I can think of two options to get Excel to apply the formatting to the cells in one step.
