Single cell in my "work area" tab to be copied to a cell in the
Closed
tom
-
May 20, 2015 at 04:31 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - May 25, 2015 at 08:34 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - May 25, 2015 at 08:34 AM
Related:
- Single cell in my "work area" tab to be copied to a cell in the
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Count if cell contains number - Excel Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Which key is used to make multiple line in a single cell - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
May 25, 2015 at 08:34 AM
May 25, 2015 at 08:34 AM
Hello Tom,
If the calculations are done in just one cell , say cell A1 in Sheet 2 and you want the result in cell A1 in Sheet 1 then:-
In A1 in Sheet 1 enter the equals sign (=) but do not press enter. Go to Sheet 2 and high-light (click on) cell A1. You should see "marching ants" patrolling the perimeter of the cell. Press enter. Done! The result will be seen in A1 Sheet 1.
If you click on cell A1 in Sheet 1, you will see the simple formula in the function bar.
I hope that this helps.
Cheerio,
vcoolio.
If the calculations are done in just one cell , say cell A1 in Sheet 2 and you want the result in cell A1 in Sheet 1 then:-
In A1 in Sheet 1 enter the equals sign (=) but do not press enter. Go to Sheet 2 and high-light (click on) cell A1. You should see "marching ants" patrolling the perimeter of the cell. Press enter. Done! The result will be seen in A1 Sheet 1.
If you click on cell A1 in Sheet 1, you will see the simple formula in the function bar.
I hope that this helps.
Cheerio,
vcoolio.
