Question about Computers & Internet

1 Answer

Hi this is sunil my problem is while typing the names in excel i want starting letter in caps, for every name i am using shift key, is there is any solution is excel

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 373 Answers

Try caps lock.There is generally no other alternative for this.Else try typing the names alone in caps in a word pad and paste it in the excel sheet when needed.

Posted on Jan 20, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How do I get the caps lock light to turn on and off?


Unlock the Caps on Computers The All-Caps or "Caps Lock" function causes all letters to appear as capital letters when typing into word processing documents, emails or other files. This is convenient when needing to type numerous capital letters or All-Caps phrases, as you do not have to hold down the "Shift" button with one finger as you type the words. When All-Caps is stuck and does not respond to the "Caps Lock" keyboard button, a simple procedure overrides and shuts down the function. Open a word processing program. Press the "Caps Lock" button located on the left side of the keyboard to turn Caps Lock off. Type inside the document. If lower case letters appear in the document, Caps are successfully unlocked. Proceed if the text is in All-Caps. Hold down "Shift" on the keyboard. Press the letter "P." A lower case "p" appears in the document. Release the "Shift" button. Type the phrase "rint" directly after the lower case "P." The word "pRINT" is now in the document, and the document cursor is after the phrase's "T." Press "Enter" on the keyboard. The cursor goes down one line and "pRINT" becomes "Print." The "Caps Lock" function is turned off. Restart the computer to save the setting.
Enable the Caps Lock Key The "Caps Lock" key is loved by some and disliked by others. The key turns all letters into capitals as you type. While this feature is useful in some situations, a more common occurrence is that the key is accidentally hit and all the text typed is capitalized. The person typing must then delete the capitalized type and rehit the key to turn off "Caps Lock." If the "Caps Lock" key needs to be enabled, it indicates that someone has disabled or remapped the key. If a user wanted to, the "Caps Lock" key can be disabled and enabled through the registry or remapped through the control panels. Updating the registry for the keyboard will enable the "Caps Lock" key. Open the Notepad program. Type the following: [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout] "Scancode Map"=- Select "Save As" from the "File" drop down menu. Navigate to the computer desktop as the save file location and choose "All Files" from the "Save as type:" drop-down menu at the bottom of the Save As window. Type "enable.reg" without quotes in the "File name:" field and click "Save." Minimize all open windows to view the desktop. Double-click on the "enable.reg" file. A box will pop up asking if you are sure you want to run the file. Select "Run" or "Yes" and then click "Yes" for the Registry Editor warning. Reboot the computer. The registry will be updated and the "Caps Lock" key will be enabled. b> Manually Update the Registry b> Click the "Start" menu, type "regedit" without the quotes and press "Enter." In older versions of Windows, Click the "Start" menu, select "Run," type "regedit" without the quotes and press "Enter." This will launch the Registry Editor. Navigate to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout" to view the settings. Right click on the "Scancode Map" setting and choose "Delete." Click "Yes" to confirm the deletion. Reboot the computer. The registry will be updated and the "Caps Lock" key will be enabled.

b> b> b> Disable the Caps Lock Key in Windows Your computer's Caps Lock key has likely only collected dust since you first brought the machine home. The Caps Lock key is beneficial if you want to type a long string of words entirely in capital letters, but this form of typing is not needed often. Consider disabling your Caps Lock key if you do not need it, or if you are tired of hitting the key accidentally while rapidly typing.
Restart your computer before beginning the process of disabling your Caps Lock key. Download the registry file necessary to disable your Caps Lock key. You have the option to disable your Caps Lock key or change the key to a number of different keystrokes. For example, you may choose to use the "ChangeCapsToShift" registry file if you want the Caps Lock button to function as a shift key. Double-click the registry file you have downloaded. A prompt will appear on your screen asking if you would like to add the registry file to your computer's registry. Select "Yes" to install the registry file. Restart your computer, once again, to complete the registry change. Upon reboot, your Caps Lock key will no longer function as a traditional Caps Lock key.

Disable the Caps Lock Key on a Computer The Caps Lock is an easy key to hit by accident, and often the user does not realize it immediately. When this mistake occurs, usually you must correct some text errors and your time is wasted. If you think the Caps Lock key is more of an aggravation than it is good, follow these steps to disable your Caps Lock key. Click on "Start" and select "Run". Type "regedit" into the textbox and hit "OK". This command will open the "Registry Editor" window. Select "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control". Double click on "Keyboard Layout" to open the folder. Open the "Edit" menu and choose "New" then "Binary Value". A new file will appear on the right side of your screen with the file name highlighted. Type "Scancode Map" for the new file name. Double click to open and type in "00000000 00000000 0200000000 003A00 00000000" into the Value data box. Hit the "OK" button. Close the "Registry Editor" by selecting "Exit" from the "File" menu. Restart your computer for the change to go into effect and enjoy life without the Caps Lock Key.

Feb 04, 2013 | ASUS R503u-rh21

1 Answer

CAP LIGHT DOES NOT COME ON


Unlock the Caps on Computers The All-Caps or "Caps Lock" function causes all letters to appear as capital letters when typing into word processing documents, emails or other files. This is convenient when needing to type numerous capital letters or All-Caps phrases, as you do not have to hold down the "Shift" button with one finger as you type the words. When All-Caps is stuck and does not respond to the "Caps Lock" keyboard button, a simple procedure overrides and shuts down the function. Open a word processing program. Press the "Caps Lock" button located on the left side of the keyboard to turn Caps Lock off. Type inside the document. If lower case letters appear in the document, Caps are successfully unlocked. Proceed if the text is in All-Caps. Hold down "Shift" on the keyboard. Press the letter "P." A lower case "p" appears in the document. Release the "Shift" button. Type the phrase "rint" directly after the lower case "P." The word "pRINT" is now in the document, and the document cursor is after the phrase's "T." Press "Enter" on the keyboard. The cursor goes down one line and "pRINT" becomes "Print." The "Caps Lock" function is turned off. Restart the computer to save the setting.
Enable the Caps Lock Key The "Caps Lock" key is loved by some and disliked by others. The key turns all letters into capitals as you type. While this feature is useful in some situations, a more common occurrence is that the key is accidentally hit and all the text typed is capitalized. The person typing must then delete the capitalized type and rehit the key to turn off "Caps Lock." If the "Caps Lock" key needs to be enabled, it indicates that someone has disabled or remapped the key. If a user wanted to, the "Caps Lock" key can be disabled and enabled through the registry or remapped through the control panels. Updating the registry for the keyboard will enable the "Caps Lock" key. Open the Notepad program. Type the following: [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout] "Scancode Map"=- Select "Save As" from the "File" drop down menu. Navigate to the computer desktop as the save file location and choose "All Files" from the "Save as type:" drop-down menu at the bottom of the Save As window. Type "enable.reg" without quotes in the "File name:" field and click "Save." Minimize all open windows to view the desktop. Double-click on the "enable.reg" file. A box will pop up asking if you are sure you want to run the file. Select "Run" or "Yes" and then click "Yes" for the Registry Editor warning. Reboot the computer. The registry will be updated and the "Caps Lock" key will be enabled. b> Manually Update the Registry b> Click the "Start" menu, type "regedit" without the quotes and press "Enter." In older versions of Windows, Click the "Start" menu, select "Run," type "regedit" without the quotes and press "Enter." This will launch the Registry Editor. Navigate to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout" to view the settings. Right click on the "Scancode Map" setting and choose "Delete." Click "Yes" to confirm the deletion. Reboot the computer. The registry will be updated and the "Caps Lock" key will be enabled.

b> b> b> Disable the Caps Lock Key in Windows Your computer's Caps Lock key has likely only collected dust since you first brought the machine home. The Caps Lock key is beneficial if you want to type a long string of words entirely in capital letters, but this form of typing is not needed often. Consider disabling your Caps Lock key if you do not need it, or if you are tired of hitting the key accidentally while rapidly typing.
Restart your computer before beginning the process of disabling your Caps Lock key. Download the registry file necessary to disable your Caps Lock key. You have the option to disable your Caps Lock key or change the key to a number of different keystrokes. For example, you may choose to use the "ChangeCapsToShift" registry file if you want the Caps Lock button to function as a shift key. Double-click the registry file you have downloaded. A prompt will appear on your screen asking if you would like to add the registry file to your computer's registry. Select "Yes" to install the registry file. Restart your computer, once again, to complete the registry change. Upon reboot, your Caps Lock key will no longer function as a traditional Caps Lock key.

Disable the Caps Lock Key on a Computer The Caps Lock is an easy key to hit by accident, and often the user does not realize it immediately. When this mistake occurs, usually you must correct some text errors and your time is wasted. If you think the Caps Lock key is more of an aggravation than it is good, follow these steps to disable your Caps Lock key. Click on "Start" and select "Run". Type "regedit" into the textbox and hit "OK". This command will open the "Registry Editor" window. Select "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control". Double click on "Keyboard Layout" to open the folder. Open the "Edit" menu and choose "New" then "Binary Value". A new file will appear on the right side of your screen with the file name highlighted. Type "Scancode Map" for the new file name. Double click to open and type in "00000000 00000000 0200000000 003A00 00000000" into the Value data box. Hit the "OK" button. Close the "Registry Editor" by selecting "Exit" from the "File" menu. Restart your computer for the change to go into effect and enjoy life without the Caps Lock Key. Hope this helps

Jan 21, 2013 | Acer Computers & Internet

1 Answer

How to write letter verifing address


Instructions
    • 1Before you begin, set your marginicon1.png 1 inch from the top, 1 inch from the bottom, and 1.25 inches on both sides.
    • 2If you're using letterhead, there's no need to type in your name and address. If you're using plain white paper, type in your name, address and phone number (phone number is optional), centering the text. Make the font in this portion of the letter slightly larger than the rest of the text. You should also type your name, address and phone number in boldicon1.png type.
    • Sponsored Links
    • 3About four lines down from your name and address, type the date in full after strikingicon1.png the "Tab" key seven times to bring you a little further than the middle of the page. The date should be typed in full like this:
      February 1, 2009.
    • 4Four or five lines down from the date, at the left hand margin, type the name and address of the person you're sending the letter to. This portion of the letter is called the inside address. If the person you're addressing the letter to has a title, type his or her name first, then type in a comma, space once and type in the title, such as:
      Jamie L. Mulligan, Manager
    • 5Two lines down from the inside address, strike the "Tab" key seven times and type in the subject line. The subject line tells the recipient what the letter is about. In this case, it should look like this:
      Re: Verification of address
    • 6Two lines down from the subject line, type in the salutation. The salutation could be Dear Sir, Dear Ms. Mulligan, Gentlemen, or To Whom It May Concern (if you don't know the name of the contact person). The salutation should look like this:
      Dear Ms. Mulligan:
    • 7Two lines down from the salutation start the body of your letter five spaces in from left margin. The body of your letter should start out saying something such as:
      I am writing you this letter to verify that 101 Washington Street, Lynbrook, New York 11593 is the address I should ship your order to.
    • 8Two lines down from the body of your letter, after striking the "Tab" key seven times, type in a complimentary closing such as:
      Very truly yours, or
      Sincerely
    • 9Four lines down from the complimentary closing and in line with the complimentary closing, type your full name in, like this:
      Jamie L. Mulligan
    • 10Sign your name in the space between the complimentary closing and your typed name.


Read more: How to Write an Address Verification Letter ' eHow.com http://www.ehow.com/how_4745362_write-address-verification-letter.html#ixzz2DRXhelUj

Nov 27, 2012 | Computers & Internet

1 Answer

How to tell if caps lock is on


Some keyboards will have a light that goes on when caps lock is turned on

Unlock the Caps on Computers


The All-Caps or "Caps Lock" function causes all letters to appear as capital letters when typing into word processing documents, emails or other files.


This is convenient when needing to type numerous capital letters or All-Caps phrases, as you do not have to hold down the "Shift" button with one finger as you type the words.


When All-Caps is stuck and does not respond to the "Caps Lock" keyboard button, a simple procedure overrides and shuts down the function.


Open a word processing program.


Press the "Caps Lock" button located on the left side of the keyboard to turn Caps Lock off. Type inside the document.


If lower case letters appear in the document, Caps are successfully unlocked.

Proceed if the text is in All-Caps.


Hold down "Shift" on the keyboard. Press the letter "P."

A lower case "p" appears in the document. Release the "Shift" button.


Type the phrase "rint" directly after the lower case "P." The word "pRINT" is now in the document, and the document cursor is after the phrase's "T."


Press "Enter" on the keyboard.

The cursor goes down one line and "pRINT" becomes "Print." The "Caps Lock" function is turned off.


Restart the computer to save the setting.


Enable the Caps Lock Key


The "Caps Lock" key is loved by some and disliked by others.

The key turns all letters into capitals as you type.


While this feature is useful in some situations, a more common occurrence is that the key is accidentally hit and all the text typed is capitalized.


The person typing must then delete the capitalized type and rehit the key to turn off "Caps Lock."

If the "Caps Lock" key needs to be enabled, it indicates that someone has disabled or remapped the key.


If a user wanted to, the "Caps Lock" key can be disabled and enabled through the registry or remapped through the control panels.


Updating the registry for the keyboard will enable the "Caps Lock" key.


Open the Notepad program.


Type the following:


[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout]


"Scancode Map"=-


Select "Save As" from the "File" drop down menu.


Navigate to the computer desktop as the save file location and choose "All Files" from the "Save as type:" drop-down menu at the bottom of the Save As window.


Type "enable.reg" without quotes in the "File name:" field and click "Save."


Minimize all open windows to view the desktop.


Double-click on the "enable.reg" file. A box will pop up asking if you are sure you want to run the file. Select "Run" or "Yes" and then click "Yes" for the Registry Editor warning.


Reboot the computer. The registry will be updated and the "Caps Lock" key will be enabled.


Manually Update the Registry


Click the "Start" menu, type "regedit" without the quotes and press "Enter." In older versions of Windows, Click the "Start" menu, select "Run," type "regedit" without the quotes and press "Enter." This will launch the Registry Editor.


Navigate to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout" to view the settings.


Right click on the "Scancode Map" setting and choose "Delete." Click "Yes" to confirm the deletion.


Reboot the computer. The registry will be updated and the "Caps Lock" key will be enabled.







Disable the Caps Lock Key in Windows


Your computer's Caps Lock key has likely only collected dust since you first brought the machine home.

The Caps Lock key is beneficial if you want to type a long string of words entirely in capital letters, but this form of typing is not needed often.


Consider disabling your Caps Lock key if you do not need it, or if you are tired of hitting the key accidentally while rapidly typing.


Restart your computer before beginning the process of disabling your Caps Lock key.


Download the registry file necessary to disable your Caps Lock key.


You have the option to disable your Caps Lock key or change the key to a number of different keystrokes.


For example, you may choose to use the "ChangeCapsToShift" registry file if you want the Caps Lock button to function as a shift key.


Double-click the registry file you have downloaded.


A prompt will appear on your screen asking if you would like to add the registry file to your computer's registry.

Select "Yes" to install the registry file.


Restart your computer, once again, to complete the registry change.

Upon reboot, your Caps Lock key will no longer function as a traditional Caps Lock key.



Disable the Caps Lock Key on a Computer


The Caps Lock is an easy key to hit by accident, and often the user does not realize it immediately.

When this mistake occurs, usually you must correct some text errors and your time is wasted.


If you think the Caps Lock key is more of an aggravation than it is good, follow these steps to disable your Caps Lock key.

Click on "Start" and select "Run". Type "regedit" into the textbox and hit "OK". This command will open the "Registry Editor" window.


Select "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control".

Double click on "Keyboard Layout" to open the folder.


Open the "Edit" menu and choose "New" then "Binary Value".


A new file will appear on the right side of your screen with the file name highlighted.

Type "Scancode Map" for the new file name.


Double click to open and type in "00000000 00000000 0200000000 003A00 00000000" into the Value data box. Hit the "OK" button.


Close the "Registry Editor" by selecting "Exit" from the "File" menu.

Restart your computer for the change to go into effect and enjoy life without the Caps Lock Key.


Hope this helps

Nov 05, 2012 | Computers & Internet

1 Answer

Why my email cannot open. Invalid ID or password.


Make sure that your using a "Shift" key/selection before capital letters in your login name or password; if there are any capital letters.
If both login name, and password only contain lower case text, make sure "Shift" isn't being used and that their isn't a "CAPS LOCK" engaged.

Aug 24, 2011 | Yahoo YHT-630 System

1 Answer

What are the names of kyboard and its keys ?


it is only for a computer keyboard hope it help from you.

A computer keyboard serves as a main operating tool for accessing and inputting data into a computer. The keyboard features many functions and keys that a user may never use, but is still essential to some users. Understanding the keyboard can improve computer knowledge and use.

QWERTY Pad

The "QWERTY" pad is main sections of letters on the keyboard. These letters are mainly used for typing and also as shortcuts in programs like Windows Movie Maker, Adobe After Effects and computer games.
Number Pads

The far right side of the keyboard features a number pad that resembles a calculator. This number pad is essential for programs like Excel, but can also be used to input numbers as a typing function. More numbers are just above the "QWERTY" keyboard that also feature symbols when the "Shift" button is used.
Arrow Keys

The right bottom of a keyboard features four directional arrow keys. These keys provide navigation through word processing documents and also serve as scrolling functions in web browsers.
F Bar

The top of a keyboard features the "F Keys," a selection of keys that extends to "F12" on most keyboards. These keys serve different functions. For example, "Alt and F4" exits out of a program. "F1" will start the typing helper in word processing programs.
Extra Keys

New keyboard feature shortcut keys at the top of the keyboard. These include shortcuts like "Power," "Sleep Mode," "Calculator," "My Computer" and "Web." Some also include media controls for movies and music.

Aug 11, 2011 | Acer NSK8458AN Keyboard

1 Answer

PANASONIC KX-T7731 PHONE I HAVE MY EXTENSIONS PROGRAMMED BUT I NEED TO CHANGE THE NAMES FOR EACH EXTENSION AND I CANNOT FIGURE OUT HOW. THE PREVIOUS SECRETARY HAS BEEN GONE FOR 3 YEARS BUT HER NAME STILL...


I"d start by pressing the Caps Lock button on my keyboard to ask a question and use that key marked Shift to capitalize the first letter of a sentence and proper names.

Extension names are programmed in SYSTEM programming. Access to that is done from the phone connected to the first extension in your system, usually 101, with a system password. In a TA Series, it's program 604. In some others, it's program 004.

Carl

May 24, 2011 | Panasonic KX-T7731 Corded Phone

2 Answers

I can`t get any upper case functions to work on hp 2011 keyboard what key do i press


1.Make sure the "Caps Lock" key is not on. Though this will be obvious to most people, if your keyboard is typing in only upper-case letters it can't hurt to check. Look at the "Caps Lock" indicator light on the top right corner of your HP keyboard. If the light is on, strike the "Caps Lock" key on the left side of your keyboard. This will turn the "Caps Lock" off, allowing you to type in lower case letters again.

2.Make sure the "SHIFT" keys on your HP keyboard are not stuck. Dust and dirt can build up on a keyboard over time, which can cause certain keys to stick. If either of your keyboard's "SHIFT" keys get stuck, your computer will type in only capital letters. Use a toothpick or cotton swab to remove the gunk from the key, which should help it return to its normal position.

3.Unplug your HP keyboard and then plug it back it. This will remove the device from your operating system and then automatically add it back in. This can have the same effect, essentially, as restarting your computer. If your keyboard was typing in capital letters due to an error being stored in your operating system's memory, that error will now be cleared and the HP keyboard will function as normal again.

4.Update your HP keyboard driver. Click "Start" and then right click on "Computer." Click "Properties" and then "Device Manager." Right click on the listing for your keyboard and then click "Update Driver." This will update the computer software that is associated with your HP keyboard. If your keyboard was typing in all capital letters as a result of an error with this driver, the error will now be fixed and you can use your keyboard normally again

Mar 01, 2011 | HP D8597A Keyboard

1 Answer

Excel lookup - match index array


The best solution may be to re-define the named columns, or to add new names to multi-column arrays, then use the VLOOKUP function.
Note that the "indexed" named cells must be sorted by the index column.

Test (this is a 2 year old question)... Please ignore ths following. The plus symbol does not display.
Upper key plus symbol displays:
Right plus symbol on number pad displays:
[Shift] Right plus symbol on number pad displays:
[Alt] [4] [3] displays:
slash/slash/plus displays: //
slash/plus/slash displays: / /
Plus Plus Plus displays:
upper Plus Plus Plus displays:
Shift Right plus plus plus displays:

end of plus test.. thanks.

Dec 09, 2008 | Microsoft Excel for PC

2 Answers

Texting on my blackjack


you push the caps/shift key then the letter you want, not at the same time.

Jul 18, 2008 | Samsung Blackjack SGH-I607 Smartphone

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

43 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18384 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...