Duplicate sheet option.
We are unable to see the duplicate sheet option like in Google Drive.
We have the option to Delete, Rename, Hide and Unhide but not this function. We are having to used copy and paste and entered the colors every time as this is done in a weekly basic.
You can duplicate a sheet in Windows Excel by right clicking on the sheet tab and choosing “Move or Copy…” In the dialog that pops up, select the “Create a copy” checkbox, and you should be good to go.