A few words of thanks would be greatly appreciated.

Shortcuts For Inserting Data Into Excel Documents

Excel documents serve a multitude of functions and can be invaluable. They are however sometimes difficult to manipulate, especially if you want to insert a lot of information or edit numerous columns etc. Luckily there are keyboard shortcuts that one can use to format the Excel document to your specific requirements, making data entry much quicker. In this article we'll provide shortcuts to insert names, functions or data.

How to Insert a Name

CTRL + SHIFT + F3 : Create names automatically from the labels of rows and (or) columns
CTRL + F3 : Set a name to a cell range
F3 : To paste a predefined name

How to Insert a Function

ALT + = : Allows you to insert a Sum formula automatically
SHIFT + F3 : Allows you to insert a function into a cell using the wizard function
CTRL + SHIFT + ENTER : To enter a formula in matrix form
CTRL + A : After typing the function name, the wizard displays the function in question
CTRL + SHIFT + A : After you type the name of the function, lets you add the necessary arguments for the creation of the office and the necessary brackets

Shortcuts For Inserting data

CTRL + K : You can insert a hyperlink
CTRL +, (comma): Inserts the current date
CTRL +: (colon): Inserts the current time
CTRL + ENTER : Used to insert data in all selected cells
CTRL + DELETE : Delete all text to the right of entry cursor
ALT + ENTER : To enter a new line in the same cell (wrap in a cell)
ALT + Down Arrow : Display the list of AutoComplete
SHIFT + F2 : Allows you to add or edit a cell comment

Image © Kaspars Grinvalds - 123rf.com


A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Shortcuts For Inserting Data Into Excel Documents », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).