Microsoft Excel shortcut keys

                              

            Microsoft Excel shortcut keys

 

Shortcut	Description
F2	Edit the selected cell.
F3	After a name has been created F3 will paste names.
F4	Repeat last action. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.
F5	Go to a specific cell. For example, C6.
F7	Spell check selected text or document.
F11	Create chart from selected data.
Ctrl + Shift + ;	Enter the current time.
Ctrl + ;	Enter the current date.
Alt + Shift + F1	Insert New Worksheet.
Alt + Enter	While typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell.
Shift + F3	Open the Excel formula window.
Shift + F5	Bring up search box.
Ctrl + 1	Open the Format Cells window.
Ctrl + A	Select all contents of the worksheet.
Ctrl + B	Bold highlighted selection.
Ctrl + I	Italic highlighted selection.
Ctrl + K	Insert link.
Ctrl + U	Underline highlighted selection.
Ctrl + 1	Change the format of selected cells.
Ctrl + 5	Strikethrough highlighted selection.
Ctrl + P	Bring up the print dialog box to begin printing.
Ctrl + Z	Undo last action.
Ctrl + F3	Open Excel Name Manager.
Ctrl + F9	Minimize current window.
Ctrl + F10	Maximize currently selected window.
Ctrl + F6	Switch between open workbooks or windows.
Ctrl + Page up	Move between Excel work sheets in the same Excel document.
Ctrl + Page down	Move between Excel work sheets in the same Excel document.
Ctrl + Tab	Move between Two or more open Excel files.
Alt + =	Create a formula to sum all of the above cells
Ctrl + '	Insert the value of the above cell into cell currently selected.
Ctrl + Shift + !	Format number in comma format.
Ctrl + Shift + $	Format number in currency format.
Ctrl + Shift + #	Format number in date format.
Ctrl + Shift + %	Format number in percentage format.
Ctrl + Shift + ^	Format number in scientific format.
Ctrl + Shift + @	Format number in time format.
Ctrl + Arrow key	Move to next section of text.
Ctrl + Space	Select entire column.
Shift + Space	Select entire row.
Ctrl + -	Delete the slected column or row.
Ctrl + Shift + =	Insert a new column or row.
Ctrl + Home	Move to cell A1.
Ctrl + ~	Switch between showing Excel formulas or their values in cells.

Read More

What can We Do with GOOGLE Instead of Search Websites?

What will we have a tendency to Do with GOOGLE rather than Search Websites?

Google Search (or Google net Search)

Is a net program owned  by Google Iraqi National Congress. Google Search is that the most-used program on the globe Wide net handling quite 3 billion searches daily.The main purpose of Google Search is to explore for text in publically accessible documents offered by net servers, as critical different knowledge, like with Google Image Search. Google Search was originally developed by Larry Page and Sergey Brin in 1997.Google Search provides a minimum of twenty two special options on the far side the initial word-search capability. These embrace synonyms, weather forecasts, time zones, stock quotes, maps, earthquake knowledge, flick showtimes, airports, home listings, and sports scores.

There ar special options for dates, as well as ranges, prices, temperatures, money/unit conversions, calculations, package following, patents, area codes, and language translation of displayed pages.

In Gregorian calendar month 2011, Google introduced "Google Voice Search" and "Search by Image" options for permitting the users to go looking words by speaking and by giving pictures. In could 2012, Google introduced a brand new information Graph linguistics search feature to customers within the U.S.

"We will Do lots of Things With Google rather than Searching/Surfing Websites."
Special options

 on the far side the quality word search capability, Google will quickly show things just like the current time or weather of a selected city; it may be wont to track packages; as a calculator for basic and fairly advanced mathematics operations; and might convert things like currency, weights and measures.
Time and weather

 to search out the time in another corner of the world merely enter "time" then the name of an oversized town or country -- time Berlin as an example. Likewise, weather humidness, temperature and forecast may be viewed by typewriting the word "weather" followed by the required location.

What will we have a tendency to Do with GOOGLE rather than Search Websites?
Calculator and package following

Use Google for mathematics equations by coming into them as a question  -- 3*2 can work, however thus can a a lot of complicated calculation like 94/36*(sqrt 34)^3. Most symbols and integers may be swapped with written words, too. typewriting the following range for your UPS, FedEx or US Postal Service package directly into the search box can get you fast links to simply track the standing of   your cargo.
Unit conversions

                             Conversions ar even as simple. merely enter variety followed by one thing like USD to GBP, mm to inch, physicist to astronomer. Be it teaspoons, microseconds, bytes or kilometers, Google's conversion calculator is sort of featured, and might be used for with reference to any unit that involves mind.
Other tweaks

 whereas all of that's handy and straightforward to use, things get rather more complex. By victimisation the right strings of text, you'll even use Google search in situ of a P2P program to search out songs, video clips, and different media. There also are many minor hacks and tweaks.

For instance, Omgili shows a way to tinker with a Google search universal resource locator to urge period of time results. this can be notably helpful for locating news associated with current events; here's the newest on military unit (in progress as of this writing) at intervals a thirty minute timeframe, by the way.

Read More

Some Common Printer Problems and Easy Solutions

 Some Common Printer Problems and Easy 

Solutions

Introduction                          

                                Printers: Can't live with them, can't nuke them. You could always toss a misbehaving inkjet or laser out the window, but where would that leave you? Truth be told, we need our printers, despite their maddening quirks.Below are Some Most Common Issues that Users Faces in their routine life.

No.1:Problem: Printing is too slow.

Solution:

                      Increase printer performance and save ink in the process >> by reducing print quality for everyday output. "While printer settings vary by model," here's how to switch to draft-printing mode in most Windows apps.Select Print and Properties, and then look for a setting that reduces print quality. With the HP Photo-smart 8450, for instance, change the default print quality setting from Normal to Fast Draft (click screen-shot at right). Other speedup suggestions: Print pages from websites without graphics, and add RAM to your printer, if possible. In this way your Printer's Performance will increase.

No.2:Problem: Ink and/or toner costs too much.

Solution:

                     PC World has written a lot about the printing industry's sneaky practices over the years. To wit: They snare you with dirt-cheap printers sold at or below cost, and then stick it to you later with ultra-pricey consumables.Based on our tests, we can't recommend third party vendors' re-manufactured or refilled ink cartridges, which may not give you your money's worth. One cost-saving solution is to buy higher-capacity cartridges. If you print a lot, try an ink cartridge with a 250-plus page yield, or a toner cartridge with a 2,000-plus page yield.

No.3:Problem: Windows is sending print jobs to the wrong printer.            

Solution:

                 For some mysterious reason, Windows may select a new default printer--the one it automatically sends print jobs to. (This happened to me when I upgraded from Vista to Windows 7.)To fix this glitch in Windows 7, click Start (the Windows icon in the lower-left corner of the screen) and select Devices and Printers. Under Printers and Faxes, right-click the printer you want to make the default, and select Set as default printer. If you're using earlier versions of Windows, these steps vary a bit

For Feedback and Suggestions Please Comment

Read More

Increase Your Slow Internet Speed By some Simple Methods

 Increase Your Slow Internet Speed By some Simple Methods

This article is a tutorial that explains how to speed up  Your Internet Using Internet Explorer 6, 7 and 8 without compromising on features. Most users of this guide will immediately see up to a 100% boost in speed with the first optimization. So lets start Boosting your Internet Speed.

                                    :::Method one is:::

1. Disable Unneeded Add-ons

                                       This is the Number 1 culprit in slowing down your browser. To get an idea of the speed boost you can get, go to Start > Programs > Accessories > System Tools > Internet Explorer (No Add-ons).

How Much Speed Are We Talking?

You will now see Internet Explorer start without any add-ons or toolbars. The speed of how the browser starts now may have startled you.

Try out the browser now. Very much faster? 

Now you realize how those pesky add-ons have been slowing down your browsing experience.

"However, in this mode, you won't be able to watch YouTube videos as the Flash add-on is also disabled."" We will fix this now.

Close the browser and start the browser as normal. In the browser, go to http://www.google.com. Next, we need to go to Manage Add-ons

- For IE8 and IE6, go to Internet Explorer > Tools > Manage Add-Ons.

- For IE7, go to Internet Explorer > Tools > Manage Add-Ons.> Enable or Disable Add-ons

You will now get the Manage Add-ons window

 Manage Add-ons window in IE8 

                                                                     This is how Manage Add-ons looks like in IE8. The difference between earlier versions is that they have some additional functionality missing, but the main functions we need are there.

Make sure under 'Show:', only 'Add-ons currently loaded' is selected

For IE8, under "Show:", "Currently loaded add-ons" should be selected

For IE6 and IE7, under "Show:", "Add-ons currently loaded in Internet Explorer" should be selected

Now you have a list of add-ons that are currently loaded. What you need to do now is to disable all add-ons that you don't need. 

So now you ask, how to disable an add-on?

For IE8, click the add-on on the right column, and click the Disable button at the bottom.

For IE6 and IE7, click the add-on and at the Settings box at the bottom, click Disable.

                                :::Method Two is:::

2. Increase the Max Connections Per Server

                                                                                                              Internet Explorer 7 and below are limited to two connections per server. This is why you can only download a maximum of two files from one website. Internet Explorer 8 raises this limit to 6.Here is how to increase the number of HTTP simultaneous connections to 10. By having 10 connections, IE will be able to download 10 different files at one time. This will make web pages load faster.

If you are using Internet Explorer 7 and below Then Follow these Instructions:::
1.Go to Start > Run

2.Enter "regedit" and hit ENTER
3.On the left, navigate to the following
                   HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings                          folder by:
4.Click HKEY_CURRENT_USER, then

5.Software, then
6.Microsoft, then
7.Windows, then
8.CurrentVersion, then
9.Internet Settings
10.Internet Settings should be selected on the left column
                 Go to Edit > New > DWORD Value

11.A box should appear. Put the name as "MaxConnectionsPer1_0Server", without double quotes. Press                      Enter.
12.Double click the entry you just created, select Base as "Decimal" and type 10 under Value data
                Go to Edit > New > DWORD Value
13. A box should appear. Put the name as "MaxConnectionsPerServer", without double quotes. Press                         Enter.
14.Double click the entry you just created, select Base as "Decimal" and type 10 under Value data
               Close Registry Editor
Now
Restart your system

If you are using Internet Explorer 8 then Follow these Instructions:::

1.Go to Start > Run

2.Enter "regedit" and hit ENTER

3.On the left, navigate to the following HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet                        Explorer\MAIN\FeatureControl\FEATURE_MAXCONNECTIONSPERSERVER folder by:
4.Click HKEY_LOCAL_MACHINE, then

 5.SOFTWARE, then

6.Microsoft, then

7.Internet Explorer, then

8.MAIN, then

9.FeatureControl, then

10.FEATURE_MAXCONNECTIONSPERSERVER
              FEATURE_MAXCONNECTIONSPERSERVER should be selected on the left column
11.Go to Edit > New > DWORD Value
             A box should appear. Put the name as "iexplore.exe", without double quotes. Press Enter.
             Double click the entry you just created, select Base as "Decimal" and type 10 under Value data
             On the left, click on FEATURE_MAXCONNECTIONSPER1_0SERVER, which is just near to                   the one already selected
12.Go to Edit > New > DWORD Value
              A box should appear. Put the name as "iexplore.exe", without double quotes. Press Enter.
13.Double click the entry you just created, select Base as "Decimal" and type 10 under Value data
               Close Registry Editor
14.Restart your system and the changes should take effect


                                :::Method Three is:::


3.Optimize Your Internet Connection

Optimize TCP settings for Windows XP, Vista and Windows 7

 TCP Optimizer Main Window

Follow the Steps to optimize your internet connection.
1.First, download and extract the files to any folder. Download From HERE

2.Double-click on the TCPOptimizer application in the folder to launch it
3.At the bottom of the window, click "Optimal"
4.At the top of the window, drag the slider to select your connection speed. If you are not sure, run the
     speed test. Use the value that you get for the Download field (which is in kb/s) and set the slider to it.
      If you are using ADSL, check with your Internet Service Provider whether it is based on PPPoE or             PPPoA. You may also be able to obtain the information via your router's homepage. If your                        connection        is based on PPPoE, tick the PPPoE box.
5.Under the "Network Adapter selection" box, select the network adapter you use to connect to the                   Internet. If you are unsure, go to Start > Control Panel > Network Connections. Your connection should        be listed there. Most of the time, it is Local Area Connection. Select the entry and the status bar at the         bottom should display the network adapter name.
6.Click 'Apply Changes' at the bottom of the window.
      Ensure that 'Backup' is checked and click OK at the next confirmation box that appears.
Once the changes are done, reboot your system
NOTE:::
                                     " This would have optimized your settings according to your internet connection you have. If you need to undo the changes TCP Optimizer made, open TCP Optimizer > File > Restore Backup Settings. "
Hope It will Work :::

Read More

How many Types of Keyboards ?

 How many Types of Keyboards ?

Introduction:

                                   In our Daily Routine we rarely Use keyboard and we know why it is used. But some of us wants to know the definition of Keyboard. Keyboards are not only used in Computers it also uses in "Piano" and "other instruments"

Definition of a Keyboard:

                               

"A panel of keys that operate a computer or typewriter."

OR

"A set of keys on a piano or similar musical instrument."

OR

"A keyboard is an important device that enables us to input data into the device that is being used with."

Types of Keyboards:

                                                      Initially, there was almost no variation in the kind of keyboards that were produced. However, slowly manufacturers started observing the need to come up with keyboards with features that catered to different niches of market segments derived out of different types of needs. This resulted in a huge variation in the keyboards produced, some of which remain extremely popular even today. Given below are some of the most common variations of keyboards available in the market today.

Types of Keyboards are:

1. Standard Keyboards

2. Ergonomic Keyboards

3. Wireless Keyboards

4. Compact Keyboards



5. Internet Keyboards

6. Gaming Keyboards

7. Virtual Keyboards

Standard Keyboard

                         Though standard keyboards have undergone considerable changes in design over the last 20 years, their basic layout remains similar. The average number of keys on a regular keyboard is 105, though some older versions have keys in the range of 95-103. Even though standard keyboards are the most basic form of keyboards, they can have slight variations, especially in the manner the keys are placed.

QWERTY keyboards are the most common and have the six alphabets Q, W, E, R, T, and Y in the first row, while in AZERTY keyboards these letters are replaced with A, Z, E, R, T, and Y in the first row. AZERTY keyboards are used primarily in French countries. Other forms include QWERTZ and Dvorak keyboards.

Ergonomic Keyboard

                                                        Ergonomics refers to the study of methods that can reduce stress on muscles to avoid repetitive strain injury. It mostly deals with optimizing posture and technique while working, so the work can be carried out in the easiest manner with the least possible strain on any muscle, joint, or organ.

Ergonomic keyboards are designed in such a way that typing can be done putting the least amount of stress on the fingers and wrist. This is a radical type of keyboard designed to prevent Carpal Tunnel Syndrome, which causes numbness and tingling sensation in the hands and fingers after typing for a long duration.

Ergonomic keyboards come in two forms:

As a single piece, where a group of keys have been split in such a way, that the angle at which the user places his or her wrist to type is the least stressful.

In the form of separate pieces, each having a group of keys, so that the user can set the angle according to his or her convenience.

Hence, these keyboards differ from the usual single piece keyboards that are straight and contain keys as one whole group.

Wireless Keyboard

                       

As the name suggests, these keyboards do not need to be connected to the computer via a wire. This makes it very convenient for the user to use the keyboard comfortably. Wireless keyboards use three basic types of connections, Bluetooth, Infrared (IR), and Radio Frequency to connect to the computer.
All the three types of wireless keyboards need external power to function. In most models, the power comes from either 2 or 3 'AA' or 'AAA' batteries. Rare models might have an included battery, which can be charged with the help of a USB cable. In addition to this, all three types also use a transceiver, which connects to a port on the computer and maintains contact between the computer and the keyboard.

The best of the lot are Bluetooth keyboards. These keyboards connect using Bluetooth technology, and hence have the best range of about 30 feet. Moreover, they are also compatible with other devices that support Bluetooth technology.




Next in line are RF keyboards, which have a limited range of only about 6 feet, but are much cheaper than Bluetooth keyboards, and much more effective than IR keyboards. The latest models of RF keyboards have no issues like frequency disturbance, and can be the best bet if you do not need more than around 5 feet of freedom.




Last come IR keyboards, which have a major drawback. They need to be in the line-of-sight of the transceiver. This makes it very difficult to use such keyboards effectively, and almost impossible to use mice featuring this technology. Though they are not as expensive as Bluetooth keyboards, and have a decent range of about 12 feet, the line-of-sight problem makes this type very ineffective.

Compact keyboard

                        Compact keyboards are slim and usually do not have the numeric keypad that is present on the right side of other keyboards. These are typically used in laptops, where sizing issues make it difficult to accommodate a standard keyboard. To make up for the small size, these keyboards rely on the use of multiple keys to carry out functions that would only use a single key on a standard-sized keyboard. Some models also include a touch-pad that can be used instead of the mouse.

These are not extremely small in size, but offer portability during travel and storage. Another benefit of compact keyboards is that they can be used by people with certain disabilities that hinder them from effectively using hand and finger movements.

Internet Keyboard

                       The Internet is one of the main reasons why a majority of the people use computers these days. Internet keyboards have special keys, called hot keys, which perform functions related to Internet usage. Typical hot keys have functions like back, forward, bookmarks list, e-mail inbox, Google search, YouTube, shopping online, etc.

This makes browsing the Internet very convenient, as the user does not have to go through the process of clicking buttons via a mouse. These days, many standard keyboards have adopted the concept of Internet keyboards by placing these buttons on the top, since almost every kind of work requires the use of the Internet.

Gaming Keyboard

                      As the name suggests, gaming keyboards are designed specifically for gamers. They include features meant to enhance gaming experience, as well as provide convenient usage for gamers. They include features like volume control, key lighting, programmable keys, interchangeable keys, touch screens to customize the keyboard, in-built joysticks, fancy lighting, etc.

Gaming keyboards come in all shapes and sizes, ranging from round keyboards to v-shaped ones, but this is mainly done as a marketing gimmick to attract gamers. Many gaming keyboards are designed for specific types of games. For instance, first-person shooter games require the direction keys to be placed in a manner that do not cause repetitive stress to the fingers and wrists.

Virtual Keyboard

                     Virtual keyboards are software devices that let you input data just like a hardware keyboard. They open up as an application and can be controlled by a mouse or via a touch screen. They are mainly used in devices which do not necessarily require a keyboard, like a tablet or a smart-phone.

They are useful as they aid in making the size of the device smaller. Virtual keyboards are also used in situations concerning security, as anything entered on an ordinary keyboard is recorded in a key log, leading to security risks associated with passwords or PIN numbers. This is the reason many banks provide the facility of a virtual keyboard in their online banking operations.




This was a little information on the different types of keyboards available. Based on your requirement, you can choose any of the keyboards mentioned above. When choosing a keyboard, remember that the most important thing to look for is comfort.

Read More