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

Strengthening Exercises While Being Bedridden

If you are frequently bedridden due to illnesses like chronic pain, chances are that you will tend to lose muscle mass. Less muscle strength can lead to increase pain thus causing a vicious cycle of chronic pain. It is important therefore to find a way to exercise and strengthen the muscle despite being bedridden.

Over the years, I have found myself frequently to be in this situation due to fibromyalgia.  There are several videos about exercises for the bedridden patients(for example, this). However, the exercises in these are more to improve mobility rather than increase muscle strength. Ultimately, I spent quite a bit of time compiling a list of exercises from YouTube that exercise and strengthen every major muscle group.  The list is provided below along with the major muscle groups that they exercise.As I have suffered from injuries because of using weights incorrectly, I recommend trying only with the resistance bands initially and that is what I have included in the list.
(The …

3 Quick Tips on Disability Insurance for The Impatient (And for Those Who Don't Care!)

I know your time is important. So let's get right to the main points first and save the details for later.
Here is what you need to know about disability insurance in the US.

Disability Happens More Often Than You Think
According to the United States Census Bureau, nearly 1 in 5 people are disabled. This does not include invisible disabilities which are estimated to be 10%. And then there are temporary disabilities that can prevent you from working for several months to a few years at a time. With these figures, as a conservative estimate, there is a 33% chance that you will be requiring disability insurance at some point in your life
.
It Happens to Women More Often Than Men
According to the United States Centre for Disease Control and Prevention, 24.4% women report on disability as compared to 19.8% men.

Employer Paid Disability, More Often Than Not, Does Not Help in Times of Need 
Employer paid disability is governed by ERISA law. According to this article that appeared in the Lo…

How This Ayurvedic Herb Helped Me Safely Withdraw from Antidepressants

As a patient with chronic pain, I have to try out different painkillers and antidepressants to manage my pain. Most of these medications, especially the antidepressants, have side effects that include increased dependence and, therefore, can cause withdrawal symptoms. Depending on the duration and the dosage of the medication, these symptoms can range from a mere inconvenience to brutal and long-lasting health problems.

I myself faced tremendous difficulty while trying to wean myself off an antidepressant called amitriptyline. Like many of its counterparts, amitryptiline also has drowsiness as one of its side effects. Consequently, insomnia as a result of withdrawal from amitriptyline was a major problem for me. From a high of 75 mg, I was able to reduce the dosage to 25 mg at the rate of 5- 10  mg every fortnight without much trouble. However, reducing dosage from 25 mg onwards was a nightmare - no pun intended. I started experiencing disturbing vivid dreams that made it impossible …