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! |
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! |
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 |
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! |
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! |
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 |
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 |
All times are GMT +1. The time now is 10:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com