Formatting while inserting Rows

[LostinExcelHelp]

I am inserting rows with Ctrl+Shift++

Then the format painter icon hovers and i can click on it to choose whether i want ‘format same as above’ and ‘format same as below’.

I want to choose that format painter with a keyboard shortcut instead of a mouse click. Is it possible?

 

[JerrExcel]

Hi LostinExcelHelp

Do you know about VBA?
I propose to use Record Macro to get what you desired. Go to excel, save the excel as xlsm (macro-enabled), go to Developer tab, click Record Macro. Then do whatever your procedure required.
Then check out the code in the VBA script - Module1. You edit the code as you like.

Below is what I get when doing the row insertion + 'format same as above'

Sub FormatasAbove()

ActiveCell.EntireRow.Select
    Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove

End Sub

To make this macro auto-run on keyboard shortcut, please click Macros, or press Alt+F8

Then select the macro name and choose option:

Then choose a keyboard shortcut: (Note: All the Ctrl shortcuts are occupied. You can use Ctrl + Shift + your alpha character. Just press the Shift key when you click into that tiny box)

Hope this helped.
Thanks

 

[LostinExcelHelp]

Hi, thanks for the detailed suggestion! I was wondering if there’s any shortcut to it instead of having to use macros!

 

[MARK858]

Press ALT, H, F, and P takes you to the regular format painter but I don't think you can get the format from above from there