Monday, January 18, 2010

Inserting Current Date & Time

Here is the shortcut for entering Current Date in Selected Cell

=Ctrl+

And to Insert Current Time it will be

=Ctrl+Shift++
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Hi Friends, After a long break, I again started to work on this blog with new time-saving techniques and tricks for making the day to day...

  • Multiple Row Filters in Same Sheet
    I was working on my data sheet and countered with one problem I required filters in two row ranges on being specific I want the first fil...
  • Tips to look more profession in Excel
    Excel provides several underline formats to give your spreadsheets a professional look and to make them easier to read at a glance. For exam...
  • Remove Non Printable Items from Text
    To Remove None Printable items from the cell containing text we just have to use a simple formula =Clean(Cell number) For Example In cel...