We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Excel help
humphriess
Posts: 94 Forumite
in Techie Stuff
Hi all, Hoping you can help me. I am a teacher and use excel to list data on my pupils. Is it possible to click on the pupils name and enter a new spead sheet where i could add additional information?
Can't look it up on the web as if it exists i'm not sure what it would be called. Want to do someting sorta like hyperlinking in pp.
Thanks
Can't look it up on the web as if it exists i'm not sure what it would be called. Want to do someting sorta like hyperlinking in pp.
Thanks
0
Comments
-
What version of Excel are you using?
It can usually be done with the Insert, Hyperlink option when on the cell you want to link from. It can link to either a named cell in another sheet or another workbook altogether.I’m a Forum Ambassador and I support the Forum Team on the In My Home MoneySaving, Energy and Techie Stuff boards. If you need any help on these boards, do let me know. Please note that Ambassadors are not moderators. Any posts you spot in breach of the Forum Rules should be reported via the report button, or by emailing forumteam@moneysavingexpert.com.
All views are my own and not the official line of MoneySavingExpert.
0 -
as Victor2 states hyperlinking the name to the alternate spreadsheet you need would do the job simply and effectivly.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 352.3K Banking & Borrowing
- 253.7K Reduce Debt & Boost Income
- 454.4K Spending & Discounts
- 245.4K Work, Benefits & Business
- 601.1K Mortgages, Homes & Bills
- 177.6K Life & Family
- 259.2K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards