Mdombo Computer College

Mdombo Computer College An Accredited computer based college that provides high quality training and education to the people of who lacked such opportunity Computer college of choice

23/09/2025
31/08/2025
31/08/2025

πŸ”Ή Ctrl + 0 – Hide selected columns
πŸ”Ή Ctrl + 9 – Hide selected rows
πŸ”Ή Ctrl + Shift + ) – Unhide columns
πŸ”Ή Ctrl + Shift + ( – Unhide rows
πŸ”Ή Ctrl + T – Create Excel table
πŸ”Ή Ctrl + Q – Quick Analysis tool
πŸ”Ή Alt + A + V + V – Data Validation dropdown
πŸ”Ή Alt + N + V – Insert PivotTable
πŸ”Ή Ctrl + Shift + L – Add/Remove filters
πŸ”Ή Ctrl + Arrow Keys – Jump to data edges
πŸ”Ή Ctrl + Shift + Arrow Keys – Select data range
πŸ”Ή Ctrl + Shift + "+" – Insert new cell/row/column
πŸ”Ή Ctrl + - – Delete selected cell/row/column
πŸ”Ή Ctrl + A – Select entire worksheet
πŸ”Ή Ctrl + D – Fill down
πŸ”Ή Ctrl + R – Fill right
πŸ”Ή Alt + E + S + V – Paste Values
πŸ”Ή Alt + H + F + P – Font dropdown
πŸ”Ή Alt + H + O + I – AutoFit column width
πŸ”Ή Ctrl + K – Insert hyperlink
πŸ”Ή F2 – Edit active cell
πŸ”Ή Ctrl + ` – Toggle formulas view
πŸ”Ή Ctrl + ; – Insert current date
πŸ”Ή Ctrl + : – Insert current time
πŸ”Ή Ctrl + 1 – Format Cells dialog
πŸ”Ή Ctrl + B – Bold
πŸ”Ή Ctrl + I – Italic
πŸ”Ή Ctrl + U – Underline
πŸ”Ή Ctrl + Z – Undo
πŸ”Ή Ctrl + Y – Redo

πŸ”Ή Alt + M + S - Sort A to Z
πŸ”Ή Alt + M + O - Sort Z to A
πŸ”Ή Alt + M + F - Open custom sort dialog
πŸ”Ή Alt + A + F + A - Apply advanced filter
πŸ”Ή Alt + A + Q - Open query editor (Power Query)
πŸ”Ή Alt + H + F + I - Increase decimal places
πŸ”Ή Alt + H + F + D - Decrease decimal places
πŸ”Ή Ctrl + Shift + 7 - Apply outline border (alternative)
πŸ”Ή Ctrl + Shift + 8 - Select current region (alternative)
πŸ”Ή Alt + H + F + T - Apply text format
πŸ”Ή Alt + H + F + E - Apply exponential format
πŸ”Ή Alt + H + J - Justify text alignment
πŸ”Ή Alt + H + F + A - Align text to middle
πŸ”Ή Alt + H + B + D - Apply double underline
πŸ”Ή Alt + H + B + S - Apply thick bottom border
πŸ”Ή Alt + H + B + P - Apply top and bottom border
πŸ”Ή Alt + H + B + O - Apply thick box border
πŸ”Ή Ctrl + Shift + 1 - Number format with commas
πŸ”Ή Ctrl + Shift + 2 - Time format (alternative)
πŸ”Ή Ctrl + Shift + 3 - Date format (alternative)
πŸ”Ή Ctrl + Shift + 4 - Currency format (alternative)
πŸ”Ή Ctrl + Shift + 5 - Percentage format (alternative)
πŸ”Ή Ctrl + Shift + 6 - Scientific format (alternative)
πŸ”Ή Alt + H + V + C - Paste comments
πŸ”Ή Alt + H + V + N - Paste validation
πŸ”Ή Alt + H + V + R - Paste formulas and number formats
πŸ”Ή Alt + H + V + E - Paste transpose
πŸ”Ή Alt + H + D + S - Delete sheet
πŸ”Ή Alt + H + I + W - Insert worksheet
πŸ”Ή Alt + H + R - Rename worksheet
πŸ”Ή Alt + H + M + U - Unmerge cells
πŸ”Ή Alt + H + M + M - Merge across
πŸ”Ή Alt + H + L + N - Apply new conditional formatting rule
πŸ”Ή Alt + H + L + C - Clear conditional formatting
πŸ”Ή Alt + A + T - Apply table style
πŸ”Ή Alt + A + B - Convert table to range
πŸ”Ή Ctrl + Shift + G - Open Go To Special dialog
πŸ”Ή Ctrl + G - Open Go To dialog
πŸ”Ή Alt + H + S + H - Apply cell style
πŸ”Ή Alt + H + S + C - Clear cell styles
πŸ”Ή Alt + N + X - Insert text box
πŸ”Ή Alt + N + C - Insert connector shape
πŸ”Ή Alt + N + M - Insert SmartArt
πŸ”Ή Alt + W + S - Split panes
πŸ”Ή Alt + W + I - Switch to Page Layout view
πŸ”Ή Alt + W + P - Switch to Print Preview
πŸ”Ή Alt + W + N - Switch to Normal view
πŸ”Ή Alt + W + R - Switch to Reading view
πŸ”Ή Ctrl + Shift + K - Group selected worksheets
πŸ”Ή Ctrl + Shift + J - Ungroup worksheets
πŸ”Ή Alt + H + F + Q - Increase indent
πŸ”Ή Alt + H + F + W - Decrease indent
πŸ”Ή Ctrl + Alt + V - Open Paste Special dialog
πŸ”Ή Ctrl + Shift + M - Add or edit comment (alternative)
πŸ”Ή Alt + H + E + L - Clear hyperlinks
πŸ”Ή Alt + N + H - Insert header/footer
πŸ”Ή Alt + A + G + G - Group data (in PivotTable or outline)
πŸ”Ή Alt + A + G + U - Ungroup data
πŸ”Ή Alt + H + V + D - Paste data validation only
πŸ”Ή Ctrl + Shift + R - Select visible cells only

Sort A to Z Tip: Use Alt + M + S to quickly sort your data alphabetically or numerically in ascending order for organized, easy-to-read spreadsheets!


πŸ”Ή Alt + Down Arrow: Open the drop-down menu for the active filter or AutoFilter cell
πŸ”Ή Ctrl + T: Create a Table from the selected data range
πŸ”Ή Alt + N + V: Create a PivotTable from the selected data
πŸ”Ή Ctrl + Shift + L: Toggle AutoFilter on/off for the current data range
πŸ”Ή Alt + D + F + F: Re-apply all filters in the current range
πŸ”Ή Spacebar: Check/uncheck a checkbox in a filter drop-down menu
πŸ”Ή Alt + C: Clear the slicer filter (when a slicer is selected)
πŸ”Ή Ctrl + F6: Switch to the next open workbook window
πŸ”Ή Ctrl + Shift + F6: Switch to the previous open workbook window
πŸ”Ή Ctrl + F9: Minimize the current workbook window
πŸ”Ή Ctrl + F10: Maximize or restore the current workbook window
πŸ”Ή Alt + Tab: Switch to the next open application window (Windows OS shortcut)
πŸ”Ή F7: Run a spell check on the active worksheet
πŸ”Ή Shift + F7: Open the Thesaurus for the selected word
πŸ”Ή Ctrl + F3: Open the Name Manager to define, edit, or delete named ranges
πŸ”Ή F3: Paste a named range into a formula
πŸ”Ή Alt + F8: Open the Macro dialog to run, edit, or create a macro
πŸ”Ή Alt + F11: Open the Visual Basic for Applications (VBA) editor

βœͺ Excel Shortcut Keys (Formatting & Sheet Management)

πŸ’– Borders & Formatting

ALT + H + B + A β€” All Border

ALT + H + B + T β€” Thick Outside Border

ALT + H + B + N β€” No Border

ALT + H + B + M β€” More Border

ALT + H + F + F β€” Font Style

ALT + H + F + S β€” Font Size

ALT + H + H β€” Fill Color

ALT + H + F + C β€” Font Color

πŸ’™ Alignment & Merge

ALT + H + M + C β€” Merge Cells

ALT + H + A + M β€” Middle Alignment

ALT + H + A + C β€” Center Alignment

ALT + H + W β€” Wrap Text

πŸ’› Number & Conditional Formatting

ALT + H + N β€” Number Formats

ALT + H + L β€” Conditional Formatting

ALT + H + L + C + S β€” Clear Conditional Formatting

πŸ’š Column & Row Size

ALT + H + O + I β€” Autofit Column Width

ALT + H + O + W β€” Fit Column Width

ALT + H + O + A β€” Autofit Row Height

ALT + H + O + H β€” Fit Row Height

πŸ’– Hide & Unhide

ALT + H + O + U + S β€” Hide Sheet

ALT + H + O + U + H β€” Unhide Sheet

ALT + H + O + U + C β€” Hide Column

ALT + H + O + U + L β€” Unhide Column

ALT + H + O + U + R β€” Hide Rows

ALT + H + O + U + O β€” Unhide Rows

πŸ’™ Sheet Operations

ALT + H + O + R β€” Rename Sheet

ALT + H + O + M β€” Move or Copy Sheet

ALT + H + O + T β€” Color Sheet Tab

ALT + H + D + L β€” Delete Sheet

πŸ’› Clear Options

ALT + H + E + A β€” Clear All

ALT + H + E + F β€” Clear Format

ALT + H + E + C β€” Clear Content

πŸ’š Paste Special

ALT + CTRL + V β€” Open Paste Special Window

ALT + H + V β€” Go to Paste Special

Best Excel Formulas Jo Seekh Liya To Boss Ban Gaye! Office Mein Koi Fasane Wala Nahin!

12 VIMP Excel Formulas You MUST Know:

=VLOOKUP() – Perfect for finding data in large tables. Use it to fetch values from another column based on a lookup value.

=IF() – Use this to apply logic: If something is true, do this; otherwise, do that. Great for conditional decisions.

=SUM() – Add values in a range instantly. This is the formula every beginner and pro needs.

=COUNT() – Want to count numbers in a range? This does it fast and accurately.

=COUNTA() – Counts both numbers and text. Useful when you want to know how many filled cells are there.

=LEN() – Measures the length of a text or number. Very handy for cleaning up data.

=TRIM() – Removes unwanted spaces from text. Data cleaning made easy!

=CONCATENATE() / =TEXTJOIN() – Combine text from multiple cells into one. Ideal for joining names, addresses, etc.

=LEFT(), =RIGHT(), =MID() – Extract characters from strings. Great for breaking down codes or names.

=TODAY() / =NOW() – Insert current date or time automatically. Best for reports and logs.

=IFERROR() – Replaces errors with a clean message. Makes your sheet look pro and error-free.

=INDEX() + MATCH() – More powerful than VLOOKUP. Use when you want flexibility in row-column lookups.

Follow for more such Excel Gyaan & Office Survival Tricks!


γ‚šviralγ‚·fypγ‚·γ‚šviralγ‚·

11/08/2025

Abbreviations

03/08/2025

πŸ”Ή Ctrl + Shift + 4 – Currency format
πŸ”Ή Ctrl + Shift + 2 – Time format
πŸ”Ή Ctrl + Page Down – Next sheet
πŸ”Ή Ctrl + Space – Select entire column
πŸ”Ή Ctrl + Alt + = – Insert rows/columns
πŸ”Ή Alt + F8 – Open macro editor (Google Apps Script)
πŸ”Ή Ctrl + Shift + L – Toggle filters
πŸ”Ή Ctrl + T – Create table
πŸ”Ή Alt + O + R + A – Auto-fit row height
πŸ”Ή Ctrl + Shift + 1 – Number format
πŸ”Ή Ctrl + + (Plus) – Insert cells dialog
πŸ”Ή Alt + O + C + A – Auto-fit column width
πŸ”Ή Alt + A + M – Remove duplicates
πŸ”Ή Alt + V + Z – Freeze panes
πŸ”Ή Shift + Space – Select entire row
πŸ”Ή Ctrl + Shift + \` – General number format
πŸ”Ή F9 – Recalculate formulas
πŸ”Ή Ctrl + Page Up – Previous sheet
πŸ”Ή F2 – Edit active cell
πŸ”Ή Alt + W + S – Split window
πŸ”Ή Alt + N + P – Create PivotTable
πŸ”Ή Alt + Tab – Switch between applications
πŸ”Ή Ctrl + Shift + 3 – Date format
πŸ”Ή Ctrl + - (Minus) – Delete selection
πŸ”Ή Ctrl + Tab – Switch browser tabs
πŸ”Ή Ctrl + Shift + V – Paste values only
πŸ”Ή Shift + F3 – Insert function dialog
πŸ”Ή Ctrl + F3 – Open named ranges manager
πŸ”Ή Ctrl + Shift + 5 – Percentage format
πŸ”Ή F4 – Toggle absolute/relative references

πŸ’‘ Pro Tip: Use `Ctrl + Shift + L` to instantly add or remove filters from your data headers!

Here are 30 Windows Google Sheets shortcuts

πŸ‘‰πŸ» Follow Techoilyas & fans

02/07/2025

πŸ”Ή Ctrl + W - Close current workbook
πŸ”Ή Ctrl + N - New workbook
πŸ”Ή Ctrl + O - Open workbook
πŸ”Ή Ctrl + S - Save workbook
πŸ”Ή Ctrl + P - Print dialog
πŸ”Ή Ctrl + E - Flash Fill
πŸ”Ή 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 + I - AutoFit column width
πŸ”Ή 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

Workbook Tip: Use Ctrl + W to quickly close files without exiting Excel!

Follow πŸ‘‰ excel_funclub

28/06/2025

As a soul who walks with ancestral wisdom,
I salute those who challenge limits and redefine destiny.

πŸ•―οΈ Thank you for walking your mission.
May your new solar cycle bring more light, more innovation, and higher consciousness.

β€” Nkosy Light | Multidimensional Wisdom

Address

29 Timber Street
Pietermaritzburg
3290

Opening Hours

Monday 08:00 - 16:00
Tuesday 08:00 - 16:00
Wednesday 08:00 - 16:00
Thursday 08:00 - 16:00
Friday 08:00 - 16:00
Saturday 08:00 - 16:00
Sunday 08:00 - 16:00

Website

Alerts

Be the first to know and let us send you an email when Mdombo Computer College posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to Mdombo Computer College:

Shortcuts

Share

Category