Adding commands to the ribbon in excell 2013.. Highlighting the entire sheet

[HughTower]

Morning all.

I want to add a particular command to the excel ribbon ( I am using excel 2013).
Currently if I wish to highlight the entire sheet, I move my cursor to the far left upper corner.

IS there a command that I could place in the ribbon to achieve the above task ?

[humdingaling]

you can press ctrl +A twice to achieve this

Ctrl+A

Selects the entire worksheet.

If the worksheet contains data, Ctrl+A selects the current region. Pressing Ctrl+A a second time selects the entire worksheet.
https://support.office.com/en-au/art...8-f238bf953ba6

[HughTower]

Thank you for the answer. But I actually want a command IN The RIbbon that I can click on , if possible.

[humdingaling]

the one in excel is broken

if you really need a button there to click you can create a add-in using vba and put it on the ribbon

[HughTower]

Thank you .I will create a an add in command.

Regards

(Ps well done with the world cup cricket)

[humdingaling]

cant believe you guys lost to the kiwi's

[Andy Pope]

Surely it's easier to press the select all button top left of sheet that hunt down a new control in the ribbon?

1079046.png

If you use a personal.xlsm you could write a macro and assign button to QAT