Found in Just for Fun, Knowledge Transfer.
If you’re a fellow leftie like me, stuck in a world of right-handed mice, then you’ll appreciate this handy excel tip for easily linking cells.
It’s a simply as Copy-Paste, but with one little twist… when you go to paste the information (such as from Sheet1 to Sheet2), select “Paste Link” instead of the normal Paste or Paste Special. Instead of pasting in the value, it pastes in the name of the cell(s) you’re copying from.
i.e. =Sheet1!A2 , =Sheet1!A3, etc.
This is especially handy when you have renamed sheets to be something more descriptive.
=’Tim”s Budget’!A2
Cheers!
Christopher Foundas is a Project Manager and a Certified Inbound Marketing Professional. He graduated with distinction from the Clarkson University School of Business, and holds a B.S. in Business & Technology Management. He enjoys writing about the technology issues that impact businesses including social media, IT implementations, and software development.
Copyright © 2009-2010 Christopher Foundas.
User Responses
View Comments and Counting...
05.13.2010
[...] This post was mentioned on Twitter by Christopher Foundas. Christopher Foundas said: Excel tip to make your life easier http://goo.gl/fb/TFXJN [...]
[...] Chris has a great post on an Excel function that can make life easier. You can read his blog post here. Stay tuned for new posts, things got hectic on my end. Below find a listing of [...]