twitter
rss

Learn English


 ❤️ Ctrl + A – Select All

❤️ Ctrl + B – Bold Text

❤️ Ctrl + C – Copy

❤️ Ctrl + D – Font Settings

❤️ Ctrl + E – Center Align

❤️ Ctrl + F – Find/Search

❤️ Ctrl + G – Go To

❤️ Ctrl + H – Replace

❤️ Ctrl + I – Italic Text

❤️ Ctrl + J – Justify Text

❤️ Ctrl + K – Insert Hyperlink

❤️ Ctrl + L – Left Align

❤️ Ctrl + M – Increase Indent

❤️ Ctrl + N – New

❤️ Ctrl + O – Open File

❤️ Ctrl + P – Print

❤️ Ctrl + Q – Remove Paragraph

❤️ Ctrl + R – Right Align

❤️ Ctrl + S – Save

❤️ Ctrl + T – Hanging Indent

❤️ Ctrl + U – Underline Text

❤️ Ctrl + V – Paste

❤️ Ctrl + W – Close Window

❤️ Ctrl + X – Cut

❤️ Ctrl + Y – Redo

❤️ Ctrl + Z – Undo

❤️ Ctrl + L – Focus Address Bar

❤️ Ctrl + D – Bookmark Page

❤️ Ctrl + J – Downloads

❤️ Ctrl + H – History

❤️ Ctrl + F – Find on Page

❤️ F2 – Rename

❤️ F5 – Refresh

❤️ F1 – Help

❤️ F11 – Full screen

❤️ Ctrl + 1 – Single Line Spacing

❤️ Ctrl + 2 – Double Line Spacing

❤️ Ctrl + 5 – 1.5 Line Spacing

❤️ Alt + F4 – Close App

❤️ Ctrl + '-' – Delete Cell

❤️ F2 – Edit Cell

❤️ Ctrl + W – Close Tab

❤️ Ctrl + Tab – Next Tab

❤️ Alt + = – AutoSum

❤️ Ctrl + \` – Show Formulas

❤️ Ctrl + T – New Tab

❤️ Windows + D – Show Desktop

❤️ Windows + R – Run Dialog Box

❤️ Windows + L – Lock Computer

❤️ Windows + I – Open Settings

❤️ Windows + M – Minimize All

❤️ Windows + S – Search

❤️ Windows + X – Power Menu

❤️ Ctrl + Shift + L – Bullet List

❤️ Ctrl + = – Subscript

❤️ Ctrl + Shift + = – Superscript

❤️ Ctrl + Arrow Key – Jump

❤️ Ctrl + Space – Select Column

❤️ Shift + Space – Select Row

❤️ Ctrl + Shift + '+' – Insert Cell

❤️ F4 – Repeat Last Action

❤️ Ctrl + Shift + T – Reopen Closed Tab

❤️ Ctrl + Shift + Tab – Previous Tab

❤️ General Useful Keys

❤️ Ctrl + Shift + N – New Folder

❤️ Shift + Delete – Permanent Delete

❤️ Alt + Enter – Properties

❤️ Ctrl + Alt + Del – Security Options

❤️ Print Screen – Take Screenshot

❤️ Alt + Space – Window Menu

❤️ Alt + Left Arrow – Back (Browser)

❤️ Alt + Right Arrow – Forward (Browser)

❤️ Ctrl + Shift + Delete – Clear Browsing Data

❤️ Ctrl + Shift + Esc – Open Task Manager

❤️ Ctrl + Shift + N – Create New Folder

❤️ Ctrl + Shift + T – Reopen Last Closed Tab (Browser)

❤️ Ctrl + Shift + Delete – Clear Browsing Data

❤️ Alt + F4 – Close Current App or Window

❤️ Alt + Tab – Switch Between Open Apps

❤️ Ctrl + Esc – Open Start Menu

❤️ Ctrl + N – Open New Window in Browser or App

❤️ Ctrl + Shift + Esc – Open Task Manager Directly

❤️ Ctrl + Shift + > – Increase Font Size in Word

❤️ Ctrl + Shift + < – Decrease Font Size in Word

❤️ Ctrl + Enter – Insert Page Break in Word

❤️ Ctrl + Alt + Del – Open Security Options

❤️ Windows + V – Open Clipboard History

❤️ Windows + . – Open Emoji Panel

❤️ Windows + Shift + S – Take a Screenshot

❤️ Windows + P – Project to Another Screen

❤️ Windows + L – Lock Your PC

❤️ Windows + A – Open Action Center

❤️ Windows + H – Start Voice Typing

❤️ Windows + E – Open File Explorer

❤️ Windows + Shift + M – Restore Minimized

❤️ Alt + Tab – Switch Between Apps

❤️ Ctrl + Shift + Esc – Open Task Manager

❤️ Ctrl + Shift + > – Increase Font Size

❤️ Ctrl + Shift + < – Decrease Font Home


EXCEL SHORTCUTS FOR FINANCE -


❤️ CTRL Shortcuts 🌹🌹


❤️ Select entire column: Ctrl + Space

❤️ Insert a new row: `Ctrl + Shift + "+"

❤️ Delete a row: Ctrl + "-"

❤️ Insert current date: Ctrl + ;

❤️ Insert current time: Ctrl + Shift + ;

❤️ Go to beginning of worksheet: Ctrl + Home

❤️ Go to last cell with data: Ctrl + End

❤️ Copy selected cells: Ctrl + C

❤️ Paste copied cells: Ctrl + V

❤️ Cut selected cells: Ctrl + X

❤️ Undo an action: Ctrl + Z

❤️ Redo an action: Ctrl + Y

❤️ Bold text: Ctrl + B

❤️ Italic text: Ctrl + I

❤️ Underline text: Ctrl + U

❤️ Open Format Cells dialog: Ctrl + 1

❤️ Apply general format: Ctrl + Shift + ~

❤️ Apply currency format: Ctrl + Shift + $

❤️ Apply percentage format: Ctrl + Shift + %

❤️ Apply two decimals: Ctrl + Shift + !

❤️ Move to next worksheet: Ctrl + Page Down

❤️ Move to previous worksheet: Ctrl + Page Up

❤️ Open 'Go To' dialog: Ctrl + G or F5

❤️ Find specific value: Ctrl + F

❤️ Replace values: Ctrl + H

❤️ Hide selected rows: Ctrl + 9

❤️ Unhide hidden rows: `Ctrl + Shift + 9`

❤️ Hide selected columns: `Ctrl + 0`

❤️ Unhide hidden columns: `Ctrl + Shift + 0`

❤️ Enter array formula (Legacy Excel): `Ctrl + Shift + Enter`

❤️ Open Name Manager: `Ctrl + F3`

❤️ Create a table from data range: `Ctrl + T

❤️ Zoom in: `Ctrl + Mouse Wheel Up`

❤️ Zoom out: `Ctrl + Mouse Wheel Down`

❤️ Add borders to selected cells: `Ctrl + Shift + &`

❤️ Display all formulas: `Ctrl + '`

❤️ Go to next open workbook: `Ctrl + Tab`

❤️ Go to previous open workbook: `Ctrl + Shift + Tab`

❤️ Save workbook: `Ctrl + S`

❤️ Create hyperlink: `Ctrl + K`


 ❤️ **SHIFT Shortcuts**


❤️ Select entire row: `Shift + Space`

❤️ Move one cell left: `Shift + Tab`

❤️ Add new worksheet: `Shift + F11`

❤️ Calculate active worksheet: `Shift + F9`

❤️ Open Insert Function dialog: `Shift + F3`

❤️ Insert comment (note): `Shift + F2`

❤️ Calculate active cell only: `Shift + F9`


 ❤️ **ALT Shortcuts**


❤️ Autosum selected cells: `Alt + =`

❤️ Open Excel Options: `Alt + F, T`

❤️ Select visible cells only: `Alt + ;`

❤️ Open drop-down list in a cell: `Alt + Down Arrow`

❤️ Group rows or columns: `Alt + Shift + Right Arrow`

❤️ Ungroup rows or columns: `Alt + Shift + Left Arrow`

❤️ Enter line break in cell: `Alt + Enter`

❤️ Center cell contents: `Alt + H, A, C`

❤️ Remove filters: `Alt + D + F + F`

❤️ Open 'Remove Duplicates' dialog: `Alt + A + M`

❤️ Increase decimal places: `Alt + H + 0`

❤️ Decrease decimal places: `Alt + H + 9`

❤️ Wrap text in cell: `Alt + H + W`

❤️ Merge and center cells: `Alt + H + M + C`

❤️ Protect worksheet: `Alt + R + P + S`

❤️ Freeze panes: `Alt + W + F + F`

❤️ Split the window: `Alt + W + S`


 ❤️ **OTHER Shortcuts**


❤️ Edit active cell: `F2`

❤️ Go to beginning of row: `Home`

❤️ Move one cell right: `Tab`

❤️ Repeat last action: `F4`

❤️ Open Save As dialog: `F12`

❤️ Calculate all worksheets: `F9`



✅ Essential Mac Keyboard Shortcuts :-

❤️ ⌘ + A – Select all

❤️ ⌘ + C – Copy

❤️ ⌘ + X – Cut

❤️ ⌘ + V – Paste

❤️ ⌘ + Z – Undo

❤️ ⌘ + Shift + Z – Redo

❤️ ⌘ + S – Save

❤️ ⌘ + P – Print

❤️ ⌘ + Q – Quit the current app

❤️ ⌘ + W – Close the current window

❤️ ⌘ + Option + Esc – Force quit an app

❤️ ⌘ + Space – Open Spotlight search

❤️ ⌘ + Tab – Switch between open apps

❤️ ⌘ + Shift + 3 – Take screenshot of entire screen

❤️ ⌘ + Shift + 4 – Take screenshot of selected area

❤️ ⌘ + Shift + 5 – Open screenshot & screen recording options

❤️ ⌘ + N – New window/document (depending on app)

❤️ ⌘ + T – New tab (in Finder or browsers)

❤️ ⌘ + , (comma) – Open Preferences of current app

❤️ ⌘ + Delete – Move selected item to Trash


✅ Mac Shortcuts: ⌘ Command + 1 to 9

❤️ ⌘ + 1 – Show Column View in Finder

❤️ ⌘ + 2 – Show List View in Finder

❤️ ⌘ + 3 – Show Icon View in Finder

❤️ ⌘ + 4 – Show Gallery View in Finder

❤️ ⌘ + 5 – Open Top Sites or Start Page in Safari

❤️ ⌘ + 6 – Toggle the Sidebar in Safari

❤️ ⌘ + 7 – Open Reading List in Safari

❤️ ⌘ + 8 – Show Mail Activity in the Mail app

❤️ ⌘ + 9 – Go to the last open tab in Safari

0 comments:

Post a Comment