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 :

How to Record Audio Directly to USB Flashdisk on Ashley Remix-802 Mixer

The Ashley Remix-802 mixer is an audio mixer that features direct recording to USB. However, the recording process might not be immediately intuitive since there isn't a clear "record" button. Here are the steps to record audio directly to USB on the Ashley Remix-802 mixer: Recording Steps:  1. Format the Flash Drive: Format your flash drive with the FAT32 file system using a laptop or computer. 2. Add an MP3 File: Insert at least one MP3 file into the flash drive. This is necessary for the mixer to read the flash drive and enable the recording process. 3. Plug in the Flash Drive: Plug the flash drive into the USB port on the Ashley Remix-802 mixer. If the flash drive is recognized, the mixer will start playing the MP3 file, and the display will show that music is playing. 4. Start Recording: Press and hold the Play/Pause button for a few seconds until the display shows "rec." This indicates that the recording process has started. 5. Stop Recording: To stop the ...

Enabling HyperTerminal on Windows 11

Hyper Terminal on Windows 11 Using HyperTerminal on Windows 11: A Solution for Data Communication Needs HyperTerminal is a useful application for data communication via serial COM port or TCP/IP Winsock. However, this application is no longer available on the latest Windows versions, including Windows 11. Many of us still need it to configure hardware devices such as switches, hubs, routers, NAS, and others. The Problem and Solution Many hardware devices still use configuration via serial COM port, despite significant advancements in technology.  If you still need HyperTerminal on Windows 11, you don't have to downgrade to Windows XP. I have prepared the HyperTerminal files taken from Windows XP, namely hypertrm.exe and hypertrm.dll. I have tested it on Windows 11, and the application runs smoothly. How to Use HyperTerminal on Windows 11 Here are the steps to use HyperTerminal on Windows 11: 1. Download HyperTerminal File: Download the hyperterminal.zip file from my drive . 2. Extr...