Skip to main content

Excel shortcut keys:

 

1.     Excel is a spreadsheet software developed by Microsoft. It is widely used for data management and analysis in various industries, including finance, accounting, marketing, and engineering. Excel allows users to organize and manipulate large amounts of data using a variety of tools, functions, and formulas..

Here is a list of Excel shortcut keys:


3.     CTRL + A: Select All

4.     CTRL + B: Bold

5.     CTRL + C: Copy

6.     CTRL + D: Fill Down

7.     CTRL + F: Find

8.     CTRL + G: Go To

9.     CTRL + H: Replace

10.  CTRL + I: Italic

11.  CTRL + K: Insert Hyperlink

12.  CTRL + N: New Workbook

13.  CTRL + O: Open Workbook

14.  CTRL + P: Print

15.  CTRL + R: Fill Right

16.  CTRL + S: Save

17.  CTRL + U: Underline

18.  CTRL + V: Paste

19.  CTRL + W: Close Workbook

20.  CTRL + X: Cut

21.  CTRL + Y: Redo

22.  CTRL + Z: Undo

23.  F1: Help

24.  F2: Edit Cell

25.  F3: Paste Name

26.  F4: Repeat Last Action

27.  F5: Go To

28.  F6: Next Pane

29.  F7: Spell Check

30.  F8: Extend Selection

31.  F9: Recalculate

32.  F10: Activate Menubar

33.  F11: New Chart

34.  F12: Save As

35.  ALT: Show Key Tips

36.  ALT + F: File Menu

37.  ALT + E: Edit Menu

38.  ALT + V: View Menu

39.  ALT + I: Insert Menu

40.  ALT + D: Data Menu

41.  ALT + O: Format Menu

42.  ALT + P: Print Menu

43.  ALT + M: Mailings Menu

44.  ALT + W: Review Menu

45.  ALT + N: Page Layout Menu

46.  ALT + S: Formula Menu

47.  ALT + R: Developer Menu

48.  ALT + A: Data Analysis Menu

49.  ALT + Q: Quick Access Toolbar

50.  ALT + T: Table Tools

51.  ALT + C: Chart Tools

52.  ALT + H: Header/Footer

53.  ALT + F1: Insert Chart

54.  ALT + F2: Save As

55.  ALT + F3: Paste Name

56.  ALT + F4: Exit

57.  ALT + F8: Macro Dialog Box

58.  ALT + F11: Visual Basic Editor

59.  ALT + Tab: Switch between open applications

60.  ALT + Enter: Insert a new line in a cell

61.  ALT + '=': AutoSum

62.  ALT + '(': Insert left parenthesis

63.  ALT + ')': Insert right parenthesis

64.  ALT + '+': Insert a new column or row in a table

65.  ALT + '-': Delete the selected column or row in a table

66.  ALT + '>': Show the next sheet in the workbook

67.  ALT + '<': Show the previous sheet in the workbook

68.  ALT + 'o': Open the File menu

69.  ALT + 'a': Open the Data menu

70.  ALT + 'h': Open the Home tab

71.  ALT + 'n': Open the Insert menu

72.  ALT + 'p': Open the Page Layout menu

73.  ALT + 'r': Open the Review menu

74.  ALT + 's': Open the Formulas menu

75.  ALT + 't': Open the Table Tools menu

76.  ALT + 'v': Open the View menu

77.  ALT + 'w': Open the Workbook View menu

78.  ALT + 'x': Open the Developer tab

79.  ALT + 'y': Redo the last action

80.  ALT + 'z': Undo the last action

81.  SHIFT + F1: What's This?

82.  SHIFT + F2: Insert Comment

83.  SHIFT + F3: Insert Function

84.  SHIFT + F4: Find Next

85.  SHIFT + F5: Go To

86.  SHIFT + F6: Previous Pane

87.  SHIFT + F8: Add to Selection

88.  SHIFT + F9: Calculate Active Worksheet

89.  SHIFT + F10: Display Context Menu

90.  SHIFT + F11: New Worksheet

91.  SHIFT + F12: Save As

92.  Ctrl + F2: Displays the print preview.

93.  Ctrl + F4: Closes the current workbook.

94.  Ctrl + F6: Switches between open workbooks.

95.  Ctrl + Tab: Switches between open worksheets.

96.  Ctrl + Shift + &: Applies the "General" number format to the selected cells.

97.  Ctrl + Shift + #: Applies the "Date" number format to the selected cells.

98.  Ctrl + Shift + @: Applies the "Time" number format to the selected cells.

99.  Ctrl + Shift + %: Applies the "Percentage" number format to the selected cells.

100.                  CTRL + SHIFT + &: Apply border

101.                  CTRL + SHIFT + ~: Apply General format

102.                  CTRL + SHIFT + #: Apply Date format

103.                  CTRL + SHIFT + @: Apply Time format

104.                  CTRL + SHIFT + $: Apply Currency format

105.                  CTRL + SHIFT + %: Apply Percentage format

106.                  CTRL + SHIFT + ^: Apply Exponential format

107.                  CTRL + SHIFT + *: Select Current Region

108.                  CTRL + SHIFT + +: Insert Row or Column

109.                  CTRL + SHIFT + -: Delete Row or Column

110.                  ALT + ENTER: Insert New Line in Cell

111.                  ALT + =: AutoSum

112.                  ALT + SPACE: Open Control Menu

113.                  ALT + TAB: Switch Between Open Programs

114.                  CTRL + ALT + F9: Calculate All Worksheets

115.                  CTRL + ALT + F1: Open Task Pane

116.                  CTRL + ALT + V: Paste Special

117.                  CTRL + ALT + SHIFT + F9: Recheck Dependent Formulas

118.                  CTRL + ALT + SHIFT + F3: Create Names by Using Names of Row and Column Labels

119.                  CTRL + ALT + SHIFT + F10: Display Hidden Menu

 

120.                  CTRL + 1: Format Cells

121.                  CTRL + 2: Bold

122.                  CTRL + 3: Italic

123.                  CTRL + 4: Underline

124.                  CTRL + 5: Strikethrough

125.                  CTRL + 6: Show/Hide Objects

126.                  CTRL + 7: Show/Hide Standard Toolbar

127.                  CTRL + 8: Show/Hide Outline Symbols

128.                  CTRL + 9: Hide Rows

129.                  CTRL + 0: Hide Columns

130.                  CTRL + -: Delete Selected Rows or Columns

131.                  CTRL + +: Insert Rows or Columns

132.                  ALT: Display Key Tips

133.                  ALT + F: File menu

134.                  ALT + H: Home menu

135.                  ALT + N: Insert menu

136.                  ALT + P: Page Layout menu

137.                  ALT + M: Formulas menu

138.                  ALT + A: Data menu

139.                  ALT + R: Review menu

140.                  ALT + W: View menu

 

141.                  Navigation Shortcuts:

142.                  CTRL + Home: Go to cell A1

143.                  CTRL + End: Go to the last cell in the current worksheet

144.                  CTRL + Arrow Keys: Move to the edge of the current data region

145.                  CTRL + Page Up: Move to the previous worksheet

146.                  CTRL + Page Down: Move to the next worksheet

 

147.                  CTRL + SHIFT + &: Apply outline border

148.                  CTRL + SHIFT + _: Remove outline border

149.                  CTRL + SHIFT + ~: General format

150.                  CTRL + SHIFT + !: Comma format

151.                  CTRL + SHIFT + @: Time format

152.                  CTRL + SHIFT + #: Date format

153.                  CTRL + SHIFT + $: Currency format

154.                  CTRL + SHIFT + %: Percent format

155.                  CTRL + SHIFT + ^: Scientific format

156.                  CTRL + SHIFT + &: Apply bold border

157.                  CTRL + SHIFT + *: Select current region

158.                  CTRL + SHIFT + (: Unhide rows

159.                  CTRL + SHIFT + ): Unhide columns

160.                  CTRL + SHIFT + +: Insert cells

161.                  CTRL + SHIFT + -: Delete cells

162.                  CTRL + SHIFT + <: Select entire column

163.                  CTRL + SHIFT + >: Select entire row

164.                  CTRL + SHIFT + C: Copy cell value/formula only

165.                  CTRL + SHIFT + F: Font dialog box

166.                  CTRL + SHIFT + G: Find and replace with wildcards

167.                  CTRL + SHIFT + L: Toggle filter

168.                  CTRL + SHIFT + N: Apply default border

169.                  CTRL + SHIFT + O: Select all cells with comments

170.                  CTRL + SHIFT + P: Bring up print dialog box

171.                  CTRL + SHIFT + R: Fill right

172.                  CTRL + SHIFT + S: Save as

173.                  CTRL + SHIFT + T: Create table

174.                  CTRL + SHIFT + U: Expand formula bar

175.                  CTRL + SHIFT + V: Paste special

176.                  CTRL + SHIFT + W: Close workbook

177.                  CTRL + SHIFT + X: Cut cell value/formula only

178.                  CTRL + SHIFT + Z: Redo

 

Labels:
Location: India

Comments

Post a Comment

Popular posts from this blog

Busy Accounting Software shortcut keys

  Here are some commonly used shortcut keys for Busy Accounting Software: 1.      Alt + F1: To select Company Info menu 2.      Alt + F2: To select Masters menu 3.      Alt + F3: To select Vouchers menu 4.      Alt + F4: To select Reports menu 5.      Alt + F5: To select Utilities menu 6.      Alt + F6: To select Transactions menu 7.      Alt + F7: To select Configuration menu 8.      Alt + F8: To select Help menu 9.      F2: To change the current date 10.   F4: To select a ledger in a voucher 11.   F5: To refresh the current screen 12.   F6: To select a transaction in a voucher 13.   F8: To open the calculat...
Post a Comment
Read more

Tally question and answer

1. Tally package is developed by  a. Peutronics  b. Tally solutions  c. Coral software  d. vedika software  Ans: B  2. Company Restore option is available in  a. Company Feature  b. Company Information  c. Configuration  d. None of these  Ans: B  3. in general thje financial year from shall be from  a. 1st April of any year  b. 31st March of any year  c. All of them are true  d. None of these  Ans : A  5. we can Modify an existing company from  a. Company info > Alter  b. Company info> Alter Company  c. Geteway of tally > Modify company  d. None of these  Ans: A  6. To change current date from gateway of tally press the key  a. F1  b. F5  c. F2  d. F9  Ans: C  7. Part account can be created through  a. Group creation window  b. Ledger creation window  c. Inventory creation window  d. Any on of them  ...
Post a Comment
Read more
विश्व में कहाँ पर स्वतंत्रता दिवस नहीं मनाया जाता? स्वतंत्रता दिवस वही देश मनाएगा, जो कभी परतंत्र रहा हो। यूके, रूस, फ्रांस, नेपाल, थाईलैंड, जापान, चीन, ऑस्ट्रेलिया, न्यूजीलैंड जैसे अनेक देश नहीं मनाते। फिर भी फ्रांसीसी क्रांति की याद में बास्तील दिवस मनाता है। ऑस्ट्रेलिया, न्यूजीलैंड और दक्षिण अफ्रीका पर बाहर से आए लोगों का शासन है। पर वे अब भी इन देशों के निवासी हैं, इसलिए स्वतंत्रता दिवस नहीं मनाते। चीन 1 अक्तूबर को कम्युनिस्ट शासन की शुरूआत को मनाता है। नेपाल 29 मई 2008 को संप्रभुता सम्पन्न गणतंत्र बना। इस दिन यहाँ से राजशाही का खात्मा हुआ। नेपाल में लोकतंत्र दिवस हर साल फाल्गुन सप्तमी को मनाया जाता है। इस रोज सन 1951 में राजा त्रिभुवन ने देश को राणाशाही के हाथों से निकाल कर लोकतंत्र की स्थापना की थी। पर देश में लोकतंत्र 1960 में आया जब राजा महेन्द्र ने पंचायत प्रणाली की स्थापना की
Post a Comment
Read more