Calling all spreadsheet jockeys: The Pointy Haired Dilbert blog has seven productivity boosters for Excel, all of them based on double-clicking in places you probably never though to double-click. For ...
If you have to deal with boring spreadsheets on a daily basis, every tiny little trick that saves you time is worth it—and the Pointy Haired Dilbert blog runs down a whole list of useful tricks. The ...
Checkboxes in Excel are an underrated gem. They seem simple, but their versatility allows you to organize and track various aspects of your life with ease. Hereâ s how I put them to work. As a writer ...
Q. When I’m entering a long name in an Excel cell, I have to go through all the format steps to wrap the text in the cell and then I have to adjust each line so it wraps properly. It’s not a problem ...
When you want to fill a column in Excel with a given formula or value, you can do it the old fashioned way (select cells or the column header, CTRL+V to paste) or use can do it the much faster way by ...
Here's how to build smarter checklists in Excel using checkboxes, conditional formatting and task dependencies to help with multi-step processes. In my previous article in this series, I walked you ...