View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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!