alternative to Drag and Drop for "identity" copying cells?
hi all.
right now when i want an "identity copy" of a single cell i do an equation where i enter the equals size and i click in the cell i need. this maintains a link with the original cell.
right now i need multiple cells (like five in a row) to get "identity copied" to a set of five new destination cells.
is there a way to do this so that i don't have to /drag/ the origination selection all the way down my spreadsheet or is this the only way to do it?
i have about 800 rows to travel and i have to do this about thirty times and it is going to get really tiresome.
i tried copy paste but it just entered five cells with "0.00" for some reason likely having to do with it being a copy of the format of the cell but not the actual content...
TIA for any advice or terms or search words etc
MacBook Pro, OS X Mavericks (10.9)