Most Amazing Excel shortcuts Using ,ALT Buttom

Dear viewers,
Today i am going to tell you about excel shortcut key with ALT tab of keyboard ,hope it will really help you to make your life easier.

Alt-------- To vie all tab
ALT+I+R----Row
ALT+I+C----Column
ALT+O+D------ Conditional formatting rules Manager 
ALT+O+E-------- Format Cell
ALT+D+L------- Data Validation
ALT+H+B+T----Outside bold border
ALT+H+A+L----Align Left


ALT+H+A+R----Align Right
ALT+H+A+T----Align top
ALT+H+A+B----Align Bottom
ALT+H+A+C----Align Center
ALT+H+A+M----Align Middle'
ALT+H+F+C----Font Color
ALT+H+F+S----Font Size

ALT+H+M+M----Merge cells
ALT+H+M+U----Unmerge cells
ALT+H+M+C----Merge & Center
ALT+H+M+A----Merge Across
ALT+H+B+O----Bottom border
ALT+H+B+A----All thin border
ALT+H+B+P----Top Border
ALT+H+B+R----Right Border
ALT+H+B+N----No border
ALT+H+O+A----format-- Auto height row
ALT+H+O+I----format-- Auto width column
ALT + = ---- Auto sum
ALT+D+f+F----Filter
AlT+D+E+E---- Deliminate (after after any sign)
Alt+E+S+V----first copy cell then(Paste special ,where V =to paste value only)
ALt+E+S+T-----first copy cell then(Paste special ,where t =to paste Format only) and many more.
Alt +'------ format style dialog box
Alt + ;----- select the visible cells in the current selection
Alt + Down arrow ---- Display auto complete list
Alt + Enter ---- Start a new line in the same cell
Alt+ F1 ----- Insert Chart
Alt + F2---- save as
Alt + F4--- Exit
Alt+F8--- Macro dialouge box
Alt + F11---Visual basic editor
Alt + Shift + F1--- New work sheet
Alt + Shift + F21--- Save



Post a Comment

0 Comments