Populating a table with value from cell above across multiple columns

[Access_Novice]

Doing Ctrl + ' will put in the value from the cell above it. But I want to do this across 4 columns. On one row, I am selecting across 4 columns and doing Ctrl + ' and only the first cell populates with the value above it.

Is there a way to get the 3 other columns to populate with the value of them (the values are different across all columns).

[June7]

Never heard of Ctrl+ in Access. Are you working with an Excel spreadsheet?

[ssanfu]

Ctrl + ' is on a per field basis. One field (not cell) at a time. While a form in Datasheet view may look like an Excel spreadsheet, they are two totally different animals.

You could write code to copy data from the row above for 4 fields - if this is this an ongoing thing.

(Group 3, Insert Data
http://www.shortcutworld.com/en/win/Access_2010.html)