Showing posts with label Linking spreadsheets in Excel. Show all posts
Showing posts with label Linking spreadsheets in Excel. Show all posts

Wednesday, October 5, 2011

From Learning to Teaching

Whenever I learn something new, I always want to spread it out as soon as possible and to as maximum people as I can.
So that means here in this Blog, you will get something what you already know or something what that is new to you.


In MS Excel, if you want to take a value from one spreadsheet to another spreadsheet following are the simple steps to do;
Write something in a cell of sheet 1. For example 50 in A1
Now copy it by pressing ctrl + c or click Edit and then click Copy
Go to sheet 2 and select a cell. For example D5
Click Edit then click Paste Special and then click Paste Link.
You can see the value which u have written in sheet 1. 
Select sheet 1 and press Esc to ignore the blinking.