ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   control enter (https://www.excelbanter.com/excel-discussion-misc-queries/116837-control-enter.html)

Dave M

control enter
 
The Ctrl-Enter shortcut to enter today's date in a cell has stopped working.
Is there a place to turn and off?

Office 2003 SP2

Bernard Liengme

control enter
 
Use CTRL+; for date
CTRL+: (ie hold CTRL + SHIFT, then :) for time
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dave M" <Dave wrote in message
...
The Ctrl-Enter shortcut to enter today's date in a cell has stopped
working.
Is there a place to turn and off?

Office 2003 SP2




Gord Dibben

control enter
 
Dave

See Bernard's post for solution.

CTRL + ENTER is used to Fill the selected cell range with the current entry.

Handy for entering a range of incrementing formulas.


Gord Dibben MS Excel MVP


On Tue, 31 Oct 2006 05:41:02 -0800, Dave M <Dave
wrote:

The Ctrl-Enter shortcut to enter today's date in a cell has stopped working.
Is there a place to turn and off?

Office 2003 SP2




All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com