SS Formatting
Formatting Functions
Format Painter
Excel
Tested on version 2108
Google Sheets
Mouse
Right-click the cell(s)/row(s)/column(s) you want to copy the format from.
Select Copy
Right-click the cell(s)/row(s)/column(s) you want to apply the format to.
Select the Paste Formatting option
Keyboard Method#1
Select the cell(s)/row(s)/column(s) you want to copy the format from.
Alt, H, F, P
Click the cell(s)/row(s)/column(s) you want to apply the format to.
Keyboard Method#2
Select the cell(s)/row(s)/column(s) you want to copy the format from.
Ctrl+C
Click the cell(s)/row(s)/column(s) you want to apply the format to.
Ctrl+Alt+V, T, Enter
Keyboard Method#3
Select the cell(s)/row(s)/column(s) you want to copy the format from.
Ctrl+C
Click the cell(s)/row(s)/column(s) you want to apply the format to.
Alt, H, V, S, T, Enter
Keyboard Method#4
Select the cell(s)/row(s)/column(s) you want to copy the format from.
Ctrl+C
Click the cell(s)/row(s)/column(s) you want to apply the format to.
Alt, E, S, T, Enter
Keyboard Method#5
Select the cell(s)/row(s)/column(s) you want to copy the format from.
Ctrl+C
Click the cell(s)/row(s)/column(s) you want to apply the format to.
Shift+F10, S, R