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!

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.