Question

shortcut key for format painter

Answer 1

Excel doesn't provide a single short key,you can use any one of these.Use these if u are using MS Excel 2007

1.Select the cell from which format  is to be copied.
2.Press Ctrl +C. this copies the cell to the clipboard.
3.Select the cell to receive the format.
4.Press Shift+F10, S, T ,Enter. This sequence displays the paste special         dialog box and chooses to paste only the format.

             If u are using Excel 2010 and Excel 2013 follow these                      1.Select the cell from which format is to be copied                                          2.Press Ctrl+C, this copies the cell to the clipboard.                                      3.Select the cells to receive the format.                                                          4.Press Shift+F10 , S ,R. This sequence displays the context menu and          select the options to paste just formatting.