SS Formatting

Ctrl+C - copies all cell informationCtrl+Alt+V - launches the "Paste Special" dialog boxT - selects the Format option from the "Paste Special" dialogEnter - applies the format

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

Ctrl+C - copies all cell informationAlt - activates the keyboard shortcuts on the ribbonH - selects the Home tab on the ribbonV - selects the Paste menuS - launches the "Paste Special" dialog boxT - selects the Format option from the "Paste Special" dialogEnter - applies the format

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

Ctrl+C - copies all cell informationAlt - activates the keyboard shortcuts on the ribbonE,S - launches the "Paste Special" dialog boxT - selects the Format option from the "Paste Special" dialogEnter - applies the format

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

Ctrl+C - copies all cell informationShift+F10 - displays the context menuS - selects the "Paste Special" itemR - pastes just the formatting

Bibliography

https://www.wallstreetmojo.com/shortcut-format-painter-in-excel/https://www.exceldemy.com/format-painter-shortcut-excel/
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/