Choose the Format button on the Home ribbon. You can auto-resize your rows and columns, specify the size, or reset to default ...

If you want to collapse, show, hide or unhide the Office Ribbon automatically in Word, Excel, and PowerPoint ... which includes some tabs like Home, Insert, Draw, Design, Layout, References ...