Go Home Early
Volume 4, No. 11
Too much to do in your eight-hour workday? Spending too much time on the job? Incorporate shortcuts into your routines; be able to spend more time at the beach or in the mountains. Here are a few key combinations to commit to memory when using Microsoft products: Excel and Word.
EXCEL 2007 – with curser active in a cell use the following key combinations to :
--Enter current date |
Control / ; |
--Enter current time |
Shift /: |
--Move to last cell on worksheet |
Control/End key |
--Extend selection to last cell on worksheet |
Control/Shift/End key |
--Fill selected cell range with current entry |
Control/Enter |
--Select entire column |
Control/Spacebar |
--Select entire row |
Shift/Spacebar |
--Hide selected row(s) |
Control/9 |
--Unhide hidden row(s) |
Control/Shift/( |
--Hide selected columns(s) |
Control/0 |
--Unhide selected column(s) |
Control/Shift/) |
WORD 2007 –add special characters by using the following key combinations to insert :
--Line break |
Shift/Enter |
--Page break |
Control/Enter |
--Column break |
Control/Shift/Enter |
--Nonbreaking hyphen |
Control/Shift/- |
--Nonbreaking space |
Control/Shift/spacebar |
--Copyright symbol |
Alt/Control/C |
--Registered trademark symbol |
Alt/Control/R |
--An ellipsis |
Alt/Control/. |
--Print preview |
Alt/Control/i |
--Print document |
Control/p |
--Close document |
Control/w |
For more shortcuts checkout the ISSInfo handouts at:
Excel: http://www.callutheran.edu/iss/training/documents/Shortcuts_Excel.pdf
Word: http://www.callutheran.edu/iss/training/documents/2007ShortcutsWord.pdf
And now for going home early part? Just kidding.
*This Issue’s Techno Term:
Term: gateway
Definition: hardware or software that acts as a bridge between two networks so data can be transferred between multiple computers
Example in a sentence: When an email message is transmitted, it may pass through several gateways before arriving in the recipient’s inbox.
Source: http://www.techterms.com/definition/gateway
If you have questions or need assistance, please call the Help Desk at (805) 493-3698 or send e-mail to helpdesk@callutheran.edu
Additional information is available at the Computer Training Website; in addition, an archive of previous Tech Bytes issues is located at http://www.callutheran.edu/iss/training/tech_bytes/