1. Open two Excel workbooks at a time
2. Press "Alt+h+o+m "
This will give following window.
3. Press "Alt+t" (Press both keys simultaneously.
Following window will appear.
4. Select destination workbook, i.e select the workbook where you want to move sheet. In our example it is Book2, so we have selected book2 in the figure shown above.
5. Press "Alt+b" (for placement of sheet ) This step is optional
6. Press enter key.
it's done.
To copy excel sheet from one workbook to another workbook
7. After step 2 press "Alt+c "(It will copy the sheet instead of moving .
Trace dependent cells in excel
This short cut key is helpful at the time of identifying the value from trial balance which is not going or going many times to balance sheet and due to which balance sheet is OUT.
Step 1 for Trace dependent cells
Select the value about which we want to find that to which
sheet it is going
Step 2 for Trace dependent cells
Press the followings keys
Short Cut key= Alt+m+d
This will show the green line on the sheet indicating the path of active cell.
In this image small BOX in the green circle indicates that this value of 1,088,384 is going tho other sheet
Step 3 for Trace dependent cells
"Double Click" on this box it will show the GOTO window ,In
above image this is showing the name of destination of sheet.
Step 4 for Trace dependent cells
"Double Click" the link in the GOTO window , you will reach Sheet
where this value of trial balance is going..
Its done........
