| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alt + Enter hotkey - what does this do?
it seems to try close the activeworkbook if it contains data, and create
a new workbook if the activebook is empty. What does it really do? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Alt + Enter hotkey - what does this do?
ALT + ENTER is usually used to enter a line-feed in a cell when in edit mode.
BUT.......it does quirky things when used not in Edit mode. It will repeat the last action taken in most cases. Close a used workbook......open it again......hit ALT + ENTER and the workbook will close. Open a blank workbook then hit ALT + ENTER to keep opening new blank books. Put a border around a cell. Move to a blank cell and hit ALT + ENTER to get a border around that blank cell. Some would call it a bug, others and undocumented feature. I use it only when editing a cell so's I don't get unexpected things happening. Gord Dibben Excel MVP On Fri, 08 Oct 2004 18:15:47 -0400, R Avery wrote: it seems to try close the activeworkbook if it contains data, and create a new workbook if the activebook is empty. What does it really do? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Alt + Enter hotkey - what does this do?
Interesting...
Gord Dibben wrote: ALT + ENTER is usually used to enter a line-feed in a cell when in edit mode. BUT.......it does quirky things when used not in Edit mode. It will repeat the last action taken in most cases. Close a used workbook......open it again......hit ALT + ENTER and the workbook will close. Open a blank workbook then hit ALT + ENTER to keep opening new blank books. Put a border around a cell. Move to a blank cell and hit ALT + ENTER to get a border around that blank cell. Some would call it a bug, others and undocumented feature. I use it only when editing a cell so's I don't get unexpected things happening. Gord Dibben Excel MVP On Fri, 08 Oct 2004 18:15:47 -0400, R Avery wrote: it seems to try close the activeworkbook if it contains data, and create a new workbook if the activebook is empty. What does it really do? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel2007 hotkey | New Users to Excel | |||
| Hotkey menu access on the MAC | Excel Discussion (Misc queries) | |||
| remove excel hotkey? | Setting up and Configuration of Excel | |||
| How can I enter a cell in excel with hotkey or combination off key | Excel Discussion (Misc queries) | |||
| is there a 'format painter' hotkey? | Excel Worksheet Functions | |||
Hybrid Mode
