Excel sheets within workbook

This is something that I never have need for on my own spreadsheets but my wife did. In order to put some formulas on every worksheet in her workbook, I tied them together but this was several months ago and I dont remember how.

Now I need to unhook them. What is the procedure called and how do I unlock them?

 

I think the term your looking for is Link, as in linking worksheets.

Try the Help files in Excel, look up either Link or Formula or Worksheet

One of those should provide the information you're looking for.

 

I checked the 'link' in the help file but it doesn't seem to be the process I want to see.

 

Hi - I have found it very difficult to remove links in Excel pages and even with
just one link, I still cannot fathom it out. The nearest I came was a search
for "Microsoft Excel Link" maybe they have something new to help you.
regards

 

Is 'Link' really the thing I want to use. It sounds like a link to another spreadsheet.

I just want to tie (or untie) worksheets together TEMPORARILY so that I put the same formulas on different sheets within the same workbook. Each sheet represents a different month.

 

I think that what you want is referred to as grouping sheets in Excel. To group sheets click one sheet tab, hold down the shift or control key, and click another tab or group of tabs. This will group them together to populate the same cell in multiple sheets. I believe, when you select multiple tabs, that they will be highlighted or shaded.

To then un group them,click on one sheet tab seperately, and it should then be the only one that is shaded or high lighted. The shading or high light should confirm that the sheets are unlinked.

 

You got it. Grouping was the word I had forgotten. I have not tried it yet buit what you said reminded me of the last time I had used it

Thanks