IBPS Eg

IBPS Eg

Friday, 19 December 2014

Microsoft Excel Shortcut keys 3

Ctrl+Tab = move b/w two or more open excel files

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

Ctrl+' = Insert the value of the above cell into cell currently selected

Ctrl+Shift+! = Format numbger in comma format

Ctrl+Shift+$ = Format numbger in currently format

Ctrl+Shift+# = Format numbger in date format

Ctrl+Shift+% = Format numbger in percentage format

Ctrl+Shift+^ = Format numbger in scientfic format

Ctrl+Shift+@ = Format numbger in time format

Ctrl+Arrow key = Move to next section of text

Ctrl+Space = Select entire colmn

Shift+Space = select entire row

No comments:

Post a Comment