Learn Excel | Microsoft Excel Shortcut Keys For Beginners

Опубликовано: 26 Октябрь 2024
на канале: WebMoTLeY

4,481

142

Challenge yourself: How many you remember until the end of it, COMMENT!

Increase your salary 4x times. Learn #Microsoft Shortcut Tricks and Tips used in office work. Learn all MS Excel Shortcut Keys, all Microsoft Excel shortcut keys a to z. Microsoft Excel keyboard shortcuts keys for all the versions of Microsoft Excel like 2003, 2007, 2010, 2013. Microsoft #Excel Keyboard #shortcut key to Learn Excel for Beginners to Advanced level, This is Useful for all competition exams and computer exams such as CCC, RSCIT, O level, and BCA Computer Science. Excel in Most Important software of MS Office.
#msexcel
Most useful 90 shortcut keys have been explained. Includes revision.

00:14 Apply filter: Ctrl Shift L
00:22 Open the drop down in filter: Alt downarrow
00:35 Remove filter: Ctrl Shift L
00:42 Insert a row: Alt I R
00:47 Insert a column: Alt I C
00:57 Select entire row: Shift space
01:04 Select entire column: Ctrl Space
01:17 Delete selected row: Ctrl -
01:25 Delete selected column: Ctrl -
01:31 To edit contents inside the cell : F2
01:41 Newline in a cell: Alt Enter
01:55 Sum of all cells: Alt +=
02:10 Show/Hide formula in cells: Ctrl `
02:24 Move to end/beginning of a data series: Ctrl arrow
02:37 Select cell one by one: Shift Arrow
02:50 Select full data series: Ctrl Shift Arrow
03:03 Create chart in new worksheet: F11
03:12 Create chart embedded in same worksheet: Alt F1
03:19 Open format cell box: Ctrl 1
03:29 Format number 2 digits of decimal: Ctrl Shift 1

03:40 Revision for "1-star excel Expert"

04:19 Format number in date format: Ctrl shift 3
04:27 Format number in currency format: Ctrl Shift 4
04:35 Format number in % format: Ctrl shift 5
04:43 Save as active file: F12
04:55 Current date: Ctrl ;
05:01 Current time: Ctrl shift ;
05:09 Insert worksheet: Shift f11
05:14 Move forward within excel to next worksheet: Ctrl Pagedown
05:21 Move back within excel to previous worksheet: Ctrl Pageup
05:29 Move to cell A1: Ctrl home
05:39 To repeat last formatting option: F4
05:54 Remove outlines from selected cells: Ctrl Shift -
06:05 Fill data down in selected range: Ctrl D
06:18 Fill data down in selected range in edit mode: Ctrl "
06:29 Fill data to right in selected range: Ctrl R
06:39 In edit mode to lock the contents: F4 once/F4 twice/F4 thrice/F4 four-time (check video)
07:14 To save file: Ctrl S
07:20 To open saved workbook: Ctrl O
07:26 Open excel help: F1
07:40 To open new workbook: Ctrl N

07:47 Revision for "2-star excel Expert"

08:32 To enter the same data in multiple cells at once: Check the video!

08:51 Insert a comment: Shift F2
09:04 To select all cells with comments: Ctrl Shift O
09:28 To open print menu: Ctrl P
09:39 To display Macro dialogue box: Alt F8
09:52 To open visual basic editor: Alt F11
10:05 To display spelling dialogue box: F7
10:20 To select all adjacent data: Ctrl Shift 8
10:31 Expand or collapse the formula bar: Ctrl Shift U
10:41 To enter arguments in formula after entering formula: Ctrl Shift A
11:06 To edit formula in formula bar after entering formula: Ctrl A
11:23 Enter formula as array formula: Ctrl shift enter
11:53 Display insert function dialogue box: Shift F3
12:10 Hide selected rows: Ctrl 9
12:19 Unhide hidden rows within selection: Ctrl Shift 9
12:32 Hide selected columns: Ctrl 0
12:39 Unhide hidden columns within selection: Ctrl Shift 0
12:52 Adjust columns to a particular width: Alt H then O then W
13:05 Autofit column width: Alt H then O then I
13:15 Adjust rows to a particular height: Alt H then O then H

13:24 Revision for "3-star excel Expert"

14:14 Autofit row height: Alt H then O then A
14:22 Insert a hyperlink: Ctrl K
14:58 Open paste special dialog box when content is copied: Ctrl Alt V
15:12 Move to next row: Enter
15:14 Move to the previous row: Shift Enter
15:19 Move to next column: Tab
15:24 Move to the previous column: Shift Tab
15:30 Extend selection to the beginning of worksheet: Ctrl Shift Home
15:43 Extend selection to the beginning of row: Shift Home
15:53 Select current sheet and next sheet in the workbook: Ctrl Shift Pagedown
16:07 Select current sheet and previous sheet in workbook Ctrl Shift Pageup
16:29 Inside a cell move to start: Home
16:39 Inside a cell move to the end: End
16:44 Inside a cell delete till end of line: Ctrl Delete
16:52 Inside a cell to move out: Esc
16:59 Display Goto dialog box: Ctrl G
17:12 Copy contents of cell: Ctrl C
17:17 Paste contents in a cell: Ctrl V
17:25 Cut contents in a cell: Ctrl X
17:38 Select all contents of worksheet: Ctrl A
17:51 Revision for "4-star excel Expert"
18:30 To underline contents of cell: Ctrl U
18:42 Display find dialog box: Ctrl F
18:55 Display find and replace dialog box: ctrl h
19:16 To bold the contents of the cell: Ctrl B
19:27 To open Font in format cells: Ctrl Shift P
19:41 Move to beginning of row: Home
19:49 Undo last action: Ctrl Z
19:58 Redo last action: Ctrl Y
20:11 Minimize/maximise ribbon: Ctrl F1
20:24 Print preview: Ctrl F2
20:40 Revision for "5-star excel Expert"