Daft Excel Question

[nikaiyo2]

Sooo using = copies the content of one cell to another and keeps it relational, is there an easy way to do this but also keep formatting from the source cell? I dont want to have to copy and paste each time.

I have a spread sheet that has multiple pages that have the same "structure" basically week commencing dates etc and it would be nice to be able to alter one and have it copy over to all.

[ZesPak]

Nope, not as far as I know.

[vaud]

You can select multiple tabs (option key on a Mac, control on Windows) and the change you make on the current tab will be reflected in the exact same position in the selected tabs.

[bigandclever]

Not sure if this actually answers your question

You can use Format Painter to apply the format of the source cell(s) to the cells that reference them, if that's what you mean? It's about 3 clicks.

[nikaiyo2]

bigandclever said:

Not sure if this actually answers your question

You can use Format Painter to apply the format of the source cell(s) to the cells that reference them, if that's what you mean? It's about 3 clicks.

What I was hoping to do, is create page 1 then be able to duplicate certain sections formatting and data into other pages.

So for instance B2 can be copied using = to D2 but it just copies the data. I was hoping that their was an easy solution to copy the data & formatting.

How do you do this with format painter? I have a had a play and cant seem to figure it

[vaud]

nikaiyo2 said:

What I was hoping to do, is create page 1 then be able to duplicate certain sections formatting and data into other pages.

So for instance B2 can be copied using = to D2 but it just copies the data. I was hoping that their was an easy solution to copy the data & formatting.

How do you do this with format painter? I have a had a play and cant seem to figure it

There is, use my method of selecting multiple tabs and then apply/reapply the formatting on the open tab. This will apply that formatting to every tab selected.

[ATG]

"=" isn't copying stuff. It's saying that a cells contains a formula. That formula could refer to none, one or many other cells. What format should Excel "copy" if the formula doesn't refer to another cell or refers to several cells that each have different formats?

[tangerine_sedge]

vaud said:

You can select multiple tabs (option key on a Mac, control on Windows) and the change you make on the current tab will be reflected in the exact same position in the selected tabs.

I've been using Excel since forever, and never knew that. Right! I'm off to go and trial this new knowledge on one of my huge spreadsheets!

[vaud]

tangerine_sedge said:

I've been using Excel since forever, and never knew that. Right! I'm off to go and trial this new knowledge on one of my huge spreadsheets!

When I get spare hours at work I often pick through some formula that I am less familiar with and see what they do.

[bigandclever]

nikaiyo2 said:

bigandclever said:

Not sure if this actually answers your question

You can use Format Painter to apply the format of the source cell(s) to the cells that reference them, if that's what you mean? It's about 3 clicks.

What I was hoping to do, is create page 1 then be able to duplicate certain sections formatting and data into other pages.

So for instance B2 can be copied using = to D2 but it just copies the data. I was hoping that their was an easy solution to copy the data & formatting.

How do you do this with format painter? I have a had a play and cant seem to figure it

Like this .. https://support.microsoft.com/en-gb/office/copy-ce...