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.
You can see the value which u have written in sheet 1.
Select sheet 1 and press Esc to ignore the blinking.
No comments:
Post a Comment