How can I make the format of Cell A1 in sheet_1 H & W to be the same for cell A1 in all the sheets?
Also if this cell A1 has an image (company Logo), is there a way to copy it dynamically in every sheet?
How can I make the format of Cell A1 in sheet_1 H & W to be the same for cell A1 in all the sheets?
Also if this cell A1 has an image (company Logo), is there a way to copy it dynamically in every sheet?
Oceans Blue
Copy the format of the source cell.
Click the tab of the first sheet you want to reformat then hold "Shift" and click the tab of the last sheet.
Paste the format into the destination cell(s).
Ben Van Johnson
I appreciate you getting back to me, but it is not clear.
I do not have a selection to copy format !
It's called "Format Painter" and has a paint brush icon.
With cell A1 selected, clicking button the first time copies the the cell format and the mouse pointer turns to a paintbrush. Once you select the tabs you just click the cell you want to apply the format to.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks