Skip to main content
Search all of Office.com
Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
Repeat the value from the previous record
In a field in a record, you can insert the value that is in the same field in the previous record.
(Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.)
, or open a form in
(Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.)
Click in the field in which you want to insert the value.
Press CTRL+APOSTROPHE (').