Cheatsheet — Quick Reference
A quick reference page — shortcuts, frequently used commands, UDF syntax — condensed to fit one printed page.
DVDAddin shortcuts (defaults)
This is the default set of shortcuts DVDAddin registers when Excel starts. All 21 keys below can be changed or removed in Preferences ▸ Shortcuts.
| Key | Command | Description |
|---|---|---|
F3 | Formula View | Opens the Formula trace window and splits the current cell's formula into clickable pieces |
F6 | Copy/Paste visible | Copy/Paste only the cells that are visible (skips hidden/filtered rows) |
F8 | Copy cell formatting | Calls Excel's Format Painter directly |
Shift + F1 | AI answer in cell | Takes the content of the current cell as the question and writes the AI answer into the cell right below |
Ctrl + J | Align left, center, right | Cycles: Left → Center → Right |
Ctrl + M | Align top, middle, bottom | Cycles: Top → Middle → Bottom |
Ctrl + Shift + A | Highlight selection in yellow | Toggles the yellow fill on the selection |
Ctrl + Shift + C | Change case (cycle) | Cycles: UPPERCASE → Proper Case → Sentence case → lowercase |
Ctrl + Shift + S | SMART case (AI) | Changes capitalisation according to context using AI (Smart Case) |
Ctrl + Shift + D | Move/Resize | Fits the selected picture / shape to a cell or to a range you specify |
Ctrl + Shift + J | Translate the selection into Vietnamese | Quick translation of the selection into Vietnamese |
Ctrl + Shift + E | Translate the selection into English | Quick translation of the selection into English |
Ctrl + Shift + M | AutoFit merged | Automatically expands the row height of merged cells to fit the content |
Ctrl + Shift + Z | Merge keep data | Merges cells but keeps the data of every cell |
Ctrl + Shift + I | Italic | Italicises the text that follows the delimiter |
Ctrl + Shift + R | Text Reverse | Asks for the delimiter (default Chr(10) = line break), then reverses the order of the segments in each selected cell |
Ctrl + Shift + W | Navigation | Workbook / Worksheet management pane docked on the left |
Ctrl + Shift + Q | Find Cmd | Opens the quick command finder (Quick Actions) |
Alt + X | Copy/Paste skipping hidden areas | Calls the same command as F6 — Copy/Paste visible, with merged-cell support |
Alt + C | Insert and Copy | Inserts a block of template rows into several positions |
Alt + S | OCR Screen Clip | Select a screen region, then recognise the text with AI |
Fixed shortcuts (not listed in Preferences ▸ Shortcuts)
| Key | Command | Note |
|---|---|---|
Ctrl + Alt + I | Quick Input | Opens the input-suggestion window at the selected cell |
F10 | Sheets → PDF | Exports the selected sheets to a single PDF file (overrides Excel's key for opening the menu bar) |
F1 (in a DVD Addin dialog) | Command guide | Opens the guide page of the command that opened the dialog; in a window with several tabs (e.g. Text & Number) it is the page of the open tab. Outside the dialogs, F1 is still Excel's help |
System-wide shortcut
| Key | Command | Note |
|---|---|---|
Ctrl + Alt + S | Capture and Annotate | Registered at the Windows level, so it works even when Excel is not the foreground window (Excel must still be open with the add-in loaded) |
Ctrl + Alt + S is not part of the 21 default shortcuts, but it can still be changed: go to Preferences ▸ Shortcuts, select the Capture and Annotate command in the command picker, click Add command, assign the new key and Save — the add-in re-registers it immediately, no Excel restart needed.
Notes:
- Of the 21 default shortcuts, 8 have no ribbon button of their own —
F8(Format Painter),Shift + F1,Ctrl + J,Ctrl + M,Ctrl + Shift + A,Ctrl + Shift + C,Ctrl + Shift + J,Ctrl + Shift + E— they can only be called by shortcut (or from a macro, see Migration). Every other key points to a real button on the ribbon. - Shift + F1 and Ctrl + Shift + S use the provider selected under AI Assistant in Preferences (Gemini / OpenAI / Groq / NVIDIA). If no API Key has been entered for that service, the command prompts you to open Preferences.
- Ctrl + Shift + J and Ctrl + Shift + E translate quickly through Google Translate (no API Key needed), detect the source language automatically and overwrite the result into the same cell.
- You can assign a key to any ribbon command — there are 10 custom slots in Preferences ▸ Shortcuts.
Note: DVDAddin uses
Application.OnKey, so the keys above override Excel's default shortcuts while the add-in is enabled (for exampleF8is normally Extend Selection). Any single key can be removed in Preferences if it clashes with your habits.
Excel built-in (important)
| Key | Action |
|---|---|
Ctrl + C / V / X | Copy / Paste / Cut |
Ctrl + Z / Y | Undo / Redo |
Ctrl + F / H | Find / Replace |
Ctrl + S | Save |
Ctrl + P | |
Ctrl + 1 | Format Cells |
F2 | Edit the cell content |
F4 | Cycle absolute/relative references ($A$1 → A$1 → $A1 → A1) |
Alt + Enter | Line break inside a cell |
Ctrl + Enter | Fill down across the whole selection |
Ctrl + ; | Insert the current date |
Ctrl + Shift + ; | Insert the current time |
Ctrl + Shift + L | Toggle AutoFilter |
Ctrl + Arrow | Jump to the last/first cell in the same column/row |
Top common commands
The License column: — = usable even when not signed in; License = needs an account in date (Standard or PRO); PRO = PRO plan only. The trial version unlocks everything.
| Command | Ribbon location | License |
|---|---|---|
| Translate | DVD Addin ▸ Text and Number | — (Gemini / ChatGPT: License) |
| Numbering | DVD Addin ▸ Text and Number | — |
| Multilevel 1.1.1 | DVD Addin ▸ Text and Number ▸ Multilevel | — |
| SMART case (AI) | DVD Addin ▸ Text and Number ▸ Case | — |
| Encoding | DVD Addin ▸ Text and Number | — |
| Bulk find / replace | DVD Addin ▸ Text and Number ▸ Text ops | — |
| Insert Rows | DVD Addin ▸ Cells and Rows | — |
| Delete blanks | DVD Addin ▸ Cells and Rows | — |
| Merge keep data | DVD Addin ▸ Cells and Rows ▸ Merge cells | — |
| Copy/Paste visible | DVD Addin ▸ Cells and Rows ▸ Merge cells | License |
| Autosum | DVD Addin ▸ Formula | — |
| Color Shapes | DVD Addin ▸ Graphics | License |
| Insert by Name | DVD Addin ▸ Graphics ▸ Insert Pic Menu | — |
| Batch print | DVD Addin ▸ File and Print | License |
| Send Email | DVD Addin ▸ File and Print | License |
| Merge to Word | DVD Addin ▸ File and Print | License |
| Extract Table | DVD Addin ▸ File and Print ▸ PDF / OCR | License |
| Sheet List | DVD Addin ▸ View and Sheets | — |
| AI Chat | DVD Addin ▸ AI | License |
| License — label counts down the trial / renewal, also the Buy button | DVD Addin ▸ About (mirrored on DVD Cons ▸ Quick when about to expire / expired) | — |
| Gantt Chart | DVD Cons ▸ Schedule | License |
| EVM Report | DVD Cons ▸ Schedule ▸ Reports & Snapshot | PRO |
| Rebar Cut | DVD Cons ▸ Optimizer | License |
| New Diary | DVD Cons ▸ QAQC and Diary | License |
| Acceptance Plan | DVD Cons ▸ QAQC and Diary | License |
| Interim Payment | DVD Cons ▸ QS | License |
| AI Construction Estimate | DVD Cons ▸ QS | PRO |
→ Full list of the 224 commands: Command reference.
UDF Quick Reference
DVDAddin has exactly 50 functions. The examples below are written for the Vietnamese regional format (;); if your Excel runs the English (US) format, replace ; with ,.
Text — 14 functions
=dvdTextJoin("; "; TRUE; B6:B12) → join strings, skipping blank cells
=dvdConcatIF(", "; C6:C40; B6:B40; "Móng") → join on one condition
=dvdJoinIF(B6:B60; "Tầng 3"; C6:C60; " + "; TRUE) → join, removing duplicates
=dvdTextSplitItem("MB-T3-D1"; "-"; 2) → "T3"
=dvdExtractElement("Bê tông/M300/Móng"; 2; "/") → "M300"
=dvdUnDiacriticsVi("Bê tông cốt thép") → "Be tong cot thep"
=dvdUniConvert("Be6 to6ng"; "VNI") → convert VNI/Telex to Unicode
=dvdWordCount(A6) → count the words
=dvdCountOccurrences(C6; "D") → count the occurrences
=dvdEvaluate("Móng M1: 2x3x0.8") → 4.8
=dvdSymbol(2) → a ticked checkboxThe rest: dvdConcatIFS, dvdJoinIFS, dvdUniVba.
Range and lookup — 14 functions
=dvdXlookup(A6; $A$5:$A$500; $E$5:$E$500; "Chưa có ĐG"; ""; 0)
=dvdELookup(A6; $B$5:$B$300; $F$5:$F$300) → take the LAST match
=dvdLookupAllSheets(A6; 2; 6) → search EVERY sheet of the workbook
=dvdTableLookup("D16"; "Cấp bền B22.5"; $A$5:$H$30) → two-way lookup
=dvdMVLookup($H$3; $B$5:$B$500; 4; $J$4:$J$40) → every matching value
=dvdMCLookup($A$5:$F$500; 2; $H$3; $H$6:$M$40) → every matching row, several columns
=dvdUnique($B$6:$B$500) → array of unique values
=dvdUnique2DArray($A$5:$F$500; 2; TRUE) → unique rows by key column
=dvdFilter2DArray($A$5:$F$500; 6; ">0"; TRUE) → filter a two-dimensional array
=dvdSumVisible($F$6:$F$500) → sum of the cells CURRENTLY VISIBLE (hidden cells skipped)
=dvdSumIfColor($F$6:$F$500; $H$3) → sum by the fill colour of a sample cell
=dvdCountIfColor($B$6:$B$500; $H$4) → count by the fill colour of a sample cell
=dvdAutoHide($A$6:$A$500; $F$6:$F$500; "<>0"; $A$6:$A$500)The rest: dvdUniqueV.
Date, number and money — 11 functions
=dvdVnd(125000000) → "Một trăm hai mươi lăm triệu đồng."
=dvdVnd(F42; 1) → adds the prefix "Bằng chữ: "
=dvdUsd(1250.5) → spell a Dollar amount out in English words
=dvdLDate(D6; "Hà Nội"; 0) → "Hà Nội, ngày 22 tháng 8 năm 2026"
=dvdLTime(E6; 2) → "08 giờ/hours 30 phút/minutes" (0 = VN, 1 = EN, 2 = bilingual)
=dvdLTimeDate(E6; D6; 0) → time + date string in the standard report wording
=dvdSolarToLunar(DATE(2026;8;22)) → solar → lunar calendar
=dvdLunarToSolar(DATE(2026;1;1)) → lunar → solar calendar
=dvdSteelWeight(16; 20) → weight of D16 rebar, 20 bars
=dvdNoiSuy(5; 10; 120000; 150000; 7) → linear interpolation
=dvdExplain(F6; ; 0; 2) → explain the formula as "result = expression"
=dvdExplainE(F6; ; 0; 2) → explain it as "expression = result"AI, network and shape — 8 functions
=dvdTranslate(B6; "vi"; "en") → Google Translate, no API key needed
=dvdAIExplain(F42; FALSE) → AI explains the formula (needs a Gemini key)
=DVDFx("USD"; "VND") → real-time exchange rate
=DVDFx("USD"; "VND"; "2026-06-30") → exchange rate on a given date
=dvdStock("VCB") → Vietnamese share price
=dvdQR("https://…") → generate a QR code into the cell
=dvdPic("Anh\BB-0142-01.jpg") → insert a picture fitted to the cell
=dvdColorShapes($H$6:$I$40; "Mat bang"; 0.2) → colour many shapes at once
=dvdMoveShape("MuiTenTienDo"; "120;340") → move a shape to a coordinateDVDFx and dvdAIExplain run asynchronously — the cell shows #N/A waiting... and then updates itself.
Data query — 3 functions
=dvdSQL("SELECT [Mã hiệu], [Khối lượng] FROM 'D:\HS\KL.xlsx'!TH WHERE [Hạng mục]='Móng'") → query a closed file, whole result range
=dvdSQLValue("SELECT SUM([Khối lượng]) FROM 'D:\HS\KL.xlsx'!TH WHERE [Mã hiệu]='AF.211'") → a single value
=dvdSheets("D:\HS\KL.xlsx") → sheet names of a closed fileType
=dvdin a cell and Excel suggests the whole list; clickfxon the formula bar to see the name and meaning of each argument. Full catalogue: UDF functions.
Important paths
| Item | Location |
|---|---|
| Install folder | C:\DVDAddin\ (with Template\ and Library\) |
| License file | %LocalAppData%\DVDAddin\license.dat |
| Registry root | HKCU\Software\DVD\DVDAddin |
| Shortcuts | HKCU\Software\DVD\DVDAddin\Shortcuts |
| API keys | HKCU\Software\DVD\DVDAddin\API Keys |
| AI model | HKCU\Software\DVD\DVDAddin\Model |
| General preferences | HKCU\Software\DVD\DVDAddin\Preferences |
| Gantt & Calendar settings | HKCU\Software\DVD\DVDAddin\GanttSettings |
| Interface language | %APPDATA%\DVDAddin\lang.txt |
| Internal log | %TEMP%\DVDAddin\ |
| Batch print configuration | very hidden sheet DVDAddinSetting inside the workbook itself |
| Send Email presets | very hidden sheet _DVDAddin_Email inside the workbook itself |
Web links
| URL | Purpose |
|---|---|
| https://dvdaddin.dvdpm.net/ | Documentation site (you are here) |
| http://dvdpm.net/dvdaddin | Product page + license purchase |
| https://github.com/dangdvd/DVDAddin | The DVDAddin.rar installer under Releases + Issues |
| https://zalo.me/g/yqzwvk121 | Zalo support group |
| https://www.youtube.com/@DVD-18 | Tutorial videos |
| +84 988 909 382 | Support phone |
| https://aistudio.google.com/apikey | Gemini API key |
| https://platform.openai.com/api-keys | OpenAI API key |
| https://console.groq.com/keys | Groq API key |
| https://build.nvidia.com | NVIDIA NIM API key |
Related
- Preferences — change shortcuts, AI provider, API key.
- Smart Case — normalise letter case.
- Encoding — convert font encodings.
- Find Cmd — quick data entry and Quick Actions.
- FAQ — frequently asked questions.
- Troubleshooting — error details.
- Command reference — 224 ribbon commands.
- UDF functions — 50 functions.