How can I link an Excel cell so a user can click the name in the cell to open a digital photo elsewhere?
I have seen this where a file folder contains an Excel document and another folder containing digital photos. One column in the Excel spreadsheet has the name of one of the pictures and is highlighted blue like a hyperlink. Click on it and the photo comes up. How do I set this up?
The photo must be available to both users, such as in a shared folder or on a network drive.
Right-click the text or graphic you want to represent the hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.), and then click Hyperlink on the shortcut menu.
Under Link to on the left side of the dialog box, click Existing File or Web page.
Do one of the following:
1.To select a file from the current folder, click Current Folder and then click the file you want to link to.
2.To select the Web page from a list of browsed pages, click Browsed Pages and then click the Web page you want to link to.
3.To select a file from a list of files you have recently used, click Recent Files and then click the file you want to link to.
4.If you know the name and location of the file or Web page you want to link to, you can type that information in the Address box.
5.To select the Web page by opening your browser and searching for the page, click Browse the Web , open the Web page you want to link to, and then switch back to Microsoft Excel without closing your browser.
To assign a tip to be displayed when you rest the pointer on the hyperlink, click ScreenTip and then type the text you want in the ScreenTip text box. Click OK.
Dan Bull – Dear Mandy [an open letter to Lord Mandelson]
|
|
Legends of the Game by Kyle Polzin Open Edition Digital Print Football Gear $39.99 |
|
|
Legends of the Game by Kyle Polzin Open Edition Digital Print Football Gear $39.99 |
|
|
Legends of the Game by Kyle Polzin Open Edition Digital Print Football Gear $39.99 |
|
|
Lens Hood Cap for FUJIFILM FinePix X100 digital camera Auto Open JJC ALC-X100 $28.27 |
|
|
Lens Hood Cap for FUJIFILM FinePix X100 digital camera Auto Open JJC ALC-X100 $28.50 |
|
|
MaxQ 2000 Digital Open Air Shaker Thermo Scientific/Barnstead Used $99.00 |
|
|
Yamaha YSP-5100BL – Open Box Digital Sound Projector $1,600.92 |
|
|
NEW 2 “Rexton Targa Plus” Open Fit Hearing Aid/Aids, Digital, Prog, 2 YR Warr $899.99 |
|
|
Samsung NX100 Brown Open Box 14.6-megapixel Digital Still Camera w/20-50mm Lens $329.97 |
|
|
NEW — Barska Point N’ View 8×32 1.3 MP Digital Camera Binoculars OPEN BOX $30.99 |
|
|
Mitsuba HD8800 720P HD Digital Video Camera Camcorder – OPEN BOX SALE $118.79 |
|
|
Samsung ST700 16.1 MP Digital Camera – Black NEW OPEN BOX $105.00 |
|
|
Panasonic CGAS101A1B – Open Box Lithium Ion Battery for DMC-F7 Digital Camera $11.97 |
|
|
Sunpak Digital Picture Frame Black – Open Box 3.5-Inch LCD Picture Frame $24.97 |
|
|
NEW OPEN BOX Fujifilm FinePix Z70 12.2 MP Digital Camera – Bronze $11.68 |
|
|
DIY Digital LED Photo Bulb Make Open Cafe Coffee Image picture Shape 5pcs Blue $0.11 |
|
|
DIY Digital LED Photo Bulb Make Open Cafe Pizza Image picture Shape 5pcs White $0.11 |
|
|
Insignia™ – 1.8″ LCD Digital Photo Key Chain – Red New in Open Box $12.74 |
|
|
17x16x9 Card+Digit+Key Keyless Auto Open Cash Safe Hotel Home Digital Electronic $109.90 |
|
|
DJ INKERS DIGITAL SCRAPBOOKING CD & DESIGN BOOKLET $18.00 |
|
|
DJ INKERS DIGITAL SCRAPBOOKING CD & DESIGN BOOKLET $18.00 |
|
|
DJ INKERS DIGITAL SCRAPBOOKING CD & DESIGN BOOKLET $18.00 |
|
|
A Open (91.ADE01.I510) Digital Engine DE45-HG – no CPU $444.99 |
|
|
Combat Folder Assisted Open Knife Camo Digital P-1108-CA1 zix $0.99 |
|
|
Open Casket Sharp (2011) – New – Digital Video Disc (Dv $13.32 |
|
|
TC69- LED DIGITAL FLASHING & STATIC OPEN MESSAGE BOARD SIGN $92.55 |
|
|
TC69- LED DIGITAL FLASHING & STATIC OPEN MESSAGE BOARD SIGN $110.00 |
|
|
TC70- LED DIGITAL STATIC OPEN / CLOSED MESSAGE BOARD SIGN $119.43 |
|
|
TC70- LED DIGITAL STATIC OPEN / CLOSED MESSAGE BOARD SIGN $110.00 |
|
|
Kurzweil SP47 SP4-7 76-Key Digital Stage Piano Keyboard – Open Box $989.99 |
|
|
Roland JUNO-Gi Mobile Synthesizer with Digital Recorder Open Box 1 $849.99 |
|
|
Desert Haze by Adin Shade Southwest Desert Cactus Open Edition Digital Print $49.99 |
|
|
Desert Haze by Adin Shade Southwest Desert Cactus Open Edition Digital Print $19.99 |
|
|
NEW 2 “Rexton Day Free” Open Fit Hearing Aid/Aids, Digital, Prog, 2 YR Warr $1,149.00 |
|
|
Canon PowerShot A490 10.0 MP Digital Camera – Silver New Open Box $49.99 |
|
|
RED SAMSUNG SH100 14.2 DIGITAL CAMERA NEW OPEN BOX DEMO $99.99 |
|
|
**BRAND NEW / OPEN BOX** Philips LFH-9370 Digital Pocket Memo $233.41 |
|
|
Tektronix VX4802 80 Channel Digital IO Module OPEN UNUSED IN ORGINAL BOX $1,529.99 |
|
|
American Audio VMS4.1 USB Digital DJ Controller VMS41 VMS 4 4.1 Virtual DJ OPEN $409.99 |
|
|
WHOLESALE: VuPoint Digital Cameras & Photo Fame Keychains – Open Box – 12 Pieces $5.00 |
|
|
MOTOROLA DIGITAL AUDIO BABY MONITOR NEW IN OPEN BOX WIRELESS MODEL MBP 11 $35.99 |
|
|
NEW! OPEN BOX – Sony Cyber-shot DSC-WX9 16.2 MP Digital Camera – Black $129.99 |
|
|
NEW! OPEN BOX – Sony Cyber-shot DSC-W560 14.1 MP Digital Camera – Red $79.99 |
|
|
Open Box Rocketfish 8′ Digital Optical Audio Cable RF-G1219 $8.99 |
|
|
Open Box Rocketfish 4′ Digital Optical Audio Cable RF-G1218 $6.99 |
|
|
NEW Open Box: VuPoint M5056 Digital 5.0 Megapixel Camcorder w/ SD Slot MSRP $150 $9.99 |
|
|
NEW! OPEN BOX – Samsung PL120 14.0 MP Digital Camera – Black $79.99 |
|
|
Sony Alpha SLT-A33 14.2 MP Digital SLR Body – OPEN BOX $509.99 |
|
|
SONY HDR-AX2000 DIGITAL HD VIDEO CAMERA RECORDER OPEN BOX/3-YEAR WARRANTY/$1 $1,925.00 |
|
|
FUJIFILM FINEPIX F300EXR 12.0 MP DIGITAL CAMERA BLACK – NEW (OPEN-BOX) $149.99 |
|
|
FUJIFILM FINEPIX F80EXR 12.0 MP DIGITAL CAMERA BLACK – NEW (OPEN-BOX) $129.99 |
|
|
FUJIFILM FINEPIX S2800HD 14.0 MP DIGITAL CAMERA BLACK – NEW (OPEN-BOX) $169.99 |
|
|
Open Graves (Ws) (2010) – Used – Digital Video Disc (Dv $3.04 |
|
|
New 36 Melody Music Wireless Security Digital Doorbell Door Bell 100~150M(Open) $5.95 |
|
|
ACU DIGITAL CAMOUFLAGE COMPACT MODULAR ROLL-UP UTILITY POUCH – 8 x 6.5″ Open $3.95 |
|
|
New 36 Melody Music Wireless Security Digital Doorbell Door Bell 100~150M(Open) $5.98 |
|
|
DIY Digital LED Photo Bulb Make Open Cafe Pizza Image picture Shape 1pcs White $0.06 |
|
|
DIY Digital LED Photo Bulb Make Open Cafe Coffee Image picture Shape 1pcs Red $0.06 |
|
|
Apple Digital AV Adapter !! Genuine / Original !! Mint Condition in Open Box !! $18.50 |
|
|
Casio AT5 76-Key Oriental Portable Home Keyboard Digital Piano – Demo/Open Box $449.99 |
|
|
Cuisinart TOB-40 Custom Classic Toaster Oven Broiler $65.99 Product Features: Toast, Bagel, Bake and Broil functions 1800 watts Full size interior holds and 11 pizza and 4-slices of toast Stainless Steel front with rubberized easy grip dials and cool touch handle Always Even Shade Control monitors the temperature and adjusts the timing to consistently toast to the shade selected every time! Convenient auto slide-out rack for hands-free loading and easy re… |
|
|
Taylor 9842 Commercial Waterproof Digital Thermometer $8.75 Flat-Edged Dial Safe-T-Guard Thermometer with Antimicrobial Sleeve. Special additive in the sleeve material inhibits bacterial and fungal growth. Thermometer is waterproof for dependable use in kitchen or lab environments. Field calibratable. Auto-off feature saves on battery life. What’s Included: One LR44 battery… |
|
|
RT600C Super-fast Water-resistant Digital Pocket Thermometer $19.00 We’ve added another version of our popular RT600 series. The RT600C from ThermoWorks offers a Super-Fast, reduced-tip probe for 5- to 6-second readings. The sealed body of the thermometer features rubberized switch panels, a robust LCD window, and it withstands temperatures to 190°F so you can record peak temperatures in commercial dishwashers using the Min/Max feature. There are many digital poc… |
|
|
The Hunger Games: Songs From District 12 And Beyond $9.99 … |
|
|
Young The Giant $7.99 … |
|
|
The Reckoning $9.99 … |
|
|
The Visual Bible’s Acts – Open Caption [VHS] $99.95 … |
|
|
2000 US Open Taekwondo Championships [VHS] $49.95 … |
|
|
2000 Korean Open Tae kwon Do Championships [VHS] $79.95 … |
|
|
Kidde KN-COSM-B Battery-Operated Combination Carbon Monoxide and Smoke Alarm with Talking Alarm $64.97 The Kidde KN-COSM-B Battery-Operated Carbon Monoxide and Smoke Alarm combines two important safety devices into a single unit. This alarm includes a voice warning system that announces “Fire, Carbon Monoxide, Low Battery, or Smart Hush Activation.” The voice alarm eliminates any confusion and clearly warns you and your family of a smoke or carbon monoxide danger, or if your battery is in need of r… |
