Excel Shortcut: Enter Same Data in Multiple Cells

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:

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top