Home |
Search |
Today's Posts |
#10
![]() |
|||
|
|||
![]()
Glaaad to hear you got it sorted out <g !
On a related note, do you know of a shortcut to make a non-relative link to a cell without manually typing in the $'s? Think Dave Peterson had earlier posted Excel uses absolute references for the linked cell if it's to / in another book But we could use the F4 key to toggle through the 4 cell reference states instead of amending manually the link cell formula after we've clicked to produce the link and entered the formula =[Book4]Sheet1!$A$1 Try this: Select the part: $A$1 in the formula Press F4 key to toggle through the 4 cell ref states: $A$1, A$1, $A1, A1 and stop of course, at the desired state -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking Pictures in Cells | Excel Worksheet Functions | |||
Linking cells in a worksheet to other worksheets in a workbook | Excel Discussion (Misc queries) | |||
Unlocking Cells when a worksheet is protected... | Excel Discussion (Misc queries) | |||
Help me! There is problem with cells view... | Excel Discussion (Misc queries) | |||
linking cells | Excel Worksheet Functions |