List for Bank Online Aptitude Tests for MS Excel Shortcut keys

List for Bank Online Aptitude Tests for MS Excel Shortcut keys

F2 Edit the selected cell

F3 After a name has been created F3 will paste names

F5 Go to a specific cell. For example, C6

F7 Spell check selected text or document

F11 Create chart from selected data



Ctrl + Shift + ; Enter the current time

Ctrl + ; Enter the current date

Alt + Shift + F1 Insert new worksheet

Shift + F3 Open the Excel formula window

Shift + F5 Bring up search box

Ctrl + A Select all contents of the worksheet

Ctrl + B Bold highlighted section

Ctrl + I Italic highlighted section

Ctrl + K Insert link

Ctrl + U Underline highlighted section

Ctrl + 1 Change the format of selected cells

Ctrl + 5 Strike through highlighted section

Ctrl + P Bring up the print dialogue box to begin printing

Ctrl + Z Undo last action

Ctrl + F3 Open Excel Name Manager

Ctrl + F9 Minimize current window

Ctrl + F10 Maximize currently selected window

Ctrl + F6 Switch between open work books or windows

Ctrl + Page up Move between Excel work sheets in the same Excel document

Ctrl + page down Move between Excel worksheets in the same Excel document

Ctrl + Tab Move between two or more open Excel document

Alt + = Create a formula to sum all of the above cells

Ctrl + ’ Insert the value of the above cell into cell currently selected

Ctrl + Shift + ! Format number in comma format



Ctrl + Shift + $ Format number in currency format

Ctrl + Shift + # Format number in date format

Ctrl + Shift + % Format number in percentage format

Ctrl + Shift + ^ Format number in scientific format

Ctrl + Shift + @ Format number in time format

Ctrl + Arrow key Move to the next selection on text

Ctrl + Space Select entire column

Shift + Space Select entire row

Ctrl + - Delete the selected column or row

Ctrl + shift + = Insert a new column or row

Ctrl + Home Move to cell A1

Ctrl + ~ Switch between showing Excel formulas or their values in cells