Forum Discussion

Vinod_Sir's avatar
Vinod_Sir
Copper Contributor
Oct 06, 2024

CTRL + Enter in Excel for data entry

Quick tip to use CTRL + Enter which will help to get similar value on rest of the other space meaning I have 2024 want to paste that A1 to A10 instead of copy and paste simply select range from A1 to A10 in blank type 2024 and press CTRL + Enter and get all values pasted from the A1 to A10 you can see magic :sparkles: 🪄 🪄 

copilot in excel
excel
Excel for web
Excel on mobile
office 365

2 Replies

Sort By
  • ParkerReed's avatar
    ParkerReed
    Iron Contributor
    Mar 26, 2025

    If you type 2024 in A1 and then select A1 to A10 and press Ctrl + Enter, all the selected cells (A1, A2, A3, ..., A10) will now all contain the value 2024.

  • DashiellReed's avatar
    DashiellReed
    Iron Contributor
    Mar 21, 2025

    You have a new project starting in 2024, and you want to mark this in your Excel sheet for multiple tasks or reminders. Instead of clicking into each cell to type the year, just follow the steps above, and you’ll have the year filled in all at once!

Resources