Automation Tools for Word & Excel
Excel & Word Automation Tools
1. Create Folders from Excel Names
This tool helps you create multiple folders from a list of names in Excel.
- In Excel, use
=CONCATENATE("md ", A1)
to add "md " before each name - Copy all the names with "md " prefix
- Paste them below:
Instructions: After downloading the .bat file, double-click it to create all the folders automatically.
2. Convert Numbers to Words in Word
This simulates the Word field code to convert numbers to words.
Word Instructions: In Microsoft Word, press
Ctrl+F9
, then type ={your number}/*cardtext
and press F9
to convert.
3. Row Movement Shortcuts
Excel:
- Select the row(s) you want to move
- Hold
Shift
and drag the row up or down - The rows will be moved and other rows will adjust automatically
Word:
- Select the paragraph or row you want to move
- Hold
Ctrl+Shift
and press↑
or↓
arrow keys - The content will move up or down while maintaining formatting
4. Database Navigation Shortcuts
- Go to last cell:
Ctrl+End
- Go to first cell:
Ctrl+Home
- Alternative method: Click the top part of the active cell border to go to the start, or the bottom part to go to the end
5. Excel Table Formatting Shortcuts
- Select any cell in your data range
- Press
Ctrl+A
to select all contiguous data - Press
Ctrl+T
to convert to a table - Press
Alt+H+O+I
to auto-fit column widths - Press
Alt+H+O+A
to auto-fit row heights - Press
Alt+H+B+A
to apply all borders