View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
irishseawatcher irishseawatcher is offline
external usenet poster
 
Posts: 1
Default Is there a one button shortcut for "copy cell above & paste here"

I have large data entry spreadsheets (10-20 columns) often with one or two
cells duplicated in the next row down.
Is there a shortcut key which will effectively act as "ditto" and enter the
value & format from the cell above?
Can I MAKE a short-cut key to do this?
copy/paste and autofill by mouse take too long