AutoFit column width and row height using a keyboard shortcut #exceltips #tutorial #shots #focusing

AutoFit column width and row height using a keyboard shortcut

Those of you who prefer working with the keyboard most of the time, may like the following way to auto fit in Excel:

Select any cell in the column/row you want to autofit:
To autofit multiple non-adjacent columns/rows, select one column or row and hold down the Ctrl key while selecting the other columns or rows.
To autofit the entire sheet, press Ctrl + A or click the Select All button.
Press one of the following keyboard shortcuts:
To AutoFit column width: Alt + H, then O, and then I
To AutoFit row height: Alt + H, then O, and then A

Please pay attention that you should not hit all the keys together, rather each key/key combination is pressed and released in turn:

Alt + H selects the Home tab on the ribbon.
O opens the Format menu.
I selects the AutoFit Column Width option.
A selects the AutoFit Row Height option.


#excelshortcut
#exceltips
#excelhack

#autofit
#keyboardshortcut
#productivity
#quicktip
#learnexcel
#exceltutorial
#shorts

Descriptive

#excelautofit
#columnwidth
#rowheight
#excelkeyboardshortcut
#exceltimeSaver
#exceltipsandtricks
#excelhelp
#exceltutorialshort
#excelforbeginners
#excelprotips

Engaging

#excelmagic
#excellifehack
#excelboost
#excelninja
#excelguru
#excelpoweruser
#excelisawesome
#excellover
#excelcommunity
#exceladdicted

Tags for Your YouTube Short

Here are some tags you can use for your YouTube Short:

excel autofit
excel keyboard shortcut
autofit column width
autofit row height
excel tips
excel tricks
excel tutorial
excel help
excel shortcut
excel productivity
learn excel
excel for beginners
excel for experts
excel time saver
excel hack