Category: How-to

df

Having Trouble Importing Excel into Word?

Repost: Import text from Excel into Word or vice versa hassle free Whatever the reason, importing, say, a customer list from either Excel into Word or the other way around can often times lead to messy surprises. It’s a pain to clean up a Word list that got ruined when it becomes all jumbled in […]

df

Repost from June: App plug-in makes Excel a cinch to use

AXbean QuickBots will make you excel In Excel As we are getting ever so closer to finishing up tweaking and testing QuikBots for Word, let’s look back at the introduction of our first baby: QuikBots for Excel. Regular readers of this blog know abundantly clear how I feel about working in Microsoft Excel. If you […]

df

Repost from July and an update: Like a pattern in Excel? Copy it

Use Format Painter to copy the look you want Here’s a very common office scenario: you are walking by your office buddy’s cubicle and something catches your eye. Granted, first it was blue hair. But then you notice the worksheet on the computer screen with colored cells of blue. And you’re thinking, “well, not a […]

df

Stop Word from opening in Start Screen

How to race pass the Start Screen in Word and get down to business Little annoyances always seem to pop up working with Word.  And the first annoyance that immediately shows up is the Start Screen. The ambiguous screen of recent files you worked on and the multitude of template choices to pick from. Also […]

df

Easily find revisions in a Word document

A simple way to locate revisions in a Word document Some time ago I did a post on finding changes in an Excel spreadsheet called How to catch Excel changes in worksheet. The reason I mention it right off the top, is you might be thinking it’s the same procedure in Word. However, if it […]

df

Paste multiple items in Word or Excel

For Excel or Word: How to cut, copy and then paste multiple entries Whether you are using Excel or Word, you are probably familiar with the one time use feature of Copy, Cut and Paste. What if you want to copy or cut a bundle of multiple entries all at the same time and then […]

df

Excel speed slowing down?

Is Excel slowing down because it’s always calculating formulas? The common symptoms of a slowing Excel spreadsheet are the following signs: you start typing numbers in a cell and slowly one by one appears on screen or perhaps Excel starts to do that blinking thing, where it acts like it’s just woken up from a […]

df

Repost from September: Can’t calculate numbers in Excel?

How to change text numbers into math numbers When numbers are not numbers is pretty much whenever Excel treats numbers as text. Usually this happens when a document gets imported into Excel. In some cases the document is from Microsoft’s other office product, Word. Other times, from an outside source such as an email or […]

df

Need to count inventory in Excel?

Easy way to count inventory from a list in Excel Counting the Jones from all the other customers. How many pencils from a list of school supplies. There’s a simplified formula called the COUNTIF that you can use to help count inventory and then put the total in a different place in the worksheet. The […]

df

Rows missing in your Excel spread?

When rows and columns are missing and how to get them back If you ever come across an Excel spreadsheet where something is off, say a list of figures that don’t add up to the total at the bottom or perhaps you’re reciting the alphabet in your head because there’s a noticeable absent of the […]