| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keyboard keys to plug in today's date?
Good afternoon!
I can't believe I've never asked this before <g! Is there a keystroke combination that we can use that when pressed will put today's date into a cell? I have a number of sheets I update each day re correspondence so finding a quick way to enter the current date would be fantastic! Thank you! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Keyboard keys to plug in today's date?
ctrl;
Hold down the control key and press the semi-colon "Bridget" wrote in message ... Good afternoon! I can't believe I've never asked this before <g! Is there a keystroke combination that we can use that when pressed will put today's date into a cell? I have a number of sheets I update each day re correspondence so finding a quick way to enter the current date would be fantastic! Thank you! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Keyboard keys to plug in today's date?
Whoa...that was cool!
-- Toby Erkson Oregon, USA Excel 2002 in Windows XP "Dayton" wrote in message ... ctrl; Hold down the control key and press the semi-colon |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Keyboard keys to plug in today's date?
That did it! Thanks!
-----Original Message----- ctrl; Hold down the control key and press the semi-colon "Bridget" wrote in message ... Good afternoon! I can't believe I've never asked this before <g! Is there a keystroke combination that we can use that when pressed will put today's date into a cell? I have a number of sheets I update each day re correspondence so finding a quick way to enter the current date would be fantastic! Thank you! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Keyboard keys to plug in today's date?
Hi Bridget
You have your answer already but See this webpage's for more shortcuts http://www.cpearson.com/excel/ShortCuts.htm http://www.contextures.com/excel.htm http://www.contextures.com/excel.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Bridget" wrote in message ... Good afternoon! I can't believe I've never asked this before <g! Is there a keystroke combination that we can use that when pressed will put today's date into a cell? I have a number of sheets I update each day re correspondence so finding a quick way to enter the current date would be fantastic! Thank you! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Keyboard keys to plug in today's date?
actually my page on keyboard shortcuts is
http://www.mvps.org/dmcritchie/excel/shortx2k.htm the page referred to was my home page. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Keyboard keys to plug in today's date?
Hi David
Thanks I must clean my keyboard<g -- Regards Ron de Bruin http://www.rondebruin.nl "David McRitchie" wrote in message ... actually my page on keyboard shortcuts is http://www.mvps.org/dmcritchie/excel/shortx2k.htm the page referred to was my home page. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What keyboard keys for to increse font size? | Excel Discussion (Misc queries) | |||
| Disabling certain keys on keyboard | Excel Discussion (Misc queries) | |||
| keyboard shortcut keys | Setting up and Configuration of Excel | |||
| Keyboard arrow keys | Excel Discussion (Misc queries) | |||
| some keys locked on keyboard. How do I unlock it? | Excel Discussion (Misc queries) | |||
![Bridget[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
