Quick Current Date and Time in Excel

Excel-Quick-Date-Time

  • To enter Current Date in a cell Press Ctrl+; (semicolon ) it will inserts Current Date in your current Cell.
  • To enter Current Time  in a cell Press Ctrl+Shift+: (colon ) it will inserts Current Time in your current Cell.

Know you know, how to insert Current Date and Time Microsoft Excel, next time when need to insert Current Date and Time in any cell of worksheet and format the cell for Date and Time as like try these Keyboard Shortcuts.

This works in almost all the Excel versions.

Enjoy Microsoft Excel.

ILYAS QASIM

Windows 7 Taskbar Icons Keyboard Shortcuts

To open quick launch applications through shortcut keys, simply hold down the Windows key and press the number on the keyboard that corresponds with the icon, working from the Start  button to the right. For example, if Internet Explorer is the first icon, press Windows-1 to open IE, more switching between icons and launch it quickly.

ENJOY!

Published in: on October 5, 2014 at 11:36 pm  Leave a Comment  
Tags: , , , , ,

Microsoft Excel Function Keys Shortcuts!

Most of the user know at least a handful of shortcuts for Microsoft Excel. However, an entire row of function keys shortcut  is often neglected and even unknown to users. We are talking about the Function keys  that  they just do not get enough attention from users of Microsoft Excel.

So let’s talk about Microsoft  Excel Function Keys, from left to right.

  1. F1 by itself opens the Help task pane.
  2. Ctrl+F1 shows or hides the Ribbon newer versions of Excel.
  3. Alt+F1 will create a quick chart using data that is selected.
  4. Alt+Shift+F1 inserts a brand new worksheet/macro sheet.
  5. F2 moves the cursor to the end of the selected cell (edit cell mode).
  6. Ctrl+F2 shows  Print Preview Window.
  7. Alt+F2 brings up the Save As dialog.
  8. Shift+F2 adds a comment.
  9. F3 opens the Paste Name box.
  10. Shift+F3 is a quick way to insert a function.
  11. Ctrl+F3 brings up the Name Manager dialog.
  12. Ctrl+Alt+F3 brings up the New Name dialog.
  13. Ctrl+Shift+F3 brings up the Create Names dialog.
  14. F4  repeats your last action.
  15. Ctrl+F4 closes your window.
  16. Shift+F4 Move you to Firs Cell A1.
  17. F5 opens the Go To dialog.
  18. Ctrl+F5 restores the window size.
  19. Shift+F5 Brings up Find and Replace dialog.
  20. F6 switches to the task pane or second window.
  21. Ctrl+F6 switches between workbooks.
  22. F7 brings up Spell Check.
  23. Shift+F7 opens the Research pane.
  24. F8 turns on (or off) extended mode.
  25. Shift+F8 allows you to add another range of cells to the selection.
  26. Alt+F8 brings up Macro dialog.
  27. F9 calculates all open workbooks.
  28. Shift+F9 calculates the active worksheet.
  29. Ctrl+F9 minimizes workbooks.
  30. F10 turns key tips on or off.
  31. Ctrl+F10 maximizes or restores the window.
  32. Shift+F10 brings up Shortcut Menu.
  33. F11  creates an instant chart.
  34. Ctrl+F11  creates an instant Macro Sheet.
  35. Alt+F11  opens Microsoft VBA Window.
  36. Shift+F11  insert new worksheet in current workbook.
  37. F12 brings up the Save As dialog.
  38. Shift+F12 for the Save window.
  39. Ctrl+F12 opens theOpen dialog.
  40. Ctrl+Shift+F12 brings the Print dialog.
That’s all for Today, and keep in mind some of the shortcuts also works in other Microsoft Office programs too, other shortcuts will be published soon!
ILYAS QASIM

Internet Explorer 9 Shortcut Keys

We all know that keyboard shortcuts make operating programs quicker, thats why we presenting Internet Explorer 9 shortcuts to make your browsing smooth!

Ctrl + +  (plus sign) – Zoom in a webpage

Ctrl + –  (minus sign) – Zoom out in a webpage
Ctrl + o  – Open a webpage
Ctrl + S – Save a web page for offline viewing.
Ctrl + Shift + Tab – Move back through tabs
Ctrl + Tab – Move forward through tabs.
Ctrl + T – Opens a new browser tab
Ctrl + w – Closes the current browser tab.
Ctrl + K – Copies the current browser tab and opens it.
Ctrl + N – Open a new Internet Explorer window.
Ctrl + J – Opens the Internet Explorer Download Manager.
Ctrl + L – Select the address bar so that you can type in a new address.
Ctrl + B – organize your Internet Explorer favorites.
Ctrl + D – Can be used to bookmark a webpage or add it to your Internet explorer favorites.

Power Tips N Tricks

%d bloggers like this: