SS Formatting
Formatting Functions
Format Painter
Excel
Tested on version 2108Google 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
Bibliography
TEXThttps://corporatefinanceinstitute.com/resources/excel/excel-text-function/https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c
NUMBERShttps://office-watch.com/2022/ordinal-numbers-excel-1st-2nd-3rd-etc/
Merged Cellshttps://spreadsheetplanet.com/find-merged-cells-excel/https://excelchamps.com/advanced-excel/find-merged-cells/https://learnexcel.io/find-merged-cells-excel/