insert the time
To insert the current time into the cell that is currently selected in Excel, simply press Ctrl + Shift + ; (semicolon)
This is the time as at the time of writing and it does not upadate.
Excel hints, Excel tips and Excel assistance
Excel Assist .co.uk
click a link to
buy me a beer
Recent Readers
Search This Site
Categories
Archives
- April 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- March 2010
- February 2010
- January 2010
- December 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- April 2009
- March 2009
- February 2009
- January 2009
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- 0
Pages
Recent Posts
- An easier way to flip FirstName LastName to LastName, FirstName
- Compare two lists
- Conditionally hide/unhide rows
- Excel Function Dictionary 150 example functions and formula.
- Function/Formula to Sum Excel Cells by Colour
- Adding Color to Excel 2007 Worksheets by Using the ColorIndex Property
- A1 and R1C1 Reference Style in Excel
- Deleting Unwanted Styles Microsoft Excel
- Excel password: Excel password remover
- Reverse Lookup | Chandoo.org – Learn Microsoft Excel Online
- Change cell formats with find-replace – simple excel trick that can save time | Chandoo.org – Learn Microsoft Excel Online
- Reduce File Size – MrExcel
- Dialog Box tip
- Get the month name in Excel
- Microsoft Excel Tips
Tag Cloud
addins
camera
cell content
cell function
consolidate
copy paste
countif
Ctrl+End
Ctrl+Home
cut and paste
dates
delete blanks
drag and drop
email
Excel
format
format date
functions
hint
hints
intro
keyboard shortcuts
lists
number format
numbers
offset
paste special
range name
shortcuts
spelling
style
substitute
subtotal
sum
sumif
tab name
text
text case
text format
text to columns
tips
trim
twitter
vba
web query
