If you have a bunch of rows or columns in Excel that need to be updated with a maths operation, instead of applying a formula or editing each cell, save some time by using Paste Special. The GuidingTech blog shows us this power user trick, using the example of adding 50 to a number of cells all at once.
I’ve lost count of the number of times I’ve groaned after learning the simplest of technology-related time savers — say, auto-resizing columns in Windows. In this TED video, CBS’ David Pogue covers ten similar shortcuts to speed up your daily computer and gadget interactions.
If you want a few more options for getting around in My Computer (or just “Computer” as its known in Windows 7 and beyond), you can add anything to this page by placing shortcuts in a little-known folder. Depending on what version of Windows you’re running, this folder may be in a different place, but here’s the quickest way to get there.
Windows: Preme adds a collection of useful tweaks to window management on Windows, including the ability to scroll windows without clicking on them. We featured Preme once before, but it bears repeating now that Windows 8 is out and this app has been updated with a nicer interface.