Using sheets in excel
Closed
klausnick
TrowaD
- Posts
- 1
- Registration date
- Thursday June 12, 2014
- Status
- Member
- Last seen
- June 12, 2014
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- Using sheets in excel
- How to transfer data from another sheet in excel - Guide
- How to apply a formula to multiple sheets in excel - Guide
- How to create a master sheet from multiple sheets in excel ✓ - Forum - Excel
- Student mark sheet in excel format xls download - Guide
- How to pull data from a master sheet in excel - Guide
1 reply
TrowaD
Jun 12, 2014 at 11:15 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Jun 12, 2014 at 11:15 AM
Hi Klausnick,
Let's say you want to keep column B from sheet 1 and place them in column A of sheet 2.
Go to sheet 2 cell A1. Type = and go to sheet 1 cell B1 and hit enter. Now drag sheet 2 cell A1 down as far as needed and all the values from sheet 1 column B are now also in sheet 2 column A. Repeat for other columns.
Best regards,
Trowa
Let's say you want to keep column B from sheet 1 and place them in column A of sheet 2.
Go to sheet 2 cell A1. Type = and go to sheet 1 cell B1 and hit enter. Now drag sheet 2 cell A1 down as far as needed and all the values from sheet 1 column B are now also in sheet 2 column A. Repeat for other columns.
Best regards,
Trowa