Skip to main content
Web Applications

Return to Answer

<kbd></kbd> fix
Source Link
edit approved Jul 29, 2018 at 23:22
user0
edit approved Jul 29, 2018 at 23:22
user0
  • 27.3k
  • 10
  • 57
  • 84

I know this is old & has been answered, but just to confirm that as of 2018.07.28, double-clicking on the Paste Format button still does not work as expected (allowing multiple Format Pastes). What doesdoes work is:

  • L.ClickL.Click the Cell you want to adopt the format of (Origin)
  • [Ctrl]+[C]Ctrl+C
  • L.ClickL.Click the Cell you want to receive the adopted formatting (Recipient)
  • Press&Hold [Ctrl]Ctrl, PRESS DON'T HOLD [Alt]Alt, Press&Hold [V]V

And that's it. Also works for any arbitrary number of other cells (at step 3, Ctrl+L.ClickCtrl+L.Click as many Cells as you wish; probably Shift+L.ClickShift+L.Click works as well). Also, the "Press Don't Hold [Alt]"Alt" bit seems to work for Step 2 as well, for some reason.

I know this is old & has been answered, but just to confirm that as of 2018.07.28, double-clicking on the Paste Format button still does not work as expected (allowing multiple Format Pastes). What does work is:

  • L.Click the Cell you want to adopt the format of (Origin)
  • [Ctrl]+[C]
  • L.Click the Cell you want to receive the adopted formatting (Recipient)
  • Press&Hold [Ctrl], PRESS DON'T HOLD [Alt], Press&Hold [V]

And that's it. Also works for any arbitrary number of other cells (at step 3, Ctrl+L.Click as many Cells as you wish; probably Shift+L.Click works as well). Also the "Press Don't Hold [Alt]" bit seems to work for Step 2 as well, for some reason.

I know this is old & has been answered, but just to confirm that as of 2018.07.28, double-clicking on the Paste Format button still does not work as expected (allowing multiple Format Pastes). What does work is:

  • L.Click the Cell you want to adopt the format of (Origin)
  • Ctrl+C
  • L.Click the Cell you want to receive the adopted formatting (Recipient)
  • Press&Hold Ctrl, PRESS DON'T HOLD Alt, Press&Hold V

And that's it. Also works for any arbitrary number of other cells (at step 3, Ctrl+L.Click as many Cells as you wish; probably Shift+L.Click works as well). Also, the "Press Don't Hold Alt" bit seems to work for Step 2 as well, for some reason.

Source Link
Khyrberos
Khyrberos
  • 1

I know this is old & has been answered, but just to confirm that as of 2018.07.28, double-clicking on the Paste Format button still does not work as expected (allowing multiple Format Pastes). What does work is:

  • L.Click the Cell you want to adopt the format of (Origin)
  • [Ctrl]+[C]
  • L.Click the Cell you want to receive the adopted formatting (Recipient)
  • Press&Hold [Ctrl], PRESS DON'T HOLD [Alt], Press&Hold [V]

And that's it. Also works for any arbitrary number of other cells (at step 3, Ctrl+L.Click as many Cells as you wish; probably Shift+L.Click works as well). Also the "Press Don't Hold [Alt]" bit seems to work for Step 2 as well, for some reason.