| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Fixing sheet names is a 3D reference
I have a workbook containing several worksheets and a summary sheet that
refers to all the other sheets with a 3D reference. I need to fix the 3D reference just as I can fix a cell address by entering $A$5 (eg). So my reference would appear as =SUM($Sheet1:$Sheet10:B5) - this would allow me to delete, rename the boundary sheets without the reference being affected in the summary sheet. Is there any way to do this or otherwise protect the reference in summary sheet? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fixing a sheet tab | Setting up and Configuration of Excel | |||
| reference to range names | Excel Discussion (Misc queries) | |||
| How can I make the names for Sheet tabs a reference to a cell? | Excel Discussion (Misc queries) | |||
| reference to sheets without using sheet names | Excel Worksheet Functions | |||
| Fixing a single cell reference keeping others dynamic | Excel Worksheet Functions | |||
Threaded Mode
