Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Continue typing in a cell after leaving the workbook.
I would like to continue typing in a cell while toggling between pages.
Example: I want to type the number 123,465,789.10 in a cell and I only complete 123,456 and I toggle to a web page (or another workbook) to get the rest of the number and I want to go back to the workbook and continue typing ,789.10 where I left off. Sometimes Excel lets you do this and other times it does not. When it does not, you have to start typing all over again when you toggle back to your original page. Thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Continue typing in a cell after leaving the workbook.
F2 lets you start where you left off.
-- -- -John Please rate when your question is answered to help us and others know what is helpful. "andy" wrote in message ... I would like to continue typing in a cell while toggling between pages. Example: I want to type the number 123,465,789.10 in a cell and I only complete 123,456 and I toggle to a web page (or another workbook) to get the rest of the number and I want to go back to the workbook and continue typing ,789.10 where I left off. Sometimes Excel lets you do this and other times it does not. When it does not, you have to start typing all over again when you toggle back to your original page. Thank you! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Continue typing in a cell after leaving the workbook.
Or when going back to excel, click the title bar rather than a blank
cell in the workbook. Or just click into the formula bar when switching back to the program. John Bundy wrote: F2 lets you start where you left off. -- -- -John Please rate when your question is answered to help us and others know what is helpful. "andy" wrote in message ... I would like to continue typing in a cell while toggling between pages. Example: I want to type the number 123,465,789.10 in a cell and I only complete 123,456 and I toggle to a web page (or another workbook) to get the rest of the number and I want to go back to the workbook and continue typing ,789.10 where I left off. Sometimes Excel lets you do this and other times it does not. When it does not, you have to start typing all over again when you toggle back to your original page. Thank you! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Continue typing in a cell after leaving the workbook.
It will work if you toggle between the workbook in question and another
program, not if you toggle between different workbooks or different sheets. One way to avoiding typing all over again is to press F2 when you return to the sheet you are typing in Regards, Peo Sjoblom andy wrote: I would like to continue typing in a cell while toggling between pages. Example: I want to type the number 123,465,789.10 in a cell and I only complete 123,456 and I toggle to a web page (or another workbook) to get the rest of the number and I want to go back to the workbook and continue typing ,789.10 where I left off. Sometimes Excel lets you do this and other times it does not. When it does not, you have to start typing all over again when you toggle back to your original page. Thank you! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Continue typing in a cell after leaving the workbook.
Thanks All! I should have know that!
"andy" wrote: I would like to continue typing in a cell while toggling between pages. Example: I want to type the number 123,465,789.10 in a cell and I only complete 123,456 and I toggle to a web page (or another workbook) to get the rest of the number and I want to go back to the workbook and continue typing ,789.10 where I left off. Sometimes Excel lets you do this and other times it does not. When it does not, you have to start typing all over again when you toggle back to your original page. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
New numbers | Excel Worksheet Functions | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) |