| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"alt + enter" closes the worksheet
I opened a workbook and pressed "alt+enter" straight away, the result was the
workbook gets closed. Is this an excel "feature"? I have searched for the "alt+enter" combination, but all the results point to inserting a line break in a cell. Anyone, any ideas, please? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"alt + enter" closes the worksheet
Just tinkered here in xl03
Seems like your .. pressed "alt+enter" straight away .. opens a new book. But it doesn't close your book (just gets "hidden"). You can see/go to your other book via clicking Window choose the book from dropdown In Edit mode, when you double-click into a cell to type something, then pressing alt+enter will break for a new line -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jarr" wrote: I opened a workbook and pressed "alt+enter" straight away, the result was the workbook gets closed. Is this an excel "feature"? I have searched for the "alt+enter" combination, but all the results point to inserting a line break in a cell. Anyone, any ideas, please? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"alt + enter" closes the worksheet
Max
Thanks for the note. That was my first thought. I have opened two workbooks, press "alt+enter" (without selecting any cells) and the workbook closes (does not ask for "Save"). I then, click on "window" menu , and use the drop down to select the workbook but it is not there. I even tried "window" -- "Arrange" but the same end result: The workbook is not "hidden". By the way, I know about "alt+enter" for adding break lines. Any other thoughts... Jarr "Max" wrote: Just tinkered here in xl03 Seems like your .. pressed "alt+enter" straight away .. opens a new book. But it doesn't close your book (just gets "hidden"). You can see/go to your other book via clicking Window choose the book from dropdown In Edit mode, when you double-click into a cell to type something, then pressing alt+enter will break for a new line -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jarr" wrote: I opened a workbook and pressed "alt+enter" straight away, the result was the workbook gets closed. Is this an excel "feature"? I have searched for the "alt+enter" combination, but all the results point to inserting a line break in a cell. Anyone, any ideas, please? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"alt + enter" closes the worksheet
Any other thoughts...
I'm out. Maybe others could offer -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jarr" wrote in message ... Max Thanks for the note. That was my first thought. I have opened two workbooks, press "alt+enter" (without selecting any cells) and the workbook closes (does not ask for "Save"). I then, click on "window" menu , and use the drop down to select the workbook but it is not there. I even tried "window" -- "Arrange" but the same end result: The workbook is not "hidden". By the way, I know about "alt+enter" for adding break lines. Any other thoughts... Jarr |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"alt + enter" closes the worksheet
Max
Can you duplicate the issue? "Max" wrote: Any other thoughts... I'm out. Maybe others could offer -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jarr" wrote in message ... Max Thanks for the note. That was my first thought. I have opened two workbooks, press "alt+enter" (without selecting any cells) and the workbook closes (does not ask for "Save"). I then, click on "window" menu , and use the drop down to select the workbook but it is not there. I even tried "window" -- "Arrange" but the same end result: The workbook is not "hidden". By the way, I know about "alt+enter" for adding break lines. Any other thoughts... Jarr |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"alt + enter" closes the worksheet
Can you duplicate the issue?
No. It opens a new book, as mentioned in my 1st response. When a book is opened, there would already be a cell selected. Pressing alt+enter simply opens a new book for me. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"alt + enter" closes the worksheet
If you open excel in safe mode:
Close excel windows start button|Run type: excel /safe do you get the same results when you hit alt-enter? If you don't, then you might have a macro that's intercepting the alt-enter and doing what it wants to do. (Starting in safe mode will avoid this macro.) If the problem goes away, are you ready to do some detective work to find out the culprit? Chip Pearson has some notes on how to diagnose startup errors: http://www.cpearson.com/excel/StartupErrors.htm And Jan Karel Pieterse has more notes: http://www.jkp-ads.com/Articles/StartupProblems.asp Essentially, you'll turn off all the addins/startup workbooks and then open excel. And then turn on each addin (closing and reopening) one at a time to find the culprit. Jarr wrote: I opened a workbook and pressed "alt+enter" straight away, the result was the workbook gets closed. Is this an excel "feature"? I have searched for the "alt+enter" combination, but all the results point to inserting a line break in a cell. Anyone, any ideas, please? -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"alt + enter" closes the worksheet
On my Excel 2003 open a workbook, make no changes then hit Alt + Enter in
non-edit mode closes the workbook with no save or message. Opened VBE and no project shows up so book is not just hidden. Most strange Gord Dibben MS Excel MVP On Wed, 30 Apr 2008 14:47:05 +0800, "Max" wrote: Can you duplicate the issue? No. It opens a new book, as mentioned in my 1st response. When a book is opened, there would already be a cell selected. Pressing alt+enter simply opens a new book for me. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"alt + enter" closes the worksheet
Dave
Thanks for your input. I have learned about Excel /safe (I am assuming it works with all MS apps). I did as you suggested, and I could repeat the issue. I open a workbook, did not click on anything, press "alt+enter" and workbook is closed without prompts.. "Dave Peterson" wrote: If you open excel in safe mode: Close excel windows start button|Run type: excel /safe do you get the same results when you hit alt-enter? If you don't, then you might have a macro that's intercepting the alt-enter and doing what it wants to do. (Starting in safe mode will avoid this macro.) If the problem goes away, are you ready to do some detective work to find out the culprit? Chip Pearson has some notes on how to diagnose startup errors: http://www.cpearson.com/excel/StartupErrors.htm And Jan Karel Pieterse has more notes: http://www.jkp-ads.com/Articles/StartupProblems.asp Essentially, you'll turn off all the addins/startup workbooks and then open excel. And then turn on each addin (closing and reopening) one at a time to find the culprit. Jarr wrote: I opened a workbook and pressed "alt+enter" straight away, the result was the workbook gets closed. Is this an excel "feature"? I have searched for the "alt+enter" combination, but all the results point to inserting a line break in a cell. Anyone, any ideas, please? -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"alt + enter" closes the worksheet
Gord,
Bizarre! Just tried it out on my home pc. Earlier attempts were on a laptop. Pressing alt+enter opens a new book, as before. Consistent behaviour for me it seems <g. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Gord Dibben" <gorddibbATshawDOTca wrote in message ... On my Excel 2003 open a workbook, make no changes then hit Alt + Enter in non-edit mode closes the workbook with no save or message. Opened VBE and no project shows up so book is not just hidden. Most strange |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
