{"id":12144,"date":"2012-06-17T19:32:35","date_gmt":"2012-06-17T19:32:35","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1912"},"modified":"2022-08-17T19:29:09","modified_gmt":"2022-08-17T19:29:09","slug":"current-date-in-cell","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/06\/current-date-in-cell\/","title":{"rendered":"Excel Tips : Enter Current Date Without Typing in to the Cell [Static]"},"content":{"rendered":"
[et_pb_section fb_built=”1″ _builder_version=”4.16″ da_disable_devices=”off|off|off” global_colors_info=”{}” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n
Static<\/strong> changes are those which does not change by opening or refreshing the excel sheet. That means once a value is typed in then it will remain as is until you or the VBA code does not change it. Select the Cell and Press Ctrl + ; (semicolon) <\/strong><\/span><\/p>\n Select the Cell and Press Ctrl + Shift + ; (semicolon) <\/strong><\/span><\/p>\n Select the Cell and Press Ctrl + ; (semicolon)<\/span> then press space bar then press Ctrl + Shift + ; (semicolon) <\/span><\/p>\n \n Short Cut to Enter Current Date in Cell<\/p><\/div> [\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":" Shortcut key to type current date in excel cell [Static] Static changes are those which does not change by opening or refreshing the excel sheet. That means once a value is typed in then it will remain as is until you or the VBA code does not change it. If you want to enter the […]<\/p>\n","protected":false},"author":45,"featured_media":242484,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"
\nIf you want to enter the current date into a Cell then need not remember the Current Date or current time and Type it in the Cell. You Just Need to press the following shortcuts:
\n<\/p>\nTo enter current date in a cell<\/h3>\n
To enter current time in a cell<\/h3>\n
To enter current date and time both in a cell<\/h3>\n
\n[\/et_pb_text][et_pb_blurb title=”Suggested Tips:” _builder_version=”4.17.6″ _module_preset=”0249c68e-4de8-4f44-84ff-a9b1850785b6″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n\n
Shortcut key to type current date in excel cell [Static]<\/h1>\r\nStatic<\/strong> changes are those which does not change by opening or refreshing the excel sheet. That means once a value is typed in then it will remain as is until you or the VBA code does not change it. \r\nIf you want to enter the current date into a Cell then need not remember the Current Date or current time and Type it in the Cell. You Just Need to press following shortcuts:\r\n
\r\nTo enter current date in a cell<\/h3>\r\nSelect the Cell and Press Ctrl + ; (semicolon) <\/strong><\/span>\r\n\r\n
To enter current time in a cell<\/h3>\r\nSelect the Cell and Press Ctrl + Shift + ; (semicolon) <\/strong><\/span>\r\n\r\n
\r\n[caption id=\"attachment_242484\" align=\"aligncenter\" width=\"732\"] Short Cut to Enter Current Date in Cell[\/caption]\r\n
","_et_gb_content_width":"","footnotes":""},"categories":[1676],"tags":[],"class_list":["post-12144","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tips"],"yoast_head":"\n