AppTech Computer

18/10/2025

Microsoft Excel Shortcut keys.

🔹 Ctrl + 5 - Apply/Remove strikethrough
🔹 Ctrl + E - Flash Fill
🔹 Alt + H + F + F - Change font
🔹 Alt + H + O + I - AutoFit column width
🔹 Alt + = - AutoSum
🔹 Ctrl + ; - Insert current date
🔹 Ctrl + Shift + ; - Insert current time
🔹 Ctrl + 1 - Format Cells dialog
🔹 Ctrl + T - Create table
🔹 Ctrl + Space - Select entire column
🔹 Shift + Space - Select entire row
🔹 Ctrl + Arrow Keys - Navigate data edges
🔹 Ctrl + Shift + L - Toggle filters
🔹 Alt + N + V - Insert PivotTable
🔹 Alt + A + M - Remove duplicates
🔹 Ctrl + D - Fill down
🔹 Ctrl + R - Fill right
🔹 Ctrl + - (Minus) - Delete selection
🔹 Ctrl + Shift + + (Plus) - Insert cells
🔹 Alt + E + S + V - Paste values
🔹 Alt + H + O + A - AutoFit row height
🔹 F2 - Edit active cell
🔹 F4 - Repeat last action/Toggle references
🔹 F9 - Calculate worksheets
🔹 Shift + F3 - Insert function
🔹 Ctrl + F3 - Name Manager
🔹 Alt + F1 - Create embedded chart
🔹 F11 - Create chart in new sheet
🔹 Ctrl + Shift + $ - Currency format
🔹 Ctrl + Shift + % - Percentage format

Strikethrough Tip: Use Ctrl + 5 to mark completed tasks while keeping them visible!

Follow 👉 Apptech Computer

17/10/2025

Which key is used to rename a file?

07/10/2025

Starlink kit V2, V3, V4 and starlink mini are available. we also have a starlink mesh router, cables, adapter, WavLink and Mikrotik router.

Contact Us on: +2347034344453

26/08/2025

Follow to acquire computer knowledge from scratch.

video tutorial will be coming your way.

25/08/2025

Adjust brightness level in windows 10.

Click on the video 👇

Please follow our page and share the video.

21/08/2025

Password your computer system in simple steps.

Click on the video 👇 and follow this page for more educational videos.

20/08/2025

The Most common computer shortcut keys include the following:
Ctrl+C (copy), Ctrl+X (cut), Ctrl+V (paste), Ctrl+Z (undo), Ctrl+A (select all), Ctrl+S (save), and Ctrl+F (find). Alt + Tab switches between open applications, and Alt + F4 closes the current window or application.

Here's a more detailed breakdown:

General/File Management:
✓Ctrl + A: Select All
✓Ctrl + C: Copy
✓Ctrl + X: Cut
✓Ctrl + V: Paste
✓Ctrl + Z: Undo
✓Ctrl + Y: Redo
✓Ctrl + S: Save
✓Ctrl + P: Print
✓Ctrl + O: Open
✓Ctrl + N: New
✓Ctrl + W: Close active window
✓Alt + F4: Close active window or application
✓Ctrl + F: Find

Navigation:
✓Alt + Tab: Switch between open windows/. applications
✓Windows Key + D: Show desktop
✓Windows Key + L: Lock computer
Home: Go to beginning of line
End: Go to end of line
✓Ctrl + Left/Right Arrow: Jump to beginning of previous/next word

Text Manipulation:
✓Ctrl + B: Bold
✓Ctrl + I: Italics
✓Ctrl + U: Underline
✓Ctrl + Shift + V: Paste without formatting

Other Useful Shortcuts:
✓Ctrl + Shift + Esc: Open Task Manager
✓Ctrl + Shift + T: Reopen closed browser tabs
✓Windows Key + E: Open File Explorer
✓Ctrl + T (in File Explorer): Open a new tab
✓Windows Key + I: Open Settings
✓PrtScn: Take a screenshot
✓Windows Key + Print Screen: Take a full screenshot and save it.

19/08/2025

Change font size on windows 10.

Click on the video below 👇

18/08/2025

How to uninstall software on windows 10...

Click on the video 👇

12/08/2025

12/08/2025

Create a partition from unpartitioned C drive space with these steps:

Click on the video 👇