June 2004

Shortcuts in Microsoft Excel

By Teresa Lightle- Technology Coordinator                            Printable Version (pdf)

A few months ago I did a table on shortcuts in Internet Explorer - I have had several requests to do the same for MS Excel:

Ctrl + Z	Undo
Ctrl + F4	Close the current workbook
Ctrl + A	Select all cells in the worksheet
Ctrl + N	Open new workbook
Shift + F11	Insert new worksheet
Shift + F3	Open the Past Function
Ctrl + Spacebar	Select Column
Shift + Spacebar	Select Column
Ctrl + 1	Format Cells
Ctrl + ; (semicolon)	Insert current date
Ctrl + : (colon)	Insert current time
Ctrl + F3	Name range
Ctrl + Page Down	Move to next worksheet
Ctrl + Page Up	Move to previous worksheet
Ctrl + home	Return to beginning of worksheet
Ctrl + Shift + O (letter O)	Select all cells which contain comments
Alt + Enter	Start a new line in the same cell
Shift + Tab	Complete the entry and move one cell left
Ctrl + K	Insert a hyperlink
F7	Run the spell-check
F5	Go to

For more information on using Shortcut keys in any MS Office program, press the F1 button on the keyboard, this will launch the Help menu. Type Keyboard Shortcuts and search.

Many users will be taking vacation this summer. Before you leave, take some time to archive your Outlook folders (see December 2003 Tech Tip), turn on your Out of Office Assistant (see January 2002 Tech Tip) and backup your files.

Have a great summer!

---

For Questions or Comments about this newsletter please contact: tlightle@bcoe.org

Back to Tech Tip Main Page