An Excel Trick To Quickly Increment Dates For Each Row

You’ve probably found yourself in a position at some point or another where you needed to create a bunch or rows with dates that increased/decreased by a fixed amount for each row. You could spend your valuable time entering them manually or use this oldie but goodie click-and-drag trick to fill in those dates in seconds. Make sure your column is formatted for dates and enter the increment you need to use. In this example, I want each row to decrease by one day. Highlight both cells and look for a tiny … Read more

The Secret To Converting Paragraph Breaks Into Line Breaks And Creating Comma Separated Lists

Pretty much every arts administrator knows the pain of looking at a long list of content in a Microsoft Word document where each line is separated by a paragraph, but you need them separated by line breaks. You could go through and manually change each…and…every…one or you can use this Find and Replace trick to do the entire doc in seconds. Convert Paragraph To Line Breaks (and vice versa) Use CTRL + H to bring up the Find and Replace dialog box and in the Find whatfield enter ^p (the upward arrow character is a caret and … Read more

Become A Microsoft Office Master

Become A Microsoft Office Master

Let’s all pause for a moment to consider the great equalizer at your organization: Microsoft Office. Whether you love to hate Outlook for messing up your calendar when you attend a conference in another time zone, or just plain love creating complicated Excel formulas, MS Office is pretty much ubiquitous in daily work, so you might as well get the most out of it. And considering it’s been around for over 25 years, there might just be some new features you don’t yet know about. Back in April Lifehacker featured Microsoft Office … Read more