MICROSOFT POWER POINT SHORT CUT KEY

Certainly! Here is an extensive list of shortcut keys for Microsoft PowerPoint, detailed to help you enhance your productivity and efficiency:

General Program Shortcuts

1.     Ctrl + N: Create a new presentation

2.     Ctrl + O: Open an existing presentation

3.     Ctrl + S: Save a presentation

4.     F12 or Alt + F2: Save As

5.     Ctrl + P: Print a presentation

6.     Ctrl + W or Ctrl + F4: Close a presentation

7.     Ctrl + Q: Save and close a presentation

8.     Ctrl + Z: Undo an action

9.     Ctrl + Y: Redo an action

10.  Ctrl + F: Find text

11.  Alt + Ctrl + F: Find and replace text

12.  F7: Check spelling

13.  Alt or F10: Activate the menu bar

14.  Alt + F: Open the File tab menu

15.  Alt + H: Open the Home tab

16.  Alt + N: Open the Insert tab

17.  Alt + G: Open the Design tab

18.  Alt + K: Open the Transitions tab

19.  Alt + A: Open the Animations tab

20.  Alt + S: Open the Slide Show tab

21.  Alt + R: Open the Review tab

22.  Alt + W: Open the View tab

Working with Presentations

1.     Ctrl + M: Insert a new slide

2.     Ctrl + D: Duplicate the selected slide

3.     Ctrl + Shift + D: Duplicate the selected slides

4.     Ctrl + Shift + C: Copy formatting from text

5.     Ctrl + Shift + V: Paste formatting to text

6.     Ctrl + K: Insert a hyperlink

7.     Ctrl + Shift + K: Remove a hyperlink

8.     Ctrl + B: Bold selected text

9.     Ctrl + I: Italicize selected text

10.  Ctrl + U: Underline selected text

11.  Ctrl + E: Centre align paragraph

12.  Ctrl + L: Left align paragraph

13.  Ctrl + R: Right align paragraph

14.  Ctrl + J: Justify paragraph

15.  Ctrl + T: Open the Font dialog box

16.  Ctrl + G: Group selected objects

17.  Ctrl + Shift + G: Ungroup selected objects

18.  Ctrl + Shift + J: Justify the selected text

19.  Ctrl + Alt + V: Paste Special

20.  Ctrl + Shift + F: Open the Font dialog box to change the font

Navigating and Working with Slides

1.     Page Up or ↑: Move to the previous slide

2.     Page Down or ↓: Move to the next slide

3.     Home: Move to the first slide

4.     End: Move to the last slide

5.     Ctrl + ↑: Move slide up in order

6.     Ctrl + ↓: Move slide down in order

7.     Ctrl + Shift + Home: Select all slides from the current to the first

8.     Ctrl + Shift + End: Select all slides from the current to the last

Slide Show Shortcuts

1.     F5: Start the slide show from the beginning

2.     Shift + F5: Start the slide show from the current slide

3.     Esc: End the slide show

4.     N or Spacebar: Move to the next slide

5.     P or Backspace: Move to the previous slide

6.     B: Black screen during slide show

7.     W: White screen during slide show

8.     Ctrl + P: Annotate with the pen tool during a slide show

9.     Ctrl + A: Change pointer to arrow during a slide show

10.  Ctrl + E: Change pointer to eraser during a slide show

11.  E: Erase annotations on screen

12.  T: Display the taskbar during slide show

13.  Ctrl + L: Change pointer to laser pointer

14.  Ctrl + H: Hide the pointer and navigation button during a slide show

15.  Ctrl + S: View all slides

16.  Ctrl + U: Show or hide the slide show toolbar

Editing and Formatting

1.     Ctrl + X: Cut selected text, object, or slide

2.     Ctrl + C: Copy selected text, object, or slide

3.     Ctrl + V: Paste cut or copied text, object, or slide

4.     Delete: Delete selected text, object, or slide

5.     Ctrl + Shift + <: Decrease the font size

6.     Ctrl + Shift + >: Increase the font size

7.     Ctrl + Space: Remove formatting

8.     Ctrl + Shift + =: Apply superscript formatting

9.     Ctrl + =: Apply subscript formatting

10.  Ctrl + Shift + S: Open the Style box

11.  Ctrl + Shift + P: Open the Paragraph dialog box

12.  Ctrl + Alt + Shift + S: Open the Apply Styles task pane

Working with Objects

1.     Ctrl + Shift + Right Arrow: Rotate selected object right

2.     Ctrl + Shift + Left Arrow: Rotate selected object left

3.     Shift + Arrow Key: Move selected object in small increments

4.     Alt + Arrow Key: Move selected object in small increments (finer control)

5.     Ctrl + Shift + G: Group selected objects

6.     Ctrl + Shift + H: Hide selected object

7.     Ctrl + Alt + Shift + G: Ungroup selected objects

 

Customization and Add-Ons

1.     Alt + Shift + P: Open the PowerPoint Options dialog box

2.     Alt + Shift + R: Start recording the slide show

3.     Alt + Shift + C: Close the active presentation window

4.     Alt + Shift + A: Add animation to selected objects

5.     Alt + Shift + S: Synchronize slides with other users

 These shortcuts are designed to help you work more efficiently in Microsoft PowerPoint, allowing you to create, edit, and present your slides with greater ease. Mastering these shortcuts can significantly enhance your productivity and streamline your workflow.

MICROSOFT EXCEL SHORTCUT KEYS

Microsoft Excel is a powerful tool used for data analysis, financial modelling, and general spreadsheet tasks. Knowing keyboard shortcuts can significantly enhance productivity by speeding up navigation and execution of commands. Below is an extensive guide to some of the most useful shortcuts in Excel.

Basic Navigation Shortcuts

1.     Arrow Keys: Move one cell up, down, left, or right.

2.     Ctrl + Arrow Keys: Jump to the edge of data in the current row or column.

3.     Tab: Move one cell to the right.

4.     Shift + Tab: Move one cell to the left.

5.     Enter: Move one cell down.

6.     Shift + Enter: Move one cell up.

7.     Page Up/Page Down: Move one screen up or down.

8.     Alt + Page Up/Alt + Page Down: Move one screen to the left or right.

9.     Ctrl + Home: Move to the beginning of the worksheet.

10.  Ctrl + End: Move to the last cell with data.

Cell Selection Shortcuts

1.     Shift + Arrow Keys: Select a range of cells.

2.     Ctrl + Shift + Arrow Keys: Select a large range of cells, extending the selection to the edge of the current data region.

3.     Ctrl + A: Select the entire worksheet or the current data region.

4.     Shift + Space: Select the entire row.

5.     Ctrl + Space: Select the entire column.

6.     Ctrl + Shift + Space: Select the entire worksheet.

Data Entry Shortcuts

1.     Ctrl + D: Fill down the contents of the top cell in the selected range to the other cells in the range.

2.     Ctrl + R: Fill right the contents of the leftmost cell in the selected range.

3.     Ctrl + Enter: Fill the selected cells with the current entry.

4.     Alt + Enter: Start a new line within the same cell.

5.     Ctrl + ;: Enter the current date.

6.     Ctrl + Shift + :: Enter the current time.

7.     Ctrl + `: Toggle the display of formulas.

Editing Shortcuts

1.     F2: Edit the active cell.

2.     Ctrl + Z: Undo an action.

3.     Ctrl + Y: Redo an action.

4.     Delete: Clear the contents of the selected cell.

5.     Ctrl + -: Delete the selected cells.

6.     Ctrl + Shift + +: Insert cells.

7.     Ctrl + C: Copy the selected cells.

8.     Ctrl + X: Cut the selected cells.

9.     Ctrl + V: Paste the copied or cut cells.

10.  Ctrl + Alt + V: Open the Paste Special dialog box.

11.  F4: Repeat the last action.

12.  Ctrl + 1: Open the Format Cells dialog box.

Formatting Shortcuts

1.     Ctrl + B: Apply or remove bold formatting.

2.     Ctrl + I: Apply or remove italic formatting.

3.     Ctrl + U: Apply or remove underline formatting.

4.     Alt + H, A, C: Centre align cell contents.

5.     Alt + H, A, L: Align cell contents to the left.

6.     Alt + H, A, R: Align cell contents to the right.

7.     Ctrl + Shift + $: Apply currency format.

8.     Ctrl + Shift + %: Apply percentage format.

9.     Ctrl + Shift + ^: Apply scientific number format.

10.  Ctrl + Shift + #: Apply date format.

11.  Ctrl + Shift + @: Apply time format.

Formula Shortcuts

1.     =: Start a formula.

2.     Ctrl + Shift + Enter: Enter an array formula.

3.     Alt + =: Insert the SUM function.

4.     Ctrl + `: Toggle the display of formulas.

Function Key Shortcuts

1.     F1: Open Help.

2.     F2: Edit the active cell.

3.     F3: Paste a defined name into a formula.

4.     F4: Repeat the last action.

5.     F5: Open the Go To dialog box.

6.     F6: Switch between the worksheet, Ribbon, task pane, and Zoom controls.

7.     F7: Open the Spelling dialog box.

8.     F8: Turn on/off Extend Selection mode.

9.     F9: Calculate all worksheets.

10.  F10: Activate the Menu bar.

11.  F11: Create a chart.

12.  F12: Open the Save As dialog box.

Special Shortcuts

1.     Ctrl + F1: Expand or collapse the Ribbon.

2.     Ctrl + F2: Open Print Preview.

3.     Ctrl + F3: Open the Name Manager.

4.     Ctrl + F4: Close the window.

5.     Ctrl + F6: Switch to the next workbook window.

6.     Ctrl + F9: Minimize the workbook window.

7.     Ctrl + F10: Maximise or restore the workbook window.

Miscellaneous Shortcuts

1.     Alt + F8: Open the Macro dialog box.

2.     Alt + F11: Open the Visual Basic for Applications editor.

3.     Shift + F2: Add or edit a cell comment.

4.     Ctrl + 9: Hide selected rows.

5.     Ctrl + 0: Hide selected columns.

6.     Ctrl + Shift + ( (Ctrl + Shift + 9): Unhide hidden rows.

7.     Ctrl + Shift + ) (Ctrl + Shift + 0): Unhide hidden columns.

These shortcuts are essential for efficient Excel use, enabling users to navigate quickly, format cells, enter and edit data, use formulas, and manage workbooks effectively. Mastery of these shortcuts can greatly improve productivity and accuracy in handling spreadsheet tasks.