formatting should be done @worksheet level
check the below points
Copy and paste worksheet formatting
After you format a worksheet, you can copy its formatting settings and paste them into other worksheets. The settings that you can copy are anything you can set in the Format pane, with the exception of reference lines and annotations. Adjustments like manual sizing and level of zoom are not copied.
- Select the worksheet from which you want to copy formatting.
- Right-click (control-click on Mac) the worksheet tab and selectCopy Formatting.
- Select the worksheet you want to paste the formatting into.
- Right-click (control-click on Mac) the worksheet tab and selectPaste Formatting.
Hope this helps
Plz mark this answer as correct or helpful to close the thread
Select the sheet in which you need same format and copy format.
Go to new workbook sheet and paste formatting.
You can use different screening programs. I recently wrote a resume and ran into the fact that you need to download the text. I downloaded the screening program and translated the manual text