Skip to main content

List of Microsoft Excel Keyboard Shortcut

Just as in other Microsoft Office Software,  in Microsoft Excel  if we want to work  faster or you don't like to use a mouse, then you can use keyboard to hit the shortcut key.
 
Bellow are list of shortcut keys for Ms Excel :
NoShortcutDescription
1      Ctrl + A      select all
2      Ctrl + B      make Bold 
3      Ctrl + I      make italic
4      Ctrl + K      insert link.
5      Ctrl + U      make under line
6      Ctrl + P      Show print dialog
7      Ctrl + Z      Undo
8       F2      Edit  selected cell
9       F5      Go to defined cell
10       Shift + F5      showing search form
11       F7      Check spelling
12       F11      making chart
13       Shift + F3      Insert function / formula
14      Ctrl + Shift + ;      Insert time (hour,min)
15      Ctrl + ;      insert date
16      Alt + Shift + F1      new worksheet
17      Ctrl + 5      strikethrough
18      Ctrl + F9      Minimize
19      Ctrl + F10      Maximize 
20      Ctrl + F6      Switch between opened excel
21      Ctrl + Page up      toggle beetwen Sheet to the left
22      Ctrl + Page down      toggle beetwen Sheet to the right
23      Ctrl + Tab      toggle beetwen opened  excel
24      Alt + =      add sum formula
25      Ctrl + '      inserting the value upside cell
26      Ctrl + Shift + !      Number in coma format
27      Ctrl + Shift + $      currency format
28      Ctrl + Shift + #      date formating
29      Ctrl + Shift + %      formating in percent
30      Ctrl + Shift + ^      format in scient
31      Ctrl + Shift + @      time formating
32      Ctrl + Arrow key        move to next text
33      Ctrl + Space      select all columb
34      Shift + Space      select all row.

Popular posts from this blog

How to Enable Hyper Terminal In Windows 7

Hyperterminal Windows 7. Windows 7 Hyperterminal. Hyper terminal is used for data communication via serial port com or TCP/IP Winsock. Unfortunately on Windows 7, Windows 8 and Windows 10 we can't see anymore, even though many of us who still need it, and it is not the solution if we have to go back to Windows XP. The solution :
Read more

Vaio stuck on loading screen after upgrading to Windows 10

My Sony Vaio laptop model : VPCCA16FB with originally using Windows 7 operating system, then now I already upgraded it to Windows 10. All drivers are already installed for each device, everything is OK with this Windows 10 OS. The only problem is:  when I switch the laptop on or restarting it, after vaio logo appears then it stuck with blank screen and it takes about 2 minutes. After that, then it continues to loading Windows. After I googling about the problem, I am not only the one, other people also have the similar problem with their laptops. The cause is in the Ultra Low Power State (ULPS) system. ULPS is a feature or mode in hardware (graphics card) designed to save power by reducing energy consumption to very low levels. Now the problem is solved. If you have the same or similar problem, maybe this below step will help you too.
Post a Comment
Read more

How to deny access to a drive in Windows 10

How to disable access to drives in Windows.  One of ways to  make disable access to drives in Windows (all Windows, Windows 10, Windows 8, Windows 7, also Windows server.. ), you can use Group policy editor . Below are  the steps: 1. Press Windows + R  (to open Run command ), write gpedit.msc at Run column, then hit Enter or click OK.
Read more