Featured post

Trick to get the sum row wise or column wise

    Row-wise or Column-wise Sum Using a Shortcut: Select the range of numbers in the table that you want to sum (either a column or a row, or even multiple columns or rows). Press the Alt key on your keyboard. After pressing Alt , press the +   = key . This is the AutoSum shortcut. If you're summing a column , Excel will automatically fill the cell directly below the selected range with the sum of that column. If you're summing a row , Excel will automatically fill the cell directly to the right of the selected range with the sum of that row.   The AutoSum feature ( Alt + = ) automatically sums numbers in a contiguous range of cells.    
1 comment

150 Essential Computer Shortcuts


  150 Essential Computer Shortcuts  

 1. General Shortcuts (Works in Most Apps)

1. Ctrl + C → Copy

2. Ctrl + X → Cut

3. Ctrl + V → Paste

4. Ctrl + Z → Undo

5. Ctrl + Y → Redo

6. Ctrl + A → Select All

7. Ctrl + S → Save

8. Ctrl + P → Print

9. Ctrl + N → New Document/Window

10. Ctrl + O → Open File

11. Ctrl + W → Close Window

12. Ctrl + F → Find

13. Ctrl + H → Replace

14. Alt + Tab → Switch Applications

15. Alt + F4 → Close Program

 

 2. File Explorer (Windows) / Finder (Mac)

 

16. Ctrl + N → New Window

17. Ctrl + Shift + N → New Folder

18. Alt + Enter → File Properties

19. F2 → Rename File

20. Delete → Move to Recycle Bin

21. Shift + Delete → Permanent Delete

22. Ctrl + D → Delete Selected File (Mac: Cmd + Delete)

23. Ctrl + E → Quick Search

24. Alt + Up Arrow → Go Up Folder

25. Alt + Left Arrow → Back

26. Alt + Right Arrow → Forward

27. Ctrl + Mouse Scroll → Resize Icons

28. F5 → Refresh

29. Home → Go to Top of Folder

30. End → Go to Bottom of Folder

 

 

# 3. MS Word Shortcuts

 

31. Ctrl + B → Bold

32. Ctrl + I → Italic

33. Ctrl + U → Underline

34. Ctrl + E → Center Align

35. Ctrl + L → Left Align

36. Ctrl + R → Right Align

37. Ctrl + J → Justify

38. Ctrl + Shift + > → Increase Font Size

39. Ctrl + Shift + < → Decrease Font Size

40. Ctrl + K → Insert Hyperlink

41. Ctrl + F2 → Print Preview

42. Ctrl + Enter → Page Break

43. Ctrl + Shift + L → Bullet List

44. Ctrl + T → Hanging Indent

45. Ctrl + 1/2/5 → Line Spacing (Single/Double/1.5)

 

# 4. MS Excel Shortcuts

 

46. Ctrl + T → Create Table

47. Ctrl + Shift + L → Toggle Filters

48. Ctrl + ; → Insert Date

49. Ctrl + Shift + : → Insert Time

50. F2 → Edit Cell

51. Ctrl + Space → Select Column

52. Shift + Space → Select Row

53. Ctrl + Shift + “+” → Insert Row/Column

54. Ctrl + “-” → Delete Row/Column

55. Alt + = → AutoSum

56. Ctrl + Arrow Keys → Jump to Edge of Data

57. Ctrl + Shift + Arrow Keys → Select Data Range

58. Ctrl + Page Up/Down → Switch Worksheets

59. F4 → Repeat Last Action

60. Ctrl + 1 → Format Cells

 

# 5. MS PowerPoint Shortcuts

 

61. Ctrl + M → New Slide

62. Ctrl + D → Duplicate Slide

63. F5 → Start Slide Show

64. Shift + F5 → Start from Current Slide

65. Ctrl + Shift + C → Copy Formatting

66. Ctrl + Shift + V → Paste Formatting

67. Ctrl + K → Insert Hyperlink

68. Ctrl + Shift + > → Increase Font Size

69. Ctrl + Shift + < → Decrease Font Size

70. Ctrl + G → Group Objects

71. Ctrl + Shift + G → Ungroup Objects

72. Ctrl + Up/Down → Move Slide

73. B → Black Screen During Presentation

74. W → White Screen During Presentation

75. Esc → Exit Slide Show

 

 

#6. Browser Shortcuts (Chrome/Firefox/Edge)

 

76. Ctrl + T → New Tab

77. Ctrl + W → Close Tab

78. Ctrl + Shift + T → Reopen Closed Tab

79. Ctrl + Tab → Next Tab

80. Ctrl + Shift + Tab → Previous Tab

81. Ctrl + L → Focus Address Bar

82. Ctrl + D → Bookmark Page

83. Ctrl + Shift + B → Show/Hide Bookmarks Bar

84. Ctrl + R / F5 → Refresh Page

85. Ctrl + Shift + R → Hard Refresh

86. Ctrl + J → Downloads

87. Ctrl + H → History

88. Ctrl + Shift + N → New Incognito Window

89. F11 → Full-Screen Mode

90. Esc → Stop Loading

 

# 7. Windows OS Shortcuts

 

91. Win + D → Show Desktop

92. Win + E → File Explorer

93. Win + L → Lock Computer

94. Win + R → Run Dialog Box

95. Win + I → Settings

96. Win + Tab → Task View

97. Win + Shift + S → Screenshot Snip

98. Win + V → Clipboard History

99. Win + . → Emoji Panel

100. Win + G → Xbox Game Bar

101. Win + P → Projector/Display Mode

102. Win + + → Zoom In (Magnifier)

103. Win + - → Zoom Out

104. Win + Ctrl + D → New Virtual Desktop

105. Win + Ctrl + Left/Right → Switch Desktops

 

# 8. Mac OS Shortcuts

 

106. Cmd + Space → Spotlight Search

107. Cmd + Option + Esc → Force Quit

108. Cmd + Shift + 3 → Full Screenshot

109. Cmd + Shift + 4 → Partial Screenshot

110. Cmd + Tab → Switch Apps

111. Cmd + Q → Quit App

112. Cmd + H → Hide App

113. Cmd + M → Minimize Window

114. Cmd + Option + M → Minimize All

115. Cmd + , → Open Preferences

116. Cmd + Shift + T → Reopen Closed Tab (Browser)

117. Cmd + L → Focus Address Bar

118. Cmd + Option + Space → Finder Search

119. Cmd + Delete → Move to Trash

120. Cmd + Shift + Delete → Empty Trash

 

# 9. Email (Outlook/Gmail)

 

121. Ctrl + R → Reply

122. Ctrl + Shift + R → Reply All

123. Ctrl + F → Forward

124. Ctrl + N → New Email

125. Ctrl + Enter → Send Email

126. Ctrl + K → Insert Link

127. Ctrl + Shift + M → New Message in Outlook

128. Ctrl + 1 → Go to Mail (Outlook)

129. Ctrl + 2 → Go to Calendar

130. Ctrl + 3 → Go to Contacts

131. Ctrl + Q → Mark as Read

132. Ctrl + U → Mark as Unread

133. Ctrl + Shift + I → Inbox

134. Ctrl + Shift + O → Outbox

135. Tab + Enter → Select Suggested Email

 

 

#10. Creative Tools (Photoshop & Design)

 

136. Ctrl + N → New File

137. Ctrl + O → Open File

138. Ctrl + S → Save

139. Ctrl + Alt + S → Save As

140. Ctrl + Shift + S → Save for Web

141. Ctrl + T → Free Transform

142. Ctrl + D → Deselect

143. Ctrl + Shift + I → Inverse Selection

144. Ctrl + J → Duplicate Layer

145. Ctrl + Alt + Z → Step Backward (Multiple Undo)

146. Spacebar → Hand Tool (Move Canvas)

147. Ctrl + + / - → Zoom In/Out

148. Tab → Show/Hide Panels

149. Ctrl + Shift + N → New Layer

150. F → Toggle Screen Mode

 

 

 

Comments

Post a Comment

POPULAR POSTS

essential BAsic excel formulas a quick guide

Image
  Here are some tips for using Excel formulas: All formulas start with an equal sign (=) To refer to a cell, enter the column letter followed by the row number. For example, B2 refers to the cell at the intersection of column B and row 2.           The formula bar shows the formula you enter in a cell. You can see it whenever that cell is selected. Here are some basic Excel formulas you can use for common tasks: 1. SUM Adds a range of numbers. =SUM(A1:A10) 2. AVERAGE Calculates the average of a range of numbers. =AVERAGE(B1:B10) 3. COUNT Counts the number of cells that contain numbers. =COUNT(C1:C10) 4. MAX Finds the maximum value in a range. =MAX(D1:D10) 5. MIN Finds the minimum value in a range. =MIN(E1:E10) 6. IF Performs a logical test and returns one value for TRUE and another for FALSE. =IF(F1 > 10, "Yes", "No") 7. CONCATENATE (or &) Joins two or more strings together. =CONCATENATE(G1, " ", H1) =G1 & " " & H1 8...
Read more

Some important tips to learn MS Word

Image
    Some important tips to learn MS Word   ·       Steps:           Open Word   ·         Click   start   ·         click   program   ·         Click   MS word   Steps:    Find ·         click on edit menu ·         click find ·         Type the text you want to find ·         Click on Find Next button.   Steps: Replace ·           Click on the Edit menu ·         click replace ·         Type the text you want to replace on the first line ·         On the second line, type the text you want to replace on the first line ·         Click on the Replace All button.   Steps: Go to ·           Click on t...
Read more

Insert Serial Numbers in Roman Numerals, Alphabets, and Numbers in Excel

Image
  How to Insert Serial Numbers in Roman Numerals, Alphabets, and Numbers in Exce l To easily generate serial numbers in Roman numerals, alphabets, or numbers, follow these simple formulas in Excel: SL NO in  Roman Numerals: Click on the cell where you want to start the serial number (e.g., A1). Enter the following formula: =ROMAN(ROW(A1)) After entering the formula, drag the fill handle (small square at the bottom-right corner of the cell) down to apply it to additional cells. SL NO in Alphabets Click on the cell where you want the alphabet sequence to begin (e.g., A1). Enter this formula: =CHAR(64 + ROW(A1)) Drag the fill handle down to continue the alphabet sequence.    Sl no in Numbers: Click on the cell where you want to start numbering (e.g., A1). Enter the formula: =ROW(A1) Drag the fill handle down to generate a sequence of numbers. By using these simple formulas, you can quickly generate serial numbers in Roman numerals, alphabets, or numbers across your spre...
Read more

How to find sum of numbers with units in a range in Excel?

Image
  How to find sum of numbers with units in a range in Excel? In Excel, you can use a formula to handle this task. Select a blank cell, and type this formula =SUM(SUBSTITUTE(B1:B7, "kg", "") + 0) into it, and then press  Shift + Ctrl + Enter  keys simultaneously to get the correct result. OR USE THIS  FORMULA  SELECT A BLANK CELL AND TYPE THIS FORMULA=SUM(--LEFT(B1:B7,2)) USE CTL+SHIFT+ENTER . A                                   B APPLE 20KG PEAR 30KG MANGO 10KG BANANA 11KG GRAPES 50KG ORANGE 22KG POTATO 30KG   173 = SUM(--LEFT(B1:B7,2)) USE CTL+SHIFT+ENTER Tip:  in above formula, B1:B7 is the numbers with units you want to sum up, kg is the unit in the data ...
Read more

Rearrange columns in excel sheet using a quick trick

Image
    Rearrange columns in excel sheet using a quick trick     No need to copying, pasting, or dragging , just used a simple trick  Select all the table by pressing CTRL +A, This highlight all the cells in your sheet. Next press  ALT +HSU,  This opens the  sorting dialouge box,. In this dialogue box click on option and selct left to right Now choose the row you want to sort by. you will get a  revised table of data as per your need.   scan
Read more

TIPS TO INSERT A SERIAL NUMBER IN AN EXCEL SHEET

Image
  TIPS TO INSERT A SERIAL NUMBER IN AN EXCEL SHEET USING A COMAND AND TRICKS             To insert a serial number (SL NO) in an Excel sheet using a command, you can use a simple formula. Here’s how you can do it: Open Excel and navigate to the cell where you want to start your serial numbers (e.g., A1).   Enter the Formula : In cell A1, type 1 to start the numbering. In cell A2, type the formula =A1 + 1 . This will add 1 to the value above.   AutoFill the Series : Click on the small square at the bottom-right corner of cell A2 (the fill handle). Drag it down to fill the cells below with sequential numbers as you desired. 1       =A1+1                 TRICKS   TO INSERT...
Read more