- First, use CTRL + c to copy the parent cell (including format).
- Then hit Alt+E,S,T,Enter to paste format only to the active cell.
Elegant? Think not....
Well, here's what I came up with: add the format painter to the quick access bar. (Right click it on the ribbon to access a context menu, choose "add to quick...").
Then, you can access the format painter by hitting the automatically assigned keyboard shortcut (depending on where you put the Format painter on the quick access bar). In my case, I reach it by hitting Alt+4. You find out by hovering your mouse over the quick access button for the painter.
No comments:
Post a Comment