Automation Tools for Word & Excel

Excel & Word Automation Tools

Excel & Word Automation Tools

1. Create Folders from Excel Names

This tool helps you create multiple folders from a list of names in Excel.

  1. In Excel, use =CONCATENATE("md ", A1) to add "md " before each name
  2. Copy all the names with "md " prefix
  3. 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

  1. Select any cell in your data range
  2. Press Ctrl+A to select all contiguous data
  3. Press Ctrl+T to convert to a table
  4. Press Alt+H+O+I to auto-fit column widths
  5. Press Alt+H+O+A to auto-fit row heights
  6. Press Alt+H+B+A to apply all borders
Next Post Previous Post
No Comment
Add Comment
comment url