HimraTech

Master MS Word faster with these essential shortcut keys! 💻⚡ Save this cheat sheet for later.

Master Windows Shortcuts A–Z

Boost your productivity with this quick Windows Key Shortcuts A–Z cheat sheet. From Win + A for Quick Settings to Win + Z for Snap Layouts, these shortcuts can help you navigate Windows faster and work smarter.

Excel Shortcut You Need to Know: Ctrl + N! ⌨️📊
🔹 Ctrl + N – Create a new workbook
🔹 Ctrl + O – Open an existing workbook
🔹 Ctrl + S – Save the current workbook
🔹 Ctrl + W – Close the active workbook
🔹 Ctrl + F6 – Switch between open workbook windows
🔹 Ctrl + Tab – Switch between open Excel workbooks
🔹 Ctrl + Page Down – Move to the next worksheet
🔹 Ctrl + Page Up – Move to the previous worksheet
🔹 Ctrl + Home – Jump to cell A1
🔹 Ctrl + End – Go to the last used cell
🔹 Ctrl + G – Open the Go To dialog
🔹 Ctrl + F – Find text or values
🔹 Ctrl + H – Find and replace text or values
🔹 Ctrl + K – Insert a hyperlink
🔹 Ctrl + T – Convert range into an Excel Table
🔹 Ctrl + Shift + L – Turn Filters ON / OFF
🔹 Ctrl + E – Flash Fill
🔹 Ctrl + D – Fill down
🔹 Ctrl + R – Fill right
🔹 Ctrl + Enter – Fill selected cells with the same entry
🔹 Ctrl + 1 – Open Format Cells dialog
🔹 Ctrl + ; – Insert today’s date
🔹 Ctrl + Shift + : – Insert current time
🔹 Alt + = – Auto-insert SUM
🔹 F2 – Edit the active cell
🔹 F4 – Repeat last action / toggle absolute references
🔹 Shift + F11 – Insert a new worksheet

✨ Quick Tip:
Use Ctrl + N to quickly create a new Excel workbook without reaching for the mouse. ⚡📊

📌 Save this shortcut and add it to your Excel cheat sheet!

💬 How often do you use Ctrl + N? 👇
Follow for more Excel shortcuts, Microsoft Office tips, and computer tricks! 🚀

🔹 Alt + H + F + C – Open the Font Color menu 🎨
🔹 Alt + H + F + F – Open the Font dropdown
🔹 Alt + H + F + S – Change font size
🔹 Alt + H + F + G – Increase font size
🔹 Alt + H + F + K – Decrease font size
🔹 Alt + H + A + T – Align text to the top
🔹 Alt + H + A + M – Middle-align text vertically
🔹 Alt + H + A + B – Align text to the bottom
🔹 Alt + H + A + C – Center-align text horizontally
🔹 Alt + H + 6 – Increase decimal places
🔹 Alt + H + 5 – Decrease decimal places
🔹 Alt + H + 0 – Apply Percentage format
🔹 Alt + H + 9 – Apply Number format
🔹 Alt + H + 4 – Apply Currency format
🔹 Alt + H + K – Open Number Format menu
🔹 Alt + H + O + I – AutoFit column width
🔹 Alt + H + O + A – AutoFit row height
🔹 Alt + H + W – Wrap text
🔹 Alt + H + M + C – Merge & Center
🔹 Alt + H + M + U – Unmerge cells
🔹 Alt + H + B + A – Apply All Borders
🔹 Alt + H + B + N – Remove borders
🔹 Alt + H + D + C – Delete selected columns
🔹 Alt + H + D + R – Delete selected rows
🔹 Alt + H + I + C – Insert columns
🔹 Alt + H + I + R – Insert rows
🔹 Ctrl + Shift + 1 – Apply Number format
🔹 Ctrl + Shift + 2 – Apply Time format
🔹 Ctrl + Shift + 3 – Apply Date format
🔹 Ctrl + Shift + 4 – Apply Currency format

✨ Quick Tip:
Use Alt + H + F + C to quickly change the font color of selected cells. It’s especially useful for highlighting KPIs, totals, warnings, and important values in reports.

25 Excel Shortcuts That Will Make You Look Like a PRO! ⌨️🔥

🔹 Ctrl + E → Flash Fill
🔹 Ctrl + Alt + F5 → Refresh all external data
🔹 Alt + F5 → Refresh external data
🔹 Ctrl + Shift + Alt + F9 → Force a full recalculation
🔹 F8 → Turn Extend Selection mode ON/OFF
🔹 Shift + F8 → Add a non-adjacent range to your selection
🔹 Ctrl + . → Move the active cell through the corners of a selected range
🔹 Ctrl + Alt + Right Arrow → Move to the next selected range
🔹 Ctrl + Alt + Left Arrow → Move to the previous selected range
🔹 Shift + Home → Select from the active cell to the beginning of the row
🔹 Shift + End → Select from the active cell to the end of the row
🔹 Ctrl + Shift + Page Down → Select the current and next worksheet
🔹 Ctrl + Shift + Page Up → Select the current and previous worksheet
🔹 Ctrl + Shift + F1 → Toggle full-screen mode
🔹 F1 → Open Excel Help
🔹 F6 → Move between worksheet, ribbon, task pane, and other areas
🔹 Ctrl + F4 → Close the active workbook window
🔹 F10 → Activate Key Tips for the Ribbon
🔹 F12 → Open the Save As dialog
🔹 Ctrl + Alt + = → Zoom in
🔹 Ctrl + Alt + - → Zoom out
🔹 Ctrl + Esc → Close a dialog box or cancel a process
🔹 Ctrl + Shift + * → Select the current data region
🔹 Ctrl + Shift + > → Increase font size
🔹 Ctrl + Shift + < → Decrease font size

💡 PRO TIP:
Don't try to memorize all 25 at once. Start with the shortcuts you use most often, then gradually add the advanced ones to your workflow. ⚡

📌 Save this list and share it with an Excel user!
💬 How many of these shortcuts did you already know? 👇

Follow for more Excel shortcuts, Microsoft Office tips, networking, and computer tricks! 🚀

Ctrl shortcuts keys

🌐 Understanding Network Devices — The Foundation of Every Network

Through my hands-on experience in networking, I’ve learned that understanding what each network device does is just as important as knowing how to configure it.

Different devices have different roles, but together they form the foundation of a reliable network:

🔹 Router → Connects different networks and routes traffic
🔹 Switch → Connects devices within a LAN
🔹 Firewall → Helps protect networks by controlling traffic
🔹 Access Point → Provides wireless network connectivity
🔹 Modem → Connects a network to an Internet service
🔹 Bridge → Connects and filters traffic between network segments
🔹 Repeater → Extends a network signal
🔹 Hub → Connects multiple devices but broadcasts traffic to all ports

Working with these devices in real-world environments and network labs has helped me understand that networking isn't just about memorizing definitions—it's about knowing why, where, and when each device should be used.

💡 Strong networking fundamentals are built through continuous learning, practice, and hands-on experience.

💬 Which network device do you work with the most?

👉 Router
👉 Switch
👉 Firewall
👉 Access Point

Share your answer below! 👇

🔹 Ctrl + D – Fill selected cells downward
🔹 Ctrl + Enter – Fill selected cells with the same entry
🔹 Ctrl + E – Flash Fill
🔹 Ctrl + T – Convert range into an Excel Table
🔹 Ctrl + Shift + L – Turn Filters ON / OFF
🔹 Ctrl + Q – Open Quick Analysis tool
🔹 Ctrl + C – Copy selected cells
🔹 Ctrl + X – Cut selected cells
🔹 Ctrl + V – Paste copied content
🔹 Ctrl + Z – Undo last action
🔹 Ctrl + Y – Redo last action
🔹 Ctrl + F – Find text or values
🔹 Ctrl + H – Replace text or values
🔹 Ctrl + G – Open Go To dialog
🔹 Ctrl + K – Insert hyperlink
🔹 Ctrl + A – Select current data region
🔹 Ctrl + Space – Select entire column
🔹 Shift + Space – Select entire row
🔹 Ctrl + Home – Jump to cell A1
🔹 Ctrl + End – Go to last used cell
🔹 Ctrl + Page Down – Move to next worksheet
🔹 Ctrl + Page Up – Move to previous worksheet
🔹 Ctrl + ; – Insert today’s date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + 1 – Open Format Cells dialog
🔹 Ctrl + Shift + $ – Apply Currency format
🔹 Ctrl + Shift + % – Apply Percentage format
🔹 F2 – Edit the active cell
🔹 Alt + = – Auto-insert SUM

✨ Quick Tip:
Use **Ctrl + D** to quickly fill the contents or formula from the **top cell into the selected cells below**. 🚀

📌 Save this shortcut and try it in your next Excel worksheet!

💬 Do you use **Ctrl + D** regularly? 👇

Follow for more Excel shortcuts, Microsoft Office tips, and computer tricks! 💻🔥

Excel Keyboard Shortcuts You Need

🔹 Ctrl + Space – Select the entire column
🔹 Ctrl + A – Select the current data region
🔹 Ctrl + Home – Jump to cell A1
🔹 Ctrl + End – Go to the last used cell
🔹 Ctrl + ↑ – Jump to the top of the data region
🔹 Ctrl + ↓ – Jump to the bottom of the data region
🔹 Ctrl + ← – Jump to the left edge of the data region
🔹 Ctrl + → – Jump to the right edge of the data region
🔹 Ctrl + Shift + ↑ – Select data upward
🔹 Ctrl + Shift + ↓ – Select data downward
🔹 Ctrl + Shift + ← – Select data to the left
🔹 Ctrl + Shift + → – Select data to the right
🔹 Ctrl + T – Convert range into an Excel Table
🔹 Ctrl + Shift + L – Turn Filters ON / OFF
🔹 Ctrl + D – Fill down
🔹 Ctrl + R – Fill right
🔹 Ctrl + E – Flash Fill
🔹 Ctrl + Q – Open Quick Analysis tool
🔹 Ctrl + F – Find text or values
🔹 Ctrl + H – Replace text or values
🔹 Ctrl + G – Open Go To dialog
🔹 Ctrl + K – Insert hyperlink
🔹 Ctrl + ; – Insert today’s date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + 1 – Open Format Cells dialog
🔹 Ctrl + Z – Undo last action
🔹 Ctrl + Y – Redo last action
🔹 F2 – Edit the active cell
🔹 Alt + = – Auto-insert SUM

✨ Quick Tip:
Use **Ctrl + Space** to instantly select the **entire column** containing your active cell—perfect for quickly formatting, deleting, copying, or analyzing a full column without reaching for the mouse.

Follow for more Excel tips, keyboard shortcuts, and Microsoft Office tutorials! 🚀