•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Click and drag to link file to cell?
Our take
Linking PDF files to specific cells in a spreadsheet can be a cumbersome process, especially when dealing with numerous entries. Instead of manually navigating through the file tree for each cell, consider whether a click-and-drag feature could streamline this task. Additionally, the current sorting of files in the ‘Insert Hyperlink’ dialog box—by alphabetical order rather than by most recent—can complicate file selection. As you anticipate managing hundreds of PDF files, exploring solutions to enhance efficiency and accuracy in linking will be essential for maintaining productivity.
I need to link to pdf-files from specific cells in a table. Hence, I right click the cell, select ‘Link’ and browse for the file within the file tree and select it. But having to do this individually for every single table row is time-consuming.
Is there any way I could just click and drag the file into the table?
Alternatively, it would be much easier if the files in the ‘Insert Hyperlink’ dialog box were sorted with the most recent file on top, but they’re always sorted alphabetically, it sems. Is there any way to change this?
Down the road I’ll have several hundred pdf files to link to in the same folder and often with relatively similar names, so making sure I link to the correct file becomes even more of an issue.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Links to a cell within current worksheet keep changing the location, or doesn't work at all.I have a series of titles at the top of my worksheet with links to the most popular categories, hopefully to get to those categories quickly for data entry. I right click on the cell where I want the link, select Link, the enter the cell reference I want to jump to, with the text to display. This works. It presents a link, and if i click on the link, it jumps to exactly where I want it to go. However, over time, the cell reference isn't correct, and jumps to something else. I assume this is happening due to modifications of the worksheet or what it's from. I do not use "$" in the cell reference, assuming that if I enter A720 as the cell reference, the reference will automatically be modified to A730 if 10 rows are added. I have enough of these links that I shouldn't have to modify all of them each time there is an insertion or deletion. I tried using the formula =HYPERLINK(A730, "Category1") or =HYPERLINK('Shawna Smith'!A730, "Category1"), and neither of these work at all. It does not jump to A730 when I click on it. What am I doing wrong, or should I be using another feature or formula? Thank you for your help. https://preview.redd.it/nb4q3dm883tg1.png?width=649&format=png&auto=webp&s=cfc0c9e7f2d7e9d620075eebf6def8e7500f09fa submitted by /u/KatMagic1977 [link] [comments]
- Hyperlink on Excel MobileI am building a complex spreadsheet for an operational task at work. Without going into detail essentially employees that are out on the road will use cell phones or tablets to enter data for employees that are at the home office to print. The current set up is chaos. In my workbook, there are many hyper links that on desktop are one touch however, in mobile, you have to click, two sometimes three drop downs to open the link. I have a mixture of formula hyperlinks that are title words, button style, hyperlinks attached to a text box or picture that are above the cell and within the cell. They all do the same thing. In Excel online some perform as one touch and some you have to open the link then click the link. It would be fine if the clicking wouldn’t result in hyperlinks getting deleted or messed up and I have too many tasks to micromanage the corrections. Does anyone have any suggestions on how to make these perform as one touch on mobile? submitted by /u/Present_Brush7357 [link] [comments]