Typing and Editing Cell Data

[ LiB ]

Typing and Editing Cell Data

When you are typing data, you can save time with these shortcut keys:

To execute this command

Do this

Edit the current cell

Press F2

Start a new formula

Press = (equal sign)

Start an AutoSum formula

Press Alt+=(equal sign)

Start a new line in the same cell

Press Alt+Enter

Insert today's date

Press Ctrl+' (apostrophe)

Insert the current time

Press Ctrl+Shift+: ( colon )

Cancel typing entry

Press Esc

Undo the last action

Press Ctrl+Z

Repeat last action

Press Ctrl+Y

Cut

Press Ctrl+X

Copy

Press Ctrl+C

Paste

Press Ctrl+V

Clear cell contents

Press Delete

Delete the selected cells

Press Ctrl+- (hyphen)

Insert blank cells.

Press Ctrl+Shift++ (plus sign)

Insert a hyperlink

Press Ctrl+K

Fill down

Press Ctrl+D

Fill right

Press Ctrl+R

Insert a new worksheet

Press Shift+F11


[ LiB ]


Microsoft Office Excel 2003 Fast & Easy
Windows XP Registry: A Complete Guide to Customizing and Optimizing Windows XP (Information Technologies Master Series)
ISBN: N/A
EAN: 2147483647
Year: 2002
Pages: 157
Authors: Olga Kokoreva

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net