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



Labels:

Comments

Post a Comment

Popular posts from this blog

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 p...
4 comments
Read more

Reduce RSI and chronic pain in your hands and fingers by using whatsapp with speech recognition

Whatsapp has emerged as a extremely popular form of communication in the last few years. In fact, even my doctors are using whatsapp to communicate with their patients. So even though I experience a lot of pain in operating mobile with hands , I am constrained to use whatsapp. A few months ago, after a bit of effort, I will able to figure out a way to use whatsapp hands-free with speech recognition. I'm still trying to find a way to use whatsapp with Dragon NaturallySpeaking on the desktop. Here are two videos that explain how to send and receive messages using whatsapp. As I explain in the videos, there are some shortcomings in both sending and receiving. For example, you cannot dictate more than approximately 200 characters while sending a message. And of course you cannot send a photograph or a video or share another message using speech recognition as yet. With receiving whatsapp messages, depending on your device,, you may have to hear all the unread messages multiple tim...
2 comments
Read more

Medications to control chronic constipation or incomplete bowel movement

I have been dealing with incomplete bowel movement for the last 10 years. I was diagnosed with paradoxical relaxation of puborectalis muscle several years ago. It essentially means that I contract the muscle instead of relaxing them during a bowel movement and that is why the bowel movement remains incomplete even though the stools are well formed and not hard as an conventional constipation. The problem is exacerbated because I have to take medications for chronic pain that will usually cause constipation. Though the line of treatment for this is biofeedback, I was unable to benefit from it. Ultimately, I have been using the same supplements and medications that are being used for people with chronic constipation. The only addition to the list below which may be unconventional is Horlicks. It is supposed to be a very mild laxative but for me it works wonders. So this is the list: Ayurvedic supplement Amla Juice . Somehow only the brand from Patanjali helps me out. Aloe vera...
Post a Comment
Read more