{"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
\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