A To Z Excel Shortcut Online Test Series 5626

Open VBA

Apply % Format on Cells

Hide Selected Column

Duplicate Same Data in Selected All Cells

Remove Border – Ctrl + Shift + _

To Add Cells/Row/Columns

Edit Cell

VBA Code To Auto Fit Column

To Merge Across/Columns Only

Enable/Disable Filter

Hide Selected Row

To Sort Data in Ascending – Alt+H+S+S

Goto Next Sheet

Insert Hyperlink – Ctrl+L

To Create New Sheet

To Group

Apply Border – Ctrl + Shift + &

Show Hidden Column

Select Row

Correct Custom Format to Insert Mr. and Ji

Apply Date Format on Cells

Open Record Macro

To Create Pivot Table

Shortcut Key To Chart on Chart Sheet in Excel?

To Wrap Text (Break Text to Next Line)

Type Align Center Shortcut Key

To Ungroup

Apply Currency Format on Cells

Open Recorded Macro – Alt + F8

Convert Cells Into General Format – Ctrl + Shift + ~

To Merge and Center

To Auto Column Fit

Open Cell Format

Shortcut Key To Create Chart in Current Sheet?

Apply Formula in Below Selected Cells

To Show Formula at Sheets

Select Column

To Transpose (Paste Column into Row or Row into Column)

Type Shortcut Key for – Auto Sum

To Apply Border All Sides

Insert Current Time – Ctrl + Shift + :

Show Hidden Row

To Paste Value

Apply Strikethrough

Craete Table

Goto Previous Sheet

To Zoom In

To Zoom Out

To Remove Cells/Row/Columns

Insert Current Date