Ikeworld Institute

30 important Excel shortcuts keys at a glance.


Ikeworld Institute for more update

tips

Know all about

Know your Keyboard

❤️ 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`
✅ MS Word के लिए Ctrl + 1 से 9 के शॉर्टकट
✨ Ctrl + 1 – Single line spacing सेट करता है
✨ Ctrl + 2 – Double line spacing सेट करता है
✨ Ctrl + 3 – 1.5 line spacing सेट करता है
✨ Ctrl + 4 – कोई default function नहीं (कस्टम यूज़ किया जा सकता है)
✨ Ctrl + 5 – Alternate 1.5 line spacing (कभी-कभी इस्तेमाल होता है)
✨ Ctrl + 6 – कोई default function नहीं
✨ Ctrl + 7 – कोई default function नहीं
✨ Ctrl + 8 – कोई default function नहीं
✨ Ctrl + 9 – कोई default function नहीं
✅ PowerPoint के लिए Ctrl + 1 से 9 के शॉर्टकट
✨ Ctrl + 1 – Normal view पर स्विच करता है
✨ Ctrl + 2 – (कोई default function नहीं)
✨ Ctrl + 3 – (कोई default function नहीं)
✨ Ctrl + 4 – (कोई default function नहीं)
✨ Ctrl + 5 – (कोई default function नहीं)
✨ Ctrl + 6 – (कोई default function नहीं)
✨ Ctrl + 7 – (कोई default function नहीं)
✨ Ctrl + 8 – (कोई default function नहीं)
✨ Ctrl + 9 – (कोई default function नहीं)
📝 Note: PowerPoint में Ctrl + 1 ही सबसे ज़्यादा commonly used है (Normal view के लिए)। बाकी keys ज़्यादातर custom shortcuts या add-ins के लिए खाली होती हैं।
✅ 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

Visit our website for admission

ikeworldinstitute.com

अंग्रेजों के जमाने का टैक्स सिस्टम ऐसा होता था, सेठों की हवेली में देखों 😮🇮🇳 #history #travel #india #amazing #antique #traveling #historical #ancient

All the students of Ikeworld Institute are request to submit your CV to participate Job Fair

Take admission to Sikkim Skill University contact us

Now We are Study Partner of Sikkim Skill University.

Contact for admission to 6291111711