Category: Microsoft Excel

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

Find Yourself Hating Microsoft Office?

The Haters are not the only ones hating Microsoft Office ¬†Why is there so much hatred for Microsoft Office? Apparently, it’s the ribbons. Those bloated features laid out under countless tabs you find in Word, Excel, Powerpoint or Access. But there are people on the Internet that are better at expressing this deep seated hostility […]

df

Repost from May: Is Excel scaring off potential users?

Who has the time to see Excel’s strengths? When Microsoft was creating Excel, they wanted it to be used as a statistical and forecasting tool, but at the same time be user friendly with its vast amount of features and tools for spreadsheet customization. How well did it work? Just look at the vast amount […]

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 December: Word into Excel: names and addresses

Still working crazy on QuikBots for Word. In the meantime, check out this tip for transporting info from Word to Excel. Then hop over to axbean.com and get QuikBots for Excel, your tool to get things done faster and easier. Glitch-free importing names and addresses from Word to Excel Here’s a scenario: the boss is […]

df

Repost from last year: Highlighting searches in Excel

Excel’s Conditional Formatting is the new BFF I’m staring at a long spreadsheet with a whole lots and lots of numbers in a column and my fingers are getting cramped. The up and down keys are getting a workout. All I want to see are numbers less than zero. Using Excel’s “find” feature I’m constantly […]

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

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 […]