Shortcuts that dramatically accelerate data entry into spreadsheets with date/time insertion and copy-paste operations

Ctrl+C

Copy

Copies the selected cells.

💡 Hint: Copy

🎯 Copy selected cell range to clipboard for instant data duplication

Ctrl+V

Paste

Pastes the clipboard contents.

💡 Hint: V

🎯 Paste clipboard contents for efficient data entry

Ctrl+Shift+V

Paste values only

Pastes only values without formatting.

💡 Hint: Values

🎯 Paste only values without formatting for pure data transfer

Ctrl+D

Fill down

Copies the cell above into the cell below.

💡 Hint: Down

🎯 Copy cell above downward to accelerate continuous data entry

Ctrl+R

Fill right

Copies the cell on the left into the cell on the right.

💡 Hint: Right

🎯 Copy cell to the left rightward to streamline horizontal data entry

Ctrl+Enter

Fill range

Copies the current cell's contents into the selected range.

💡 Hint: Range

🎯 Copy current cell content to entire selected range for bulk data entry

Ctrl+;

Insert date

Inserts the current date into the cell.

💡 Hint: ; date

🎯 Instantly insert current date to streamline date data entry

Ctrl+Shift+;

Insert time

Inserts the current time into the cell.

💡 Hint: ; time

🎯 Instantly insert current time to streamline time data entry

Ctrl+Alt+Shift+;

Insert date and time

Inserts the current date and time into the cell.

💡 Hint: ; date/time

🎯 Insert current date and time simultaneously for rapid timestamp entry

Google Sheets