Link Spreadsheet Document मुफ़्त में

here I want to show you how to link data between worksheets within workbook so basically how we can have data on one sheet here and pull it into another sheet and this will allow you to have a sheet that could contain your raw data that you will never touch or at least you're not going to edit the figures on that sheet and then use your other worksheets to manipulate augment and display that data however you want so let's go ahead and get started with this sample data here we've got month sales bunch of numbers and what I want to do is to just quickly pull in all this data into sheet 2 so we go to sheet 2 let's start in cell a1 and all we're really going to be doing is to enter a formula so we start with the equal sign now we need to navigate to the cell that contains the data we want to bring into here so we go to sheet 1 select cell a1 + 2 B for navigating away from sheet 1 hit the enter key now we've got the data from sheet 1 cell a1 so we can't continue this equals go to where the data is located click the cell we want hit enter and so on now before I show you a really quick way to do this let me show you what happens if you hit the equals sign go to sheet 1 click the cell you want now if you navigate away from here before you hit the enter key look up here right now says equals sheet 1 exclamation point a3 if we go to sheet 2 it'll say equals sheet 2 exclamation point a3 sheet 3 same thing so that's why you want to hit the enter key before you leave the worksheet that contains the data you want to pull in to the other worksheet now a really quick way to bring it in is to select the cell that contains the formula we just entered on sheet to go to the quick fill handle in the bottom right hand corner and pull it all the way down now let's go ahead and select all this data quick fill handle pull it to the right one now notice that none of the formatting is coming through and actually if that was a little bit confusing for you note that it's just from relative cell references so since we don't have dollar signs in front of the a1 here we can use the quick fill to quickly pull in lots of data now that we've done that let's go ahead and add some formatting so it doesn't bring in any formatting and that allows you to add whatever type of formatting you want and it's not going to change what was on the other sheet and now that we've got this data here we can do anything that we want to it such as equals this divided by ten and acts as if the number or actually in the cell and that's really all there is to linking data between worksheets within a single workbook