Competitions

CAT Prep

Upskill

Placements

MBA Co'26

RTI Response

Rankings

Score Vs. %ile

Salaries

Campus Tour

Must Try Excel Shortcuts Without a Mouse Click

Dec 18, 2015 | 3 minutes |

Join InsideIIM GOLD

Webinars & Workshops

Compare B-Schools

Free CAT Course

Take Free Mock Tests

Upskill With AltUni

CAT Study Planner

Final 2 Days to CAT 2024 Test-44

Participants: 317

Final 3 Days to CAT 2024 Test-43

Participants: 287

Final 4 Days to CAT 2024 Test-42

Participants: 346

Final 5 Days to CAT 2024 Test-41

Participants: 366

Final 6 Days to CAT 2024 Test-40

Participants: 345

Final 7 Days to CAT 2024 Test-39

Participants: 340

Final 8 Days to CAT 2024 Test-38

Participants: 316

Final 9 Days to CAT 2024 Test-37

Participants: 326

Final 10 Days to CAT 2024 Test-36

Participants: 288

Final 11 Days to CAT 2024 Test-35

Participants: 490

Final 12 Days to CAT 2024 Test-34

Participants: 335

Final 13 Days to CAT 2024 Test-33

Participants: 295

Final 14 Days to CAT 2024 Test-32

Participants: 277

Final 15 Days to CAT 2024 Test-31

Participants: 364

Final 16 Days to CAT 2024 Test-30

Participants: 293

Final 17 Days to CAT 2024 Test-29

Participants: 311

Final 18 Days to CAT 2024 Test-28

Participants: 342

Final 19 Days to CAT 2024 Test-26

Participants: 338

Final 20 Days to CAT 2024 Test-26

Participants: 306

Final 21 Days to CAT 2024 Test-25

Participants: 252

Final 22 Days to CAT 2024 Test-24

Participants: 268

Final 23 Days to CAT 2024 Test-23

Participants: 180

Final 24 Days to CAT 2024 Test-22

Participants: 226

Final 25 Days to CAT 2024 Test-21

Participants: 223

Final 26 Days to CAT 2024 Test-20

Participants: 277

Final 27 Days to CAT 2024 Test-19

Participants: 232

Final 28 Days to CAT 2024 Test-18

Participants: 235

Final 29 Days to CAT 2024 Test-17

Participants: 246

Final 30 Days to CAT 2024 Test-16

Participants: 281

Final 31 Days to CAT 2024 Test-15

Participants: 278

Microsoft Excel is one of the most powerful, most important software applications of all times. The application of Excel is not restricted to any specific field. It is spread across all domains. So, if you are someone who is trying to make a place in the corporate world, it is very important to be acquainted with excel techniques. These are some of the basic keyboard excel shortcuts which will surely help in saving some time specially for beginners. CTRL+SHIFT+:  : This is one of the most widely used shortcuts for entering the current time. CTRL+; : It is used to enter the current date Ctrl + Space: Select Entire ColumnKeep your cursor on any cell of the column to be selected, and press Ctrl + Spacebar key. The entire column will get selected. Shift + Space: Select Entire Row. Keep your cursor on any cell of the column to be selected, and press Ctrl + Space bar key – the entire row will get selected Right ClickPress the Menu Key, a button between Alt and Ctrl on the right hand side. Then use the arrow keys to navigate Ctrl +Shift+5: To convert a number into percentage form, select the number and press Ctrl +Shift+5, it would be converted to percentage form Alt + EnterPress Alt + Enter to move your cursor to the next line of the same cell. This can be used when you want multiple lines in a single cell. Ctrl+0This function hides the entire column of the selected cell Ctrl +1: Opens the Format MenuYou can further navigate by using “Tab” key or “Ctrl +Tab” CTRL+2Applies or removes bold formatting. Ctrl+b is used to apply bold formatting.  Ctrl+2 can be used for both. CTRL+3It is used to apply or remove italic formatting. Ctrl+I is used to apply Italic formatting. CTRL+4It is used to apply or remove Underlining. Ctrl+U is used to apply underlining. CTRL+5It is used to apply or remove strikethrough. Ctrl+9This function hides the entire row. Use Ctrl+Shift+9 to unhide any hidden rows within the selection CTRL+SHIFT+&This function is used to apply an outline border to the selected cells. CTRL+SHIFT_This is used to removes the outline border from the selected cells. Ctrl +nInsert a new workbook Ctrl +PageDownIt will direct you to the next worksheet Ctrl +PageDownIt will take you to the previous worksheet Shift F11It is used to insert a new Worksheet Alt+w+sSplitting of window Ctrl+HomeIt will take you to the top most corner of the page. Ctrl+EndIt will direct you to the last filled cell - Bottom of the page Most Familiar excel shortcuts Ctrl+s: Save, Ctrl+f: Find, Ctrl+c: Copy, Ctrl+v: Paste, Ctrl+x: Cut, Ctrl+a: Select All, Ctrl+z: Undo,  Ctrl+y: Redo, Ctrl+p: Print To know all the Shortcuts, just use the Alt Key. Let us take an illustration. When you press the Alt key the below window will appear. Suppose you want to insert something, press “N” (As N stands for Insert) final1 Once you press N, the following window would appear. Now, if you want to insert a symbol, press U (U stands for Symbol) final3We can try different combinations using the Alt Key; we just need to follow the alphabets appearing under each button. So learning Excel should not be a matter of hassle. Trying out different techniques and consistent practice is the key.