I have come to the conclusion that the best way to automate moving data around in Excel and formatting it, via Automation Anywhere, is by simulating keyboard shortcuts and putting delays in between them. I wish there was a slicker way, because it sure is fiddly.