https://www.facebook.com/821077224428903/

Excel Shortcut Pro, Freetown (2026)

22/09/2026

🔹 Ctrl + Shift + $ – Apply Currency format 💰
🔹 Ctrl + Shift + % – Apply Percentage format
🔹 Ctrl + Shift + # – Apply Date format
🔹 Ctrl + Shift + @ – Apply Time format
🔹 Ctrl + Shift + ! – Apply Number format
🔹 Ctrl + Shift + ^ – Apply Scientific format
🔹 Ctrl + Shift + ~ – Apply General format
🔹 Ctrl + 1 – Open Format Cells
🔹 Ctrl + B – Apply/remove Bold
🔹 Ctrl + I – Apply/remove Italic
🔹 Ctrl + U – Apply/remove Underline
🔹 Ctrl + 5 – Apply/remove Strikethrough
🔹 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 + ; – Insert current date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + Space – Select entire column
🔹 Shift + Space – Select entire row
🔹 Ctrl + Home – Go to cell A1
🔹 Ctrl + End – Go to the last used cell
🔹 Ctrl + Page Up – Move to previous worksheet
🔹 Ctrl + Page Down – Move to next worksheet
🔹 Ctrl + Q – Open Quick Analysis
🔹 Ctrl + G – Open Go To
🔹 Alt + = – Insert AutoSum
🔹 F2 – Edit the active cell

--

✨ Quick Tip:
Use Ctrl + Shift + $ to instantly format selected numbers as currency. It’s especially useful when preparing salary, billing, sales, or financial reports. 💰📊

--

22/09/2026

🔹 Ctrl + Shift + @ – Apply time format ⏰

🔹 Ctrl + Shift + $ – Apply currency format

🔹 Ctrl + Shift + % – Apply percentage format

🔹 Ctrl + Shift + # – Apply date format

🔹 Ctrl + Shift + ^ – Apply scientific format

🔹 Ctrl + 1 – Open Format Cells dialog

🔹 Ctrl + D – Fill down

🔹 Ctrl + R – Fill right

🔹 Ctrl + T – Convert range to Excel Table

🔹 Ctrl + Shift + L – Toggle Filters ON / OFF

🔹 Ctrl + A – Select current data region; press again to select entire worksheet

🔹 Ctrl + Space – Select entire column

🔹 Shift + Space – Select entire row

🔹 Ctrl + Page Down – Move to next worksheet

🔹 Ctrl + Page Up – Move to previous worksheet

🔹 Ctrl + Home – Jump to cell A1

🔹 Ctrl + End – Go to last cell of the used range

🔹 Ctrl + Arrow Keys – Jump to the edge of the current data region

🔹 Ctrl + Shift + Arrow Keys – Extend selection to the edge of the current data region

🔹 Ctrl + ; – Insert today’s date

🔹 Ctrl + Shift + : – Insert current time

🔹 Ctrl + F – Find

🔹 Ctrl + H – Replace

🔹 Ctrl + Z – Undo last action

🔹 Ctrl + Y – Redo last undone action

🔹 Alt + = – Insert the SUM formula

🔹 Alt + Enter – New line inside a cell

🔹 Alt + A + E – Text to Columns

🔹 F2 – Edit active cell

🔹 Shift + F11 – Insert new worksheet

✨ Quick Tip:

Use Ctrl + Shift + @ to quickly format time values correctly — especially useful for logs and timestamps.

21/09/2026

● Ctrl + Shift + Esc – Open Task Manager
● Ctrl + Shift + N – Create a new folder
● Ctrl + Shift + V – Paste without formatting
● Ctrl + Shift + S – Save As
● Ctrl + Shift + E – Track Changes in Word
● Ctrl + Shift + W – Underline words only in Word
● Ctrl + Shift + D – Apply double underline in Word
● Ctrl + Shift + K – Apply small caps in Word
● Ctrl + Shift + A – Apply ALL CAPS in Word
● Ctrl + Shift + L – Apply bullet list in Word
● Ctrl + Shift + C – Copy formatting in Word
● Ctrl + Shift + F – Open Font settings
● Ctrl + Shift + P – Open Font Size settings
● Ctrl + Shift + > – Increase font size
● Ctrl + Shift + < – Decrease font size
● Ctrl + Shift + 7 – Apply borders in Excel
● Ctrl + Shift + U – Expand/collapse Formula Bar in Excel
● Ctrl + Shift + F3 – Create names from selected cells
● Ctrl + Shift + O – Select cells containing notes
● Ctrl + Shift + G – Open Workbook Statistics
● Ctrl + Shift + 1 – Apply Number format
● Ctrl + Shift + 2 – Apply Time format
● Ctrl + Shift + 3 – Apply Date format
● Ctrl + Shift + 4 – Apply Currency format
● Ctrl + Shift + 5 – Apply Percentage format
● Ctrl + Shift + 6 – Apply Scientific format
● Win + Ctrl + D – Create a new virtual desktop
● Win + Ctrl + F4 – Close the current virtual desktop
● Win + Ctrl + Left Arrow – Switch to the left virtual desktop
● Win + Ctrl + Right Arrow – Switch to the right virtual desktop
● Win + Shift + S – Capture a screen snip
● Win + Ctrl + Shift + B – Reset the graphics driver
● Win + Alt + R – Start/stop screen recording
● Win + Alt + Print Screen – Capture the active game window
● Ctrl + Shift + Tab – Move to the previous browser tab
● Ctrl + Shift + Page Up – Move the current tab left
● Ctrl + Shift + Page Down – Move the current tab right

21/09/2026

Here's my Excel handbook I use every day!

21/09/2026

● Ctrl + Shift + $ – Apply Currency format
● Ctrl + Shift + % – Apply Percentage format
● Ctrl + Shift + # – Apply Date format
● Ctrl + Shift + @ – Apply Time format
● Ctrl + Shift + ^ – Apply Scientific format
● Ctrl + Shift + ! – Apply Number format
● Ctrl + Shift + ~ – Apply General format
● Ctrl + Shift + & – Apply an outline border
● Ctrl + Shift + _ – Remove an outline border
● Ctrl + Shift + * – Select the current data region
● Ctrl + Shift + U – Expand or collapse the Formula Bar
● Ctrl + Shift + F3 – Create names from selected cells
● Ctrl + Shift + G – Open Workbook Statistics
● Ctrl + Shift + O – Select cells containing notes
● Ctrl + Q – Open Quick Analysis
● Ctrl + E – Flash Fill
● Ctrl + K – Insert a hyperlink
● Ctrl + G – Open the Go To dialog
● Ctrl + 5 – Apply or remove strikethrough
● Ctrl + 9 – Hide selected rows
● Ctrl + 0 – Hide selected columns
● Ctrl + W – Close the current workbook
● Ctrl + N – Create a new workbook
● Ctrl + O – Open an existing workbook
● Ctrl + P – Open the Print dialog
● Ctrl + F1 – Show or hide the Ribbon
● Ctrl + Shift + + – Insert cells, rows, or columns
● Ctrl + - – Delete cells, rows, or columns
● Ctrl + Alt + V – Open the Paste Special dialog
● Ctrl + Shift + V – Paste values or paste options
● Ctrl + Enter – Fill all selected cells with the current entry
● Ctrl + Backspace – Scroll the active cell into view
● Ctrl + Delete – Delete text to the end while editing a cell
● Alt + F8 – Open the Macro dialog
● Alt + F11 – Open the VBA Editor
● Alt + F1 – Create a chart in the current worksheet
● Alt + Down Arrow – Open a drop-down list
● Alt + A + G + G – Group selected rows or columns
● Alt + A + G + U – Ungroup selected rows or columns
● Alt + A + C – Clear filters from the current range
● Shift + F2 – Insert or edit a note
● F4 – Repeat the last action / cycle formula references
● F5 – Open the Go To dialog
● F7 – Check spelling
● F9 – Recalculate formulas
● F11 – Create a chart on a separate chart sheet
● Shift + F11 – Insert a new worksheet
● Ctrl + Page Up – Move to the previous worksheet
● Ctrl + Page Down – Move to the next worksheet
● Ctrl + Shift + Page Up – Select the previous worksheet
● Ctrl + Shift + Page Down – Select the next worksheet

21/09/2026

🔹 Ctrl + E – Flash Fill ⚡
🔹 Ctrl + T – Convert a range into an Excel Table
🔹 Ctrl + Shift + L – Turn Filters ON/OFF
🔹 Ctrl + D – Fill Down
🔹 Ctrl + R – Fill Right
🔹 Ctrl + Enter – Fill selected cells with the same entry
🔹 Ctrl + Shift + Enter – Enter a legacy array formula
🔹 Ctrl + Q – Open Quick Analysis
🔹 Ctrl + G – Open Go To
🔹 Ctrl + K – Insert a hyperlink
🔹 Ctrl + F – Find data
🔹 Ctrl + H – Find & Replace
🔹 Ctrl + Space – Select entire column
🔹 Shift + Space – Select entire row
🔹 Ctrl + ↑ / ↓ – Jump to the edge of a data region
🔹 Ctrl + ← / → – Jump to the edge of a data region
🔹 Ctrl + Shift + ↑ / ↓ – Select data up/down
🔹 Ctrl + Shift + ← / → – Select data left/right
🔹 Ctrl + Home – Go to cell A1
🔹 Ctrl + End – Go to the last used cell
🔹 Ctrl + Page Up – Move to previous worksheet
🔹 Ctrl + Page Down – Move to next worksheet
🔹 Ctrl + ; – Insert today’s date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + 1 – Open Format Cells
🔹 Ctrl + 5 – Apply/remove strikethrough
🔹 Ctrl + 9 – Hide selected rows
🔹 Ctrl + 0 – Hide selected columns
🔹 Alt + = – Insert AutoSum

--

✨ Quick Tip:
Use Ctrl + E for Flash Fill. Enter an example of the pattern you want in the first cell, then press Ctrl + E—Excel can automatically recognize and fill the remaining values. ⚡📊

--

20/09/2026

● Ctrl + Shift + L – Turn AutoFilter ON / OFF

● F2 – Edit the active cell

● Alt + A + M – Remove Duplicates

● Ctrl + Home – Go to the beginning of the worksheet

● Ctrl + E – Flash Fill

● Ctrl + Shift + + – Insert cells, rows, or columns

● Alt + = – AutoSum

● Ctrl + Page Down – Move to the next worksheet

● Ctrl + 5 – Apply or remove strikethrough

● Alt + A + S + D – Sort data Z → A / Largest → Smallest

● Ctrl + K – Insert a hyperlink

● Shift + F11 – Insert a new worksheet

● Ctrl + Space – Select the entire column

● Alt + A + E – Open Text to Columns

● Ctrl + Q – Open Quick Analysis

● Ctrl + End – Go to the last used cell

● Alt + A + G + G – Group rows or columns

● Ctrl + 1 – Open the Format Cells dialog

● Ctrl + Shift + : – Insert the current time

● Ctrl + T – Convert a range into an Excel Table

● Alt + A + C – Clear active filters

● Ctrl + Page Up – Move to the previous worksheet

● Shift + Space – Select the entire row

● Ctrl + G – Open the Go To dialog

● Alt + A + S + A – Sort data A → Z / Smallest → Largest

● Ctrl + 9 – Hide selected rows

● Ctrl + ; – Insert the current date

● F4 – Repeat the last action / cycle formula references

● Alt + A + G + U – Ungroup rows or columns

● Ctrl + 0 – Hide selected columns

● Ctrl + Shift + S – Open Save As in supported Excel versions

● Ctrl + Shift + F – Open Font options

● Ctrl + Shift + P – Open Font Size options

● Ctrl + Shift + G – Open Workbook Statistics

● Ctrl + Shift + * – Select the current data region

● Ctrl + Shift + Home – Extend the selection to the beginning of the worksheet

● Ctrl + Shift + End – Extend the selection to the last used cell

● Ctrl + Alt + V – Open the Paste Special dialog

● Ctrl + Shift + V – Paste values/options in supported Excel versions

● Ctrl + D – Fill Down

● Ctrl + R – Fill Right

● Ctrl + F – Find data

● Ctrl + H – Find and Replace

● F7 – Check spelling

● F9 – Recalculate formulas

● F11 – Create a chart sheet

● Alt + F1 – Create an embedded chart

● Alt + Down Arrow – Open a cell's drop-down list

● Ctrl + Shift + Page Up – Select the current and previous worksheet

● Ctrl + Shift + Page Down – Select the current and next worksheet

● Ctrl + Arrow Key – Jump to the edge of the current data region

● Ctrl + Shift + Arrow Key – Extend selection to the edge of the data region

● Ctrl + Shift + 1 – Apply Number format

● Ctrl + Shift + 2 – Apply Time format

● Ctrl + Shift + 3 – Apply Date format

● Ctrl + Shift + 4 – Apply Currency format

● Ctrl + Shift + 5 – Apply Percentage format

● Ctrl + Shift + 6 – Apply Scientific format

● Ctrl + Shift + 7 – Apply Outline Border

● Ctrl + Shift + 8 – Show/hide outline symbols

20/09/2026

🔹 Ctrl + Shift + V – Paste values only (no formulas, no formatting)

🔹 Ctrl + Alt + V – Open Paste Special dialog

🔹 Ctrl + C – Copy

🔹 Ctrl + X – Cut

🔹 Ctrl + V – Paste

🔹 Ctrl + Z – Undo last action

🔹 Ctrl + Y – Redo last undone action

🔹 Ctrl + D – Fill down

🔹 Ctrl + R – Fill right

🔹 Ctrl + T – Convert range to Excel Table

🔹 Ctrl + Shift + L – Toggle Filters ON/OFF

🔹 Ctrl + A – Select current data region; press again to select the entire worksheet

🔹 Ctrl + Space – Select entire column

🔹 Shift + Space – Select entire row

🔹 Ctrl + ; – Insert today’s date

🔹 Ctrl + Shift + : – Insert current time

🔹 Ctrl + 1 – Open Format Cells dialog

🔹 Ctrl + F – Find

🔹 Ctrl + H – Replace

🔹 Ctrl + Page Up – Move to previous worksheet

🔹 Ctrl + Page Down – Move to next worksheet

🔹 Ctrl + Arrow Keys – Jump to data edges

🔹 Ctrl + Shift + Arrow Keys – Select data to the edge of the current data region

🔹 Alt + = – Auto-insert SUM

🔹 Alt + Enter – New line inside a cell

🔹 Alt + H + O + I – Auto-fit column width

🔹 Alt + A + E – Text to Columns

🔹 Alt + A + M – Remove duplicates

🔹 F2 – Edit active cell

✨ Quick Tip:

Use Ctrl + Shift + V when cleaning data — it pastes only values, helping you avoid unwanted formulas and formatting!

18/09/2026

100 Excel Shortcuts!

18/09/2026

How to Use the DATE Function in Excel (Step by Step)

Perfect for beginners who want to combine separate date parts into one working date instantly.

Excel Shortcut Pro

22/09/2026

22/09/2026

21/09/2026

21/09/2026

21/09/2026

21/09/2026

20/09/2026

20/09/2026

18/09/2026

18/09/2026

Address

Website

Alerts

Shortcuts

Share

Category

Listing takedown request