Home » » List for Bank Online Aptitude Tests for MS Excel Shortcut keys

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




cyber security jobs,post jobs for free,jobs with a psychology degree,medical coding jobs, business administration jobs,hr interview questions and answers for freshers,hospitality management jobs, information technology jobs,data analyst job description,web design jobs,computer science jobs,cyber security jobs,post jobs for free,jobs with a psychology degree,medical coding jobs,
Share this article :

0 comments:

Post a Comment

 
Copyright © 2013. Freshers Job List - All Rights Reserved