This week’s email newsletter article is:
This Week’s Blast From The Past
A Look at Articles from Past Newsletters
- Lost Scrolling Ability on Laptop
Long-time subscriber Oz Fisher wrote me about a problem he was having with his laptop…
Hello again Terry. You helped me out with a problem several years ago and I am hoping you can resolve a new issue for me.
I have an older laptop on which I can no longer use the touchpad to scroll the window contents. The touchpad driver is up to date and I followed some advice on the web to solve the problem, to no avail.
- Using Excel to Manipulate Text
One of the neat things that you can do with Excel is to use it to manipulate text.
If you have a rows of similar data, all of which need to be manipulated in the same way, Excel excels in letting you extract, add, manipulate, and generally modify the text. There are a number of Excel functions that are designed for text manipulation.
In this article, we’ll look at the Concatenate function, which lets us combine the text, and then a shorthand version of the Concatenate function that’s easier to use. […]
- Solving the Excel #VALUE! Error
Subscriber Tim S. wrote about an oft-frustrating error in Excel. It’s not that an occasional error is aggravating. The problem is when you’re building a spreadsheet into which you’ll enter or paste data at a later time.
The calculations that try to use those cells that are currently blank, will often display Excel errors […]
- Adding Icons to the Office 2010 Quick Access Toolbar
With the advent of Office 2007, Microsoft introduced the Quick Access Toolbar. Located on the top line of the Window, above any other toolbars, the Quick Access Toolbar initially has very minimal functionality. But, it can easily be customized by you to add your favorite functions within that program.
The Quick Access Toolbar is different in Excel, Outlook, Word, PowerPoint, etc. That is, each has its own Quick Access Toolbar that can be configured independently. […]