LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Max
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Pictures in Cells wrinkle35 Excel Worksheet Functions 0 July 1st 05 12:05 AM
Linking cells in a worksheet to other worksheets in a workbook Dave Excel Discussion (Misc queries) 4 June 24th 05 06:18 PM
Unlocking Cells when a worksheet is protected... racmb1975 Excel Discussion (Misc queries) 2 May 3rd 05 08:57 PM
Help me! There is problem with cells view... :-) Excel Discussion (Misc queries) 1 April 28th 05 01:16 PM
linking cells justin Excel Worksheet Functions 1 April 26th 05 09:58 PM


All times are GMT +1. The time now is 05:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"