|
Below is a listing of various tips that can be used
Microsoft Excel. Some of the below tips may list a
date next to them for the month and year that they were
featured in our monthly tip
section.
Auto sum shortcut key (11/2005)
Create hyper links in Excel. (11/2003)
Close all open files at once. (8/2003)
Quickly open recently opened files. (6/2003)
Create underlines without any text. (3/2003)
Print only sections of a document. (8/2002)
Repeat recent action (7/2002)
Quickly undo (9/2001)
Quickly copy above cell contents (12/2000)
Using the Microsoft Excel Auto filter (07/2000)
Microsoft Excel Shortcuts
Back to tips main page
Auto sum shortcut key (11/2005)
Quickly create a
Microsoft
Excel
formula
to get the sum
of all cells
by highlighting the cells you wish to know the value of and pressing
ALT
and = .
Create hyper links in Excel
Quickly create hyper links in your
Microsoft Word, Excel, or Front Page document by highlighting text
and pressing "CTRL + K".
Close all open files at
once
Close all open Microsoft
Word and/or
Excel
files by holding down the shift key and clicking
"File" and then "Close All".
Quickly
open recently opened files
Quickly open the recent files by
first pressing "ALT + F" to open the file Menu and press
1, 2, 3, or 4.
Create underlines without
any text
This tip works with the majority of
Microsoft
Office applications. Easily create an underlined space
by pressing CTRL + U to start the underline, then press
SHIFT + Space for each underlined space you wish to
create. An example of how this could be used is for
printable forms, for example: Name:
.
Print only sections
of a document
Save on your printer ink by selectively printing in Windows programs
such as Microsoft Word, Internet Explorer, WordPad, Outlook, etc. To do
this highlight
portions of text you wish to print and click print. In the printer
dialog window under Page Range choose the option Selection. It is
important to realize that not all programs or printer drivers support
this feature.
Repeat
recent action
Using the F4 key in Microsoft Office 2000 and above allows
the user to repeat the last used action. For example, if you
have changed the font of a selected text and wish to change
another portion of text to the same font, pressing F4 will do
this for you automatically.
Quickly undo
Quickly undo mistakes in the
majority of most PC Windows program by pressing CTRL + Z.
Quickly
above cell contents
In Microsoft Excel press CTRL
+ SHIFT + " to copy the above cells contents.
Using the Microsoft Excel Auto filter
Organize cells quickly by using Microsoft Auto filter.
Columns that contains long listing of data can be easily
sorted by using the Auto filter option, to use this option
select the top rows of the columns you want to be used and
select Data / Filter and Auto Filter. Once successfully
completed you can use drop down arrows to filter the data
automatically.
Back to tips home |
