Skip to main content

Dragon Naturally Speaking Tutorial : How to Format Columns in Microsoft Excel





In this Dragon NaturallySpeaking tutorial, I show how to format a column in Microsoft Excel using speech recognition.

While working with Microsoft Excel, you may be required to format a column, for example, if the column contains a specific type of data such as dates or a dollar amount. To achieve this using Dragon Naturally Speaking, first bring up the format column dialogue box using the command "Format Column". Now you can navigate and choose any particular options using different Dragon Naturally Speaking commands.

The most convenient way to navigate is to simply say the name of the option. For example, you can simply say "Currency" to select the currency option. There is one particular case in which this may not work. In Microsoft Excel, the option "Number" is located within the tab also called as "Number". Dragon Naturally Speaking will then just go to the tab but will not navigate to the option because it has no way of determining whether the user wanted to go to the tab or to the option. To avoid the confusion, you can use the commands "Move down/up x line ".

A faster way to navigate is to use Knowbrainer 2017 command - "Display Numbers". This will display a number over each clickable item and then you can simply choose a particular item by saying the number displayed over it.

Here is a YouTube video that explains how to format a column in Microsoft Excel 2010 with Dragon NaturallySpeaking premium 13 :






About Dragon NaturallySpeaking:

Dragon NaturallySpeaking is the most popular speech recognition software on PC. Dragon Dictate / Dragon For Mac is the counterpart of Dragon NaturallySpeaking on Apple Macintosh computers.

Windows:
At the time of writing this blog post, Dragon NaturallySpeaking Professional Individual 15 is the recommended version for most users. However, I continue to use Dragon NaturallySpeaking premium 13) (approximately $100) because of version 15 incompatibility with Natlink. If your needs are limited to email and web surfing, then you may just want to purchase Dragon naturally speaking home 13 (about $ 50) .

Mac:
Dragon professional for Mac is the recommended version (costs around $ 300) .

You can download the appropriate version directly from the company's web store from the links below. (They usually run discounts once every month  so you can be on the lookout for the deals from the online store and purchase accordingly)



  Dragon for Mac 5



Comments

Popular posts from this blog

Use Cavilon to avoid skin damage if you use kinesiology tape regularly

I have found kinesiology tapes to be very useful in managing chronic pain due to fibromyalgia. It has been very useful to me in also managing the pain due to shoulder tendinitis. In fact, kinesiology taping was the only way that I could brush with my right arm when affected with shoulder tendinitis. However, applying tapes repeatedly over the course of several weeks starts damaging the skin and it becomes difficult to remove the tapes also. This is especially true for regions where the skin is a relatively softer like the anterior neck and  area near to armpits. Cavilon has been very helpful to me by making it easier to remove the kinesiology tape thereby reducing the chance of the skin getting damaged. Using Cavilon is straightforward. Just before applying the kinesiology tape, you just spray it over the area on which the tape is to be applied. It is relatively costly but if you have to use the kinesiology tape over a long period, there does not seem to be any other

How US Tax Reform Affects Patients with Chronic Illness

It was messy, but it is finally done and over with! On December 22, 2017 the tax reform bill , or 'a giant tax cut ' as President Trump calls it, has finally been passed by both houses and has been signed into a law. It is not immediately obvious how the tax plan impacts patients with chronic illnesses. Views in the media are often tainted by the political prism through which the commentators tend to look at this issue. Plus there is limited discussion of the specific provisions that can affect patients with chronic illnesses. In this post, I am outlining some of the major provisions of the final bill that may affect chronically ill patients. Bear in mind that I am not a professional in accounting and taxation . However, I seem to have had more than my fair share of tax problems and as a result, I have become overfamiliar with the IRS website and publications. Article continues after the ad To make it easier to wrap our brains around this complex piece

Reduce finger, wrist and forearm pain due to computer mouse usage with Gentle Mouse

If you are reading this on a computer screen, chances are that you would have clicked your mouse at least a couple of times to navigate through this content. And in most cases, the finger used to click would be your index finger. Now imagine doing this repetitive movement every few minutes, day after day, year after year and you can easily infer that your fingers are at an increased risk of repetitive stress injury (or RSI) due to mouse overuse. The common name given to this painful condition is  Mouse Finger .  The 'Finger' in Mouse Finger usually leads a person to believe that the pain is restricted to the fingers alone.  However, from what I have surmised after reviewing anecdotal evidence and medical literature, it commonly presents as a cluster of symptoms in the finger, wrist and the forearm. Perhaps that explains why there are no easily available research studies pertaining to Mouse Finger alone. Most of the research studies consider these symptoms as a part of