officeautomata Actions

Speed up your work with these meta commands to Cortana.

  • Finish a worksheet
    • Say: Finish this worksheet based on  <workbook name> <worksheet name>
    • Or: Use the clipboard and Finish this sheet like workbook  <name>, worksheet  <name>
    • Note: Cortana needs to have the workbook in her memory to do this
  • Apply formatting from other worksheets
    • Say: Apply all the formatting from workbook <name>, worksheet <name>
    • Use formatting from workbook <name>, worksheet  <name> 
  • Fix the Excel auto-formatting of number pastes
    • Fix the number formatting on the last paste 
  • Copy only the visible highlighted cells
    • Copy the visible cells  
  • Keep the leading zero's while pasting data
    • Set the clipboard to keep the leading zeros
  • Insert Workbook in an open Email
    • Say: Add this workbook to the current email
  • Insert Workbook to a new Email
    • Say: Add this workbook to a new email
  • Create Email
    • Say: Create a new email with cells <cell> as the address And(Optional) cells <cell> as the name And(Optional) cells <cell> as the subject
  • Copy to the End of a Column
    • Say: Copy to the end of the column
  • Paste at the End of a Column
    • Say: Paste at the end of the column
  • Scrape Webpage
    • Say: Scrape this webpage (after copying a web address)
  • Create Database
    • Say: Create a database of this workbook
  • Insert Database item/group
    • Say: Insert a database item/group 
  • Split Table into Worksheets
    • Say: Split this table into worksheets