Monday, 20 May 2013

Obviously, that should have been the Tab key

Excel power user flags down this passing pilot fish to help with her PC, where she has a spreadsheet open.

"She was trying to copy out information from this spreadsheet someone had sent to her," says fish. "When she pressed Ctrl+C, the spreadsheet flickered a few times, and all the data vanished.

"I replicated it a few times, and then my confused expression turned into an eye roll. I checked the list of macros in the workbook and sure enough, in very professional documented VB script, there was a macro that cleared the worksheet...assigned to Ctrl+C.

"Whoever created that spreadsheet must've thought they had invented the idea of keyboard shortcuts."

Best Microsoft MCTS Certification, Microsoft MCITP Training at certkingdom.com

No comments:

Post a Comment