Excel Shortcuts

Back to Excel Shortcuts

Excel Shortcut: Enter Same Data in Multiple Cells

Umesh Manral March 9, 2023 Excel Shortcuts

About This Shortcut

Enter Same Data in Multiple Cells (After Copying, Then Selecting Cells) – In spreadsheet software such as Microsoft Excel or Google Sheets, you can use the Enter key to quickly copy and paste the same data into multiple cells. This can be useful if you have a large dataset that contains the same information in multiple columns or rows.

Keybord Shortcut key

  • Window: Ctrl + Enter
  • Mac: Ctrl + Return

Example:

Back to Excel Shortcuts

Share
Umesh Manral

Automation Specialist & Consultant

Umesh Manral

I'm a passionate Excel expert with a decade of experience transforming complex data into actionable insights. My journey began when I discovered the power of Excel macros to automate tedious tasks during…

View author profile