Pasting To Multiple Cells - Help Please

[slick]

How do I paste to multiple cells in access 2007? Basically I want to copy one
cell in the dataview and then highlight maybe 10 cells and copy the info from the one cell into the highlighted 10 cells at one time. I had no problem doing this with 2003 but in 2007 this seems to be an issue. Any help is appreciated!

 

[Pat Hartman]

Despite what datasheets look like, they are not spreadsheets. Do not expect them to act like spreadsheets. There is no such thing as a cell in a table. The Cell is a spreadsheet concept.

This requirement to copy groups of columns and paste them elsewhere implies a flawed table design. Just importing a spreadsheet into a database, doesn't make it a table. It may still be a spreadsheet in its data content.