Paste formatting to same cells on multiple sheets

EBoudreau

Board Regular
Joined
Aug 21, 2015
Messages
153
Is there a way to copy and paste formatting from a range of cells on one sheet in a workbook to the same cells on multiple other sheets at the same time?

I have a timekeeping workbook where I have 52 tabs where each tab is a week for tracking hours worked.
I need to go through and adjust some formatting, so I would like to make all my adjustments in sheet 1 and then copy and paste to the same cells on the rest of the 51 other sheets.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Very easy no pasting needed
While holding down the shift key, click the first sheet tab then the last sheet tab to group them. Apply your formatting to the first sheet and it applies automatically to the entire group.
Ungroup sheets and you're done
 
Upvote 0
Solution
Very easy no pasting needed
While holding down the shift key, click the first sheet tab then the last sheet tab to group them. Apply your formatting to the first sheet and it applies automatically to the entire group.
Ungroup sheets and you're done
In my attempt to do so, it appears I’m unable to as I am using the Excel app for iOS. Is that something that can only be done on a desktop or laptop version?
 
Upvote 0
I have no idea. If you can,amend the thread title to include these restrictions
 
Upvote 0
If you can,amend the thread title to include these restrictions
That is not possible for the OP, but ...

@EBoudreau
I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using. (Don’t forget to scroll down & ‘Save’)
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top