0
How do you make the information on one Excel sheet the same as on another Excel sheet?
Wiki User
∙ 11y ago
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
You could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
Wiki User
∙ 11y ago
Wiki User
∙ 11y agoYou could just copy everything on one sheet to another. If you want to keep the sheets always having the same thing, then you need formulas in the other sheet, making the cell equal to the other sheet's corresponding cell. So if you wanted what was in A1 on Sheet2 to be the same as A1 on Sheet1, then in A1 on Sheet2 you would have:
=Sheet1!A1
You then have to copy that formula to all cells in the worksheet on order to make it the same as the first sheet.
Add your answer:
Earn +20 pts
How do you make a result sheet in Excel?
how to create a excel sheet
How do you make a cover sheet in excel?
Add a sheet
What is a spread sheet?
A spreadsheet is a grid that is filled in with information. Most commonly, they're used to keep track of finances. The Microsoft program "Excel" will help you make spreadsheets, as will "Corel Word Perfect".
How do you make a Sign up sheet with Excel?
Well I don't really know how to make one with excel, but I know how to make one with word.Pumpkin carving contestName_________________________________________Age_____Name_________________________________________Age_____Name_________________________________________Age_____Name_________________________________________Age_____Name_________________________________________Age_____Name_________________________________________Age_____Sorry I couldn't be more helpful. Hope this works!
What is the size of an Excel sheet?
The max columns on an excel 2007 sheet are 16k. The max rows are 1M. In excel 2003 the max columns are 256 and max rows of 64k.
How do you apply bold styles to text in a Microsoft Excel sheet generated by PHP?
The origin of the sheet usually doesn't matter. You can apply bold styles to PHP generated sheets as you would in any other sheet: right click the cell or text you want to make bold, and select the appropriate option to change font styles (which varies depending on your version of Microsoft Excel).
Is it safe to use a waterproof sheet in a newborn baby's crib?
Yes, make sure you put another sheet above the waterproof sheet as it may be uncomfortable.
How do you make pie chart in excel sheet?
You press 'insert' then press 'char't and you can choose which one you want, i.e, bar, spike, stuff like that!
What is the best way for young girls to track their red wings schedule?
"Try keeping a chart or excel sheet, there are plenty of phone apps that can accomplish this. However, for those who aren't tech savvy a journal can also help. Just make sure no one else can get that information."
What is the Excel sheet tab?
A sheet tab appears at the bottom of your worksheet. It has the name of the worksheet on it, which can be changed and you can also change its colour. This can be done by right clicking on it and picking the option from the shortcut menu that appears. By clicking a sheet tab, you can make that sheet the active sheet so that you can work on it. You can click on the sheet tab to move its position by dragging on it, or also from the shortcut menu.
Can an existing database be recalibrated when you start Excel?
All formulas recalculate when Excel opens, so if a database in Excel has formulas in it, it will be recalibrated. It could also be linked to another file or external source which may make it change when it is opened.
What can people do using Microsoft Excel?
Microsoft Excel is a spreadsheet program used to make charts containing information. You can make calculations. use graphing tools, and pivot tables. On this program you can enter, analyze, and present data in a organized way.
