Excel 2016

Handy Excel Data Entry Shortcuts

For most folks entering content into an Excel worksheet is a common task. Below are keyboard shortcuts that will automate some of these chores. You may know some of them, but I bet you will find some that you were not aware of!

CTRL + K – Insert a hyperlink

CTRL + ; – Insert the current date

CTRL + : – Insert the current time

CTRL + Enter – Enter a value into non-contiguous cells

ALT + Enter – Wrap text to a new line in the same cell

ALT + Down Arrow – Display AutoComplete list

Shift + F2 – Insert comment

ALT + = – Insert autosum function

Shift + F3 – Launch Insert Function wizard

CTRL + Shift + A – Complete function by inserting argument

CTRL + Shift +F3 – Create names from labels in adjacent row and/or columns

CTRL + F3 – Launch Name Manager

F3 – Display Paste Name dialog

Hope these save you keystrokes and time!

One reply on “Handy Excel Data Entry Shortcuts”

Comments are closed.