Your service sheet’s “Kit, Shelf, Count” header should look like the schedule header. Copy the formatting into the new range while keeping the words already there.

Copy a source with the same shape

In the example, A1:C1 is a styled header reading “Day, Room, Host.” E1:G1 contains “Kit, Shelf, Count.” Copy A1:C1, select E1 and choose Home → Paste Special → Formatting Only in Ulet Sheets.

The source header is a styled Day, Room, Host row and the destination reads Kit, Shelf, Count.

Illustrated ranges. Match their shapes and copy the source header.

Read the target cells after pasting

Check the new fill, font and borders. Read E1:G1 again. The target should still contain Kit, Shelf and Count. If you apply the same technique to body cells, inspect one formula or value as well as its display. A new number format can make unchanged data look different.

The styled destination still reads Kit, Shelf, Count after the paste.

Illustrated result. Verify that the appearance changed and the cell contents survived.

Save and reopen the result to check the styling and the target contents together.