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

Chronic pain management with Thermotex infrared heating pad

Thermotex infrared heating pad has been one of my purchases that have helped me a lot in dealing with my chronic pain due to fibromyalgia. Over the course of the past 10 years that I have owned this, I have given it to friends and family to help reduce the pain due to shoulder injury knee and abdominal pain. I have made a YouTube video as a review for this below. I hope you find this useful. The only shortcoming that I have seen is that I cannot wrap it around the shoulder. So if you come across an infrared heating pad which can be wrapped around the neck and shoulders, please do share in the comments below.
2 comments
Read more

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

Chronic pain : Tools of trade

Over the course of several years that I've spent in dealing with chronic pain, I have discovered a number of items that helped to reduce the pain and keep me functional. Here is a list of 10 items that I use frequently : Thermotex infrared heating pad . ( Video review ) I have used this since 2007 and it is still working very well. At the time I bought this, I thought it was pretty expensive. Now that it has been 9 years and the pad really reduced the need of pain medication on several occasions, I think it has paid for the investment several times over . I have mainly used it for abdominal muscular pain. There were times that I have wrapped it around the abdomen and slept at night. The main advantage of infrared is that it penetrates deeper and does not heat up the skin like a conventional heating pad. A good side effect of using it on the abdomen is that it reduces my tendency for constipation . It is also been very useful whenever I had any pathology n the rectum like an...
5 comments
Read more