Microsoft Excel; Insert the current date or time or both, with a keyboard shortcut.
Пікірлер: 13
@Diamond.tricks9 ай бұрын
Learn so many tricks from your channel 😊
@ApexTrainingLLC9 ай бұрын
Happy to hear that! Thank you for the feedback! Please tell your friends! :-)
@Diamond.tricks9 ай бұрын
Thanku so much sir 😊😊
@carln4406 Жыл бұрын
I tried it but it doesn't work. I don't know what's going on.
@ApexTrainingLLC8 ай бұрын
Hello Carin. Which part are you having trouble with?
@Christina-fc7ulАй бұрын
Could you please show us how to formulate a cell to show time - many times I have time data shown like 45678 - and it is so annoying to change from the top bar every time do you know how we can have a keyboard shortcut to fix it
@ApexTrainingLLCАй бұрын
Hi Christina. Thank you for your inquiry. You can use the shortcut key combination of CTRL + SHIFT + 3 to apply date formatting in the format dd-mmm-yy. To apply a the short date format, you can right-click the menu choice for short date from the ribbon, then choose to add it to your quick access toolbar. Any icon on the quick access toolbar can be selected by pressing the Alt key, + the number that is the position of the icon on the toolbar. So if it is the 5th icon on your quick access toolbar, you would press Alt+5. I will make a video showing this process.