How To Batch Unzip A Series of Sequential Zip Files In Mac OSX

I recently got a bunch of zip files, some sequential (X1.zip, X2.zip, etc), and others not. The thing is, they number in the hundreds, and most contain RAR files within them, and simply extracting each one won’t do. I had to find an automated way to unzip all the zip files, and the utility that i usually use (BetterZip) didn’t seem to help. Finally after trying a few methods (including the unzip command in Terminal), I found this method that

Continue Reading

How To Edit Cell With A Keyboard Shortcut In Mac Excel

I was doing up several worksheets in Excel, and I was finding it incredibly disruptive to my workflow to edit a cell. I had to take my hands off my keyboard, reach out to my mouse, and double-click the cell before I could edit it. So I went searching, and turns out that there’s a keyboard shortcut for this! Just press Ctrl-U to edit the cell contents! Not sure why they chose the letter u though.

Sliding Sidebar