View Single Post
  #29   Report Post  
Posted to microsoft.public.excel.misc
Terry Pinnell[_4_] Terry Pinnell[_4_] is offline
external usenet poster
 
Posts: 192
Default Customising date format

Terry Pinnell wrote:

I was just about to attempt doing so to get fast access
to the frequently used Format Painter. (Is there an assigned hotkey
for it that I've not yet found, BTW?)


OK, sorted that point. Found this reasonably fast sequence of KB
shortcuts:

1. In source cell(s) Press Ctrl+C.
2. Select target cell(s) Press Shift+F10, S, R.

--
Terry, East Grinstead, UK