Ctrl+D
With a single cell selected, copies format from cell above.

If doing a large range, select the cell to be copied AND the cells you want
to copy to.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"irishseawatcher" wrote:

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