PressCtrl+Shift+:to enter the current time. PressCtrl+;for the current date. Note the shortcut enters thecurrenttime, not a formula. To put both the date and time in one cell, type either keystroke, a space, then the other keystroke. Excel will interpret it as the proper date and tim...
As mentioned earlier, Ctrl + Shift + L is the shortcut for freezing panes, and Ctrl + Shift + U is the shortcut for unfreezing. Other useful keyboard shortcuts include: Ctrl + Home: Move to the top-left cell of the worksheet Ctrl + End: Move to the bottom-right cell of the ...
Excel 2007 is useless. This was a shocking revelation when I tried to create the charts for last post (Chart Design: Abortion Ratios 1980-2003). It was my