Microsoft Office Tutorials and References
In Depth Information
Date-Stamp or Time-Stamp Using Ctrl+; or Ctrl+:
Date-Stamp or Time-Stamp Using Ctrl+; or Ctrl+:
Here is an easy way to remember this shortcut. What time is it right now? It is
11:21 here. There is a colon in the time. Press Ctrl+Colon to enter the current
time in the active cell.
Need the current date? Same keystroke, minus the Shift key. Pressing
Ctrl+Semicolon enters the current time.
Note that this is not the same as using =NOW() or =TODAY(). Those functions
change over time. These shortcuts mark the time or date that you pressed the
key and the value does not change.
Repeating the Last Task with F4
Repeating the Last Task with F4
Say that you just selected a cell and did Home, Delete, Delete Cells, Delete
Entire Row, OK. You need to delete 24 more rows in various spots throughout
your data set.
Select a cell in the next row to delete and press F4, which repeats the last
command but on the currently selected cell.
Select a cell in the next row to delete and press F4. Before you know it, all
the 24 rows are deleted without you having to click on Home, Delete, Delete
Cells, Delete Entire Row, OK 24 times.
The F4 key works with 92% of the commands you will use. Try it. You ll
love it. It ll be obvious when you try to use one of the unusual commands
that cannot be redone with F4.
Adding Dollar Signs to a Reference with F4
Adding Dollar Signs to a Reference with F4
That s right two of my favorites in a row use F4. When you are entering a
formula and you need to change A1 to $A$1, click F4 while the insertion point
is touching A1. You can press F4 again to freeze only the row with A$1. Press
F4 again to freeze the column with $A1. Press again to toggle back to A1.
Finding the One Thing That Takes You Too Much Time
Finding the One Thing That Takes You Too Much Time
The shortcuts in this section are the ones I learned over the course of 20
years. They were all for tasks that I had to do repeatedly. In your job,
watch for any tasks you are doing over and over, especially things that
take several mouse clicks. When you identify one, try to find a shortcut key
that will save you time.
Search JabSto ::




Custom Search