Callmate hits back-to-back ceilings

KARACHI: The scrip of Callmate Telips continued to enjoy the upper lock last week. This is indicative of the substantial confidence of the shareholders on the new management of Callmate. Buyers are demanding 4.7 million shares but at current prices, they are reluctant to sell out. This move signifies that shareholders are waiting for share prices to meet buyers' purchase value.
Some positive developments have also taken place in the Callmate as a result of the meeting amongst Callmate's Chairman Audit Committee Saleem Shahzad, Chairman Muhammad Jawaid Iqbal, Senior executive vice president (SEVP) & Group Chief and Junaid Alam, Regional Corporate Head-Karachi, Allied Bank who is a major creditor of the company and has rescheduled its loan of Rs: 250 million.
The shareholders have greatly appreciated this professional and progressive measure of ABP. On the other hand, the Chief Executive Officer Asif Shehzad and Director Syed Usman Haroon had a constructive meeting with the officials of PTCL in Islamabad whereby the PTCL has agreed to facilitate Callmate to restart its business and asked the Company to submit viable proposals for the mutual benefits of PTCL and Callmate.

Stock of CallMate

KARACHI: The scrip of Callmate Telips on Thursday closed at upper lock (Rs 14.20) after hitting 23 lower locks continuously and sinking to Rs 13.20 on December 12 2007 from RS 45.25 on November, 8 2007.The story started after the company had announced an unexpected result on 12 November 2007.
The company posted loss after taxation of Rs 359 mn (LPS of Rs. 5.50) in FY07 as compared to profit after taxation of Rs 603 mn (EPS of Rs. 9.23) in FY06. The investors and analysts were expecting profitable results but loss has shocked the overall investor's sentiment.
Yesterday the game started after 12 pm when callmate again hit the lower lock at Rs12.20, but after 12 pm the buying started both in open as well as in odd lot markets and this continuous buying from some brokers helped close the scrip with its upper lock at RS 14.20. The overall 6.6 million shares were traded in open market. Shujaat Ali Qarni, the new chairman of the Callmate Telips, is now looking to reestablish the company. Callmate has to pay off around Rs.1 billion payable to PTCL.
According to our sources the officials of Pakistan telecommunication authority are also negotiating PTCL management about these huge liabilities.
We expect that in the coming weeks there may be some changes expected in Callmate Telips Company.

Help them!

On my way back to office in the morning I saw this cute nice boy cutting onions in one of the street hotel.

I wish I had enough to pay him daily for his expenses and ask him to study.

I request every one to find these kind of people and help them as much as you can.

Regards,

Muneeb

Technology Bubble

Superb Video on what is going on right now :)

Regards,

Muneeb

Time or Priority

It's not the time we don't have, it's the priority we are unaware how to set.

I always use to say that, i don't have time to do this or that but never though for a moment that actually I do have time but in that given time my priority is different.

I realized this when, one of my friend told me that he is not having ample time to study while he is busy in his business and I told him ma friend it's not time it's ur priority towards ur business.

Now if you will prioritize your study more then it will pay you off in long run.

So always remember it's priority not the time.

Muneeb

Google to focus on mobile Internet in China

Google says it's grappling with an unusual challenge in China's Internet market how to cater to masses of Web surfers who go online for the first time via mobile devices, rather than migrating from PCs. That is prompting the company to design new products tailored to the local market, and it may make more acquisitions in the country to help that along, Lee Kai-fu, Google Inc's president for greater China, said.

PSEBs new software to up SMEs efficiency

KARACHI: Pakistan Software Export Board (PSEB) has successfully developed open source Enterprise Resource Planning (ERP) software, styled as Auto Plus, for Small and Medium Enterprises (SMEs) in readymade garments, hosiery, automotive parts and accessories, textile processing and surgical instruments' verticals, Board officials said here Thursday Developed under PSEB's project, in collaboration with Pakistan Association for Automotive Parts and Accessories' Manufacturers(PAAPAM) and 15 of its more far sighted member units, four unique ERP software's have been developed by member companies of PSEB. This ERP software's have been designed to improve the productivity of SME units. The PSEB initiative also aims to allow the local software companies to gain expertise in the development of ERP solutions for the local manufacturing industry and to promote the use of open source technology. The newly developed ERP software has been successfully implemented at a model unit, 'Kortech Industries' in Lahore. Using this technology, Kortech Industries has now automated all its processes from customer order to the delivery of goods. The implementation of ERP software has resulted in an 87 % reduction in time and a 70 % reduction in human resources needed at the model unit. Official stated that the product is now being implemented at 14 additional PAAPAM units. After implementation in 15 member units of PAAPAM, the product will be available, free of cost, for over 250 other member units of PAAPAM. The additional units will only have to pay the cost for implementation of the software. SME BSF (Business Support Fund) has approved to provide 50 % funding for the implementation cost. PSEB has initiated this project in order to help SMEs to increase their operational efficiency and become more productive, thereby resulting in increasing Pakistan's exports. Presently, according to a World Bank study, SMEs in Pakistan are not operating at their full potential. The SMEs in Pakistan employ around 80 % of the total workforce, but contribute only 35 % to the national Gross Domestic Product (GDP).PSEB is a government agency mandated to promote Pakistan's IT industry, including software, services, hardware and call centers, locally and globally. PSEB regularly sponsors its member IT companies to participate in International Trade Shows and Exhibitions to help Pakistani companies showcase their capabilities and develop lucrative business contacts.-APP

Groovytel.com now offer free service

GroovyTEL.com - Now a FREE Service

GroovyTel.com the company the only company in that gives Incoming Numbers for Yahoo, MSN, Google Talk is now FREE.
Any one, from anywhere in the world, can SIGNUP and get a FREE USA Number at no charge, to enjoy and receive calls on there MSN, Yahoo or Google Messenger, or even FWD.

Earlier this offer was for first 10,000 Customers, but now it is Totally FREE.

Groovytel Plans to offer in future numbers from local area codes, and plan to charge for those.

Pak to be 1st emerging market to start REITs --(SECP)

Commissioner of Securities Exchange Corporation of Pakistan (SECP) Salman Ali Shaikh said on Wednesday that Pakistan will be the first emerging market to initiate Real Estate Investment Trusts (REITs). "The objective of REITs is anchored around the concept to introduce an alternative asset class with the purpose to add depth to the capital market and provide transparency to real estate sector in the form of comprehensive disclosures and accountability through a trust mechanism ingrained in the REITs Regulations," he said at SECP consultative meeting held to discuss REITs Regulations, 2007 in Lahore on Wednesday. The session was a sequel to the earlier one held in Karachi on August 9, 2007. The participants of the meeting included prominent lawyers, chartered accountants, real estate developers, constructors, surveyors, valuers, project managers and representatives from the Punjab Government.

2 moons on 27th August 07

Two moons on 27th August

"27th August" the Whole World is waiting for.........

Planet Mars will be the brightest in the night on the sky starting August.

It will look as large as the full moon to the naked eye. This will cultivate on August 27; when Mars comes within 34.65M miles of earth. Be sure to watch the sky on Aug. 27,2007 10:00 pm(KSA) & 12:00 am(PAK) In INDIA at12.30 am. It will look like the earth has 2 moons. The next time Mars may come this close is in 2287.

Share this with your friends as NO ONE ALIVE TODAY will ever see it again.

http://www.bbc.co.uk/wiltshire/weather/nightskyaug.shtml

GigaOM column on the relaunch of FWD by Daniel Berninger, President FWD

Daniel Berninger
president, FWD
web: www.fwdnet.net
>>>>>>>>>>>>>>>>>>>
GigaOm: FWD relaunches to break the telco trance

Written by Daniel Berninger

The media educator John Culkin remarked: "We don't know who discovered water, but we're certain it wasn't a fish." The observation summarizes why I recently pitched Jeff Pulver on relaunching FWD, the VoIP operator formerly known as Free World Dialup. (Disclosure: I am helping Pulver relaunch FWD.)

Though not as well-known as Skype or Vonage, FWD, now 12 years old, is the longest-surviving VoIP company in the world. From the beginning, FWD distinguished itself through advocacy efforts (e.g. FCC Pulver Order) and enabling tools (e.g. free SIP device registration), which helped the company attract some 700,000 registrations.

FWD does not seek to provide a communication service as much as empower amateurs to create their own communication solutions. The do-it-yourself ethic saves end users from waiting for the so-called experts to awake from their telco-trance and figure it out for us.

A decade into an Internet-enabled communications era, most communication offers remain bound by 20th century definitions. Consider the examples of SunRocket and the newcomer, Ooma. We can debate the technical innovation or pricing advantage(s) of their respective products, but both companies viewed the world through a telco lens focused on one thing: Getting a share of profits enjoyed by entrenched telcos.

The usual business theory that success depends on providing better value to consumers falls short in the case of telco startups. It fails due to two line items on the income statement: 'marketing expenses' and 'COGS (cost of goods sold). Marketing is expensive because it's hard to win customers.

New entrants like Ooma will spend far more on customer acquisition than incumbents ever have, because incumbents acquired their customers in a monopoly context and now need only invest in retaining them. Incumbents own the telephone network, too, which puts new entrants at their mercy for interconnection, inflating COGS. There are still more expense traps for new entrants that survive the marketing and interconnection gauntlets (just ask Vonage.)

The death rate of start-ups that touch the telephone network remains near 100%, but startups pursuing new ways to enable voice communication need not limit their efforts to improving the telephone call, because "communication" is not synonymous with "telephone call." After all, a telephone call falls woefully short as an alternative to meeting someone in person. The audio quality of telephone calls compares unfavorably to even AM radio.

FWD sustains itself through a membership option to keep the focus on communication rather than billing systems. Ooma represents a step in the right direction. It trades the usual services model for a consumer electronics model, but the Ooma device still has to compensate for a ton of telephone network baggage.

The arrival of the Internet can release us from the limitations of the telephone network, yet so far we have been inexplicably unwilling to use this key to our freedom to venture outside the telephone network prison. Even as the experts tell us the price of a voice call will drop to zero, both AT&T and Verizon managed to enforce price increases in the last 12 months.

This is one reason why calling costs still leave two thirds of the world's population with few, if any, communication options. Yet all this can change for those following FWD's lead: Imagine a communication future as if the traditional phone network never existed.

Poem from an Unknown person

Around the corner I have a friend, In this great city that has no end,

Yet the days go by and weeks rush on, And before I know it, a year is gone.

And I never see my old friends face, For life is a swift and terrible race.

He knows I like him just as well, As in the days when I rang his bell.

And he rang mine but we were younger then, And now we are busy, tired men.

Tired of playing a foolish game, Tired of trying to make a name.

"Tomorrow" I say! "I will call on Jim, Just to show that I'm thinking of him."
But tomorrow comes and tomorrow goes, And distance between us grows and grows.
Around the corner, yet miles away, "Here's a telegram sir," "Jim died today."

And that's what we get and deserve in the end. Around the corner, a vanished friend.
Remember to always say what you mean. If you love someone, tell them.

Don't be afraid to express yourself. Reach out and tell someone what they mean to you.

Because when you decide that it is the right time it might be too late.

Seize the day. Never have regrets. And most importantly, stay close to your friends and family, for they have helped.

Deregulation of a Monopoly / Karachi Electric Supply Corporation II

Thanks Rehan for the pointer, concern to the issue of electricity for Karachi.

Just this morning at about 9-45 am I had a detailed discussion with the electricity regulator known as NEPRA in Islamabad, whereby I had sent and eMail just 4 days before for an NOC for wind power on self finance basis, but an NOC whereby the KESC will install a digital meter which will allow Reverse Metering for the units generated by Wind Power and not consumed for any reason, will be sent to the KESC network, and will be absorbed the KESC. Hence a consumer will get credit by reversing/debiting the units, which means you are reducing your units burned from KESC, or have a plus or credit depending on the units generated.

In view of the wind velocity, which is good in coastal belt of Karachi, Thatta etc., the wind power is cost effective. Some initiative of wind farms at Thatta where land is provided free to establish wind farm for power generation, and the ultimate power will be purchased by WAPDA at guaranteed rate, and gaurateed by the Govt. They are in process and will be comissioned shortly.

Probably what I'm told by the DG Nepra yours is the first case/application we've recieved, and will consider the case.

I have mentioned the just few days before deregulation of power utilities in the EU on the pattern of UK, whereby local utilities as gas which are pipes, and cable of electric utilities can share with other local utilities duly licensed by the Govt., will be allowed at the EU.

I had exactly quoted him the telecom., sector deregulation, and the monopoly of PTCL wires, and the case, which sounded very, very interesting to the gentleman on line, who had to rush for a meeting immediately, and wanted to discuss the area.

With alternate energy, the important cost effective in coastal as Karachi is wind power whereby utilities are established in EU for supply of power as low as 6 cents per KW/hr, with cost/benefit ratio.

I'm trying to locate wind data which studies has been carried out by various private and Govt. entities which indicates the exact wind velocity, to justify the establishment of wind mill to generate power. In some areas as the area where I live, there isn't enough wind, in view of buildings, and other reaons, so the power will not be irregular. In such cases the power generated can be taken at an invertor, and then a/c. current could be used, or sold to the KESC as per production of the wind cycle.

The most important area is the grant of licenses to the local, or community licenses utilising the KESC network to supply electricity to commercial, domestic and industrial units. The optimum size power generation could be utilised for thermal, and wind power.

In my discussion just this morning I have mentioned the case of deregulation of PTA and how it has successfully been appreciated.

The EU case model and deregulation is very interesting and should be studied and be taken on its own merits to Pakistan consumer, to overcome the scarcity particularly Karachi.

Hence investment could be pooled from community based on a community group or companies managed and owned by the group leader/member and operated effectively, with the sense of ownership, and cost benefit.

Regarding MQM they're saying now in todays newspaper to put a waiver for June bill to the consumer from KESC. They don't realise the KESC with deficit of almost a couple of million deficit each month, is running in heaviest losses, at the current rate. If the bills are not paid by the consumer for one month, how they will pay the salaries, and how they will purchase fuel, consumables etc., Making slogans for giving free for one month for the whole city of Karachi is non sense.

The most important breakthrough will be the breakup of monopoly of WAPDA/KESC, which I think is the right time to be taken on the platform of deregulation in other markets, and also India.

This will be a contribution to the society for self reliance, and entrepreneural spirit. I see the future exactly on the pattern of the telecom., sector de-regulation and licensing in the power sector, exactly on what you have highligted is the breakup or divesture of Bell operating companies.

Let's do something for our teenagers, for our communities, for our city, for ourselves.

I'm very much on with wind data accessibility, these days, on nuclear power, in touch with the nuclear regulator on several issues.of nuclear wastes etc.

Regards,

Haroon Rasheed
Interconnect Partners

KESC Karachi Electric Supply Corporation

People of Pakistan have seen a new Telecom World in Pakistan, The same people who used to wait for 20 years for a phone connection, now have 3 GSM Chips in there pockets.

PTCL which used to charge 120 rs a min to call the US now offers the same for 1 rupee a min.

Pakistan now has the CHEAPST Cell phone service, in compare to ANYWHERE in the world, and yet the phone companies still make A LOT of money.

Today I saw a program on AAj TV About the Electricity problems of Karachi, and I do not know why no one has suggested to request the Govt to step in and form a new Body to GOVERN The electricity and allocate private companies to come in and become the power providers just like they did for phone service.

The Chairman of WAPDA according to this program says that there will be no power for the cities like Karachi for the next 7 years.

I have 2 small suggestions:

1. What My Suggestion is that Pakistan Govt can issue the licenses for 10 nation wide and 100+ local companies to privately provide power to the consumer.

This can be done in multiple phases, and a Urgent license can be issued instantly, and then a good policy can be made about the power policy and announced next year.

2. The Govt should also remove any and all taxes and duties on import of alternate energy tools for consumers, like a 5kva wind generator from China now costs only 4000$ (I have already ordered mine) which will not create pollution and nor will cost the consumer any money in future , and will only be used by the consumer to have power, thus generating more productivity for himself and others around him.

5 out of 5 licenses should be awarded to international companies and 5 to local companies, so that we can benefit from both national and international experiences.

I think that since this problem is in majority in Karachi, MQM should take this seriously and have this done really quickly by the President or the national assembly.

How will this actually work:

In the telecom world a very simple example is of DSL service, PTCL gets money on every connection that runs via the wire of PTCL by say multinet and multinet can still compete based on the quality of service with PTCL and give better service to consumers on the same wire.

The same Copper wire of KESC can be used by the private company and they can pay a fee to KESC for using there wire, unless they can provide there own wire to the consumer.

The Private Power concept is not something new, and is done at this time in United Kingdom and in the United States.

I request you to forward these 2 small suggestions to those who actually matter, and who can get this done for us.

Rehan

Complete listing of rate centers/NPA-NXXs

I was surfing to find out best web site which can guide me for complete list of Npa-Nxx offered by different carriers and found out http://www.localcallingguide.com/

Regards,

Muneeb

Call Forwarding Management Solution / DID Management System

Introducing Call Forwarding Management Solution or DID Sales Management
Solution. (www.supertec.com/cfms)

This is a complete hosted solution which you can use to start your own DID
number retailing business.

It provides you every thing you can think of that you will or may need to
do the DID number business, and even more.

It is the essence of all our experience of doing the DID forwarding
business for the last 6 years.

Explore the options we are offering to start your own business.

You will have your own Domain and Brand Name and our name will not be
visible anywhere.

You do not have to invest in the DID Inventory and stock
No Servers Needed
NO NOC Needed
No Software or Hardware needed.

Every thing you need will be provided by us to you.

The one time Setup Fee starts at 999$ only. and then just 99 Cents Per DID
number for
(Limited time price for first 50 customers)

Billing
CRM
Accounting
Customer Login web Portal
Reseller Portal
Customer Service People Login Portal
Ticketing System
Integration with DIDx.net
Integration with Paypal
Integration with Carrierx.us

Check out the working demo’s on
Virtualphoneline.com
Comm4us.com
SuperPhoneWireless.com
Phone2net.com
PakistanTel.net
PakistanFax.com
Groovytel.com
SuperFax.com

Don't Wait, Email us today for an appointment for your own personalized tour of the software, that can give you the edge on others.

Know Your Food

Apples: Protects your heart, prevents constipation, blocks diarrhea, improves lung capacity and cushion joints.

Apricots: Combats cancer, controls blood pressure, improves eyesight, shields against Alzheimer's and slow aging process

Avocados: Battles diabetes, lowers cholesterol, helps stop strokes, controls blood pressure and smooths skin

Bananas: Protects your heart, quiets a cough, strengthens bones, controls blood pressure and block diarrhea.

Beans: Prevent constipation, helps hemorrhoids, lowers cholesterol, combats cancer and stabilizes blood sugar.

Beets: Controls blood pressure. combats cancer, strengthens bones, protect your heart and aids weight loss.

Blueberries: Combats cancer, protects your heart, stabilizes blood sugar, boosts memory and prevent constipation

Broccoli: Strengthens bones, saves eyesight, combats cancer, protects your heart and controls blood pressure.

Cabbage: Combats cancer, prevents constipation, promotes weight loss, protects your heart and helps hemorrhoids.

Cantaloupe: Saves eyesight, controls blood pressure, lowers cholesterol, combats cancer and supports the immune system.

Carrots: Protects eyesight, protects your heart, prevents constipation, combats cancer and promotes weight loss

Cauliflower: Protects against Prostate cancer, combat breast cancer, strengthens bones, banishes bruises and guards against heart disease.

Cherries: Protects your heart, combats cancer, ends insomnia, slows again.

Chestnuts: Promotes weight loss, protects your heart, lowers cholesterol, combats cancer and controls blood pressure.

Chili Peppers: Aids digestion, soothes sore throat, clears sinuses, combats cancer and boosts immune system.

LinkSys Pap2 and Virtualphoneline.com

You can use any DID number from virtualphoneline.com with your Linksys Pap2

Device:

* Get a sip address for your pap2 from websites such as www.fwdpulver.com,

www.gizmoproject.com

* Once you have an account from them, configure their account with your

LinkSys pap2.

Pick up phone on PAP2 dial **** to login. Dial 110# for the IP address.

Once you have the ip address, type it on your browser and open. It will

going to ask you the admin level user name and password.

Once you are done with the password thing, go to line / user 1 and your

Display name in Display name section

Write your user name in user name section

Authorization id

Proxy = proxy01.sipphone.com

submit

Now Pap2 should be configure with the gizmo account.

You can check if it is configure or not by picking up the handset of the

phone to see if you can hear the tone or not.

Now login in your virtualphoneline.com account.

Click on My numbers and then click on change ring to number button.

Click on Sip tab and write your sip address as provided by sip phone (e.g)

justmuneeb(User id)@proxy01.sipphone.com or (171xxxxx@proxy01.sipphone.com)

and the number will be forwarded to your Linksys.

Regards,

Muneeb Iqbal

The Power of DIDx

This logo represents the power which DIDx has.

DIDx can turn your company from small service provider to a huge huge service provider.

The strength of any service provider in voip world is the coverage that service provider have. DIDx having coverage in more then 55 countries in the world.

DIDx is currently having more then +5500 members in the exchange and growing ...

DIDx will allow you to show the numbering database of DIDx on your web site through the API service.

The APi service is free of cost and the details can be checked out on http://www.didx.net/api and http://www.didx.net/php

Kaanza Group and Muneeb from DIDx

The Kaanza.com Team on DIDx Booth

Karachi Sales Team

So here you go 3 Super Stars of Super Technologies.. The Karachi sales team.

Indian DID Numbers

DIDx now offering Indian DID numbers on the exchange.

User can purchase those numbers and can terminate them on their sip or IAX.

Customers can now purchase Mumbai and Hyderabad numbers from DIDx

WOW!

Interesting FACTS

A zebra is white with black stripes.

All the planets in our solar system rotate anticlockwise, except Venus. It is the only planet that rotates clockwise.

Hummingbirds are the only animal that can also fly backwards.

Insects do not make noises with their voices. The noise of bees, mosquitoes and other buzzing insects is caused by rapidly moving their wings.

The cockroach is the fastest animal on 6 legs covering a meter a second.

The word "listen " contains the same letters as the word "silent".

The only 2 animals that can see behind itself without turning it's head are the rabbit and the parrot.

A 'jiffy' is an actual unit of time for 1/100th of a second.

India invented the Number System . Zero was invented by Aryabhatta.

The whip makes a cracking sound because its tip moves faster than the speed of sound.

A hippopotamus can run faster than a man.

India never invaded any country in her last 10000 years of history.

'Hippopotomonstroses quippedaliophobi a' is the fear of long words.
Didaskaleinophobia is the fear of going to school.

Phobatrivaphobia is a fear of trivia about phobias !!

It is impossible to lick your elbow. ( We know you gonna try this !!! )

A snail can sleep for 3 years. ( wow, lucky chap he ? )

The names of the continents all end with the same letter with which they start

In 1883 the explosion of the volcano Krakatoa put so much dust into the earth's atmosphere that sunsets appeared green and the moon appeared blue around the world for almost two years.

"Almost" is the longest word in the English language with all the letters in alphabetical order.

Twenty-Four- Karat Gold is not pure gold since there is a small amount of copper in it. Absolutely pure gold is so soft that it can be molded with the hands.

Electricity doesn't move through a wire but through a field around the wire.

Do you know the names of the three wise monkeys? They are: Mizaru (See no evil), Mikazaru (Hear no evil), and Mazaru (Say no evil ).

55 per cent of people yawn within 5 minutes of seeing someone else yawn. Reading about yawning makes most people yawn.

Excel Tips / Help with Excel / Excel Help

CTRL combination shortcut keys

Key Description

CTRL+( Unhides any hidden rows within the selection.

CTRL+) Unhides any hidden columns within the selection.

CTRL+& Applies the outline border to the selected cells.

CTRL+_ Removes the outline border from the selected cells.

CTRL+~ Applies the General number format.

CTRL+$ Applies the Currency format with two decimal places (negative

numbers in parentheses).

CTRL+% Applies the Percentage format with no decimal places.

CTRL+^ Applies the Exponential number format with two decimal places.

CTRL+# Applies the Date format with the day, month, and year.

CTRL+@ Applies the Time format with the hour and minute, and AM or PM.

CTRL+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

CTRL+- Displays the Delete dialog box to delete the selected cells.

CTRL+* Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).

In a PivotTable, it selects the entire PivotTable report.

CTRL+: Enters the current time.

CTRL+; Enters the current date.

CTRL+` Alternates between displaying cell values and displaying formulas in the worksheet.

CTRL+' Copies a formula from the cell above the active cell into the cell or the Formula Bar.

CTRL+" Copies the value from the cell above the active cell into the cell or the Formula Bar.

CTRL++ Displays the Insert dialog box to insert blank cells.

CTRL+1 Displays the Format Cells dialog box.

CTRL+2 Applies or removes bold formatting.

CTRL+3 Applies or removes italic formatting.

CTRL+4 Applies or removes underlining.

CTRL+5 Applies or removes strike through.

CTRL+6 Alternates between hiding objects, displaying objects, and displaying placeholders for objects.

CTRL+7 Displays or hides the Standard toolbar.

CTRL+8 Displays or hides the outline symbols.

CTRL+9 Hides the selected rows.

CTRL+0 Hides the selected columns.

CTRL+A Selects the entire worksheet.

When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.

CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.

CTRL+B Applies or removes bold formatting.

CTRL+C Copies the selected cells.

CTRL+C followed by another CTRL+C displays the Microsoft Office Clipboard.

CTRL+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.

CTRL+F Displays the Find dialog box.

SHIFT+F5 also displays this dialog box, while SHIFT+F4 repeats the last Find action.

CTRL+G Displays the Go To dialog box.

F5 also displays this dialog box.

CTRL+H Displays the Find and Replace dialog box.

CTRL+I Applies or removes italic formatting.

CTRL+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.

CTRL+L Displays the Create List dialog box.

CTRL+N Creates a new, blank file.

CTRL+O Displays the Open dialog box to open or find a file.

CTRL+SHIFT+O selects all cells that contain comments.

CTRL+P Displays the Print dialog box.

CTRL+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.

CTRL+S Saves the active file with its current file name, location, and file format.

CTRL+U Applies or removes underlining.

CTRL+V Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.

CTRL+W Closes the selected workbook window.

CTRL+X Cuts the selected cells.

CTRL+Y Repeats the last command or action, if possible.

CTRL+Z Uses the Undo command to reverse the last command or to delete

the last entry you typed.

CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the

last automatic correction when AutoCorrect Smart Tags are displayed.

Function keys

F1 Displays the Help task pane.

CTRL+F1 closes and reopens the current task pane.

ALT+F1 creates a chart of the data in the current range.

ALT+SHIFT+F1 inserts a new worksheet.

F2 Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula

Bar when editing in a cell is turned off.

SHIFT+F2 edits a cell comment.

F3 Pastes a defined name into a formula.

SHIFT+F3 displays the Insert Function dialog box.

F4 Repeats the last command or action, if possible.

CTRL+F4 closes the selected workbook window.

F5 Displays the Go To dialog box.

CTRL+F5 restores the window size of the selected workbook window.

F6 Switches to the next pane in a worksheet that has been split (Window menu, Split command).

SHIFT+F6 switches to the previous pane in a worksheet that has been split.

CTRL+F6 switches to the next workbook window when more than one workbook window is open.

F7 Displays the Spelling dialog box to check spelling in the active worksheet or selected range.

CTRL+F7 performs the Move command on the workbook window when it is not

maximized. Use the arrow keys to move the window, and when finished press ESC.

F8 Turns extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the selection.

SHIFT+F8 enables you to add a non-adjacent cell or range to a selection of cells by using the arrow keys.

CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.

ALT+F8 displays the Macro dialog box to run, edit, or delete a macro.
F9 Calculates all worksheets in all open workbooks.

F9 followed by ENTER (or followed by CTRL+SHIFT+ENTER for array formulas) calculates the selected a portion of a formula and replaces the selected portion with the calculated value.

SHIFT+F9 calculates the active worksheet.

CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless

of whether they have changed since the last calculation.

CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.

CTRL+F9 minimizes a workbook window to an icon.

F10 Selects the menu bar or closes an open menu and submenu at the same time.

SHIFT+F10 displays the shortcut menu for a selected item.

ALT+SHIFT+F10 displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message.

CTRL+F10 maximizes or restores the selected workbook window.

F11 Creates a chart of the data in the current range.

SHIFT+F11 inserts a new worksheet.

ALT+F11 opens the Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).

ALT+SHIFT+F11 opens the Microsoft Script Editor, where you can add text, edit HTML tags, and modify any script code.

F12 Displays the Save As dialog box.

Other useful shortcut keys

ARROW KEYS Move one cell up, down, left, or right in a worksheet.

CTRL+ARROW KEY moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) in a worksheet.

SHIFT+ARROW KEY extends the selection of cells by one cell.

CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell.

LEFT ARROW or RIGHT ARROW selects the menu to the left or right when a menu is visible. When a submenu is open, these arrow keys switch

between the main menu and the submenu.

DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open.

In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options.

ALT+DOWN ARROW opens a selected drop-down list.

BACKSPACE Deletes one character to the left in the Formula Bar.

Also clears the content of the active cell.

DELETE Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.

In cell editing mode, it deletes the character to the right of the insertion point.

END Moves to the cell in the lower-right corner of the window when
SCROLL LOCK is turned on.

Also selects the last command on the menu when a menu or submenu is visible.

CTRL+END moves to the last cell on a worksheet, in the lowest used row of the rightmost used column.

CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet (lower-right corner).

ENTER Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default).

In a data form, it moves to the first field in the next record. Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command. In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the OK button).

ALT+ENTER starts a new line in the same cell.

CTRL+ENTER fills the selected cell range with the current entry.

SHIFT+ENTER completes a cell entry and selects the cell above.

ESC Cancels an entry in the cell or Formula Bar.

It also closes an open menu or submenu, dialog box, or message window.

HOME Moves to the beginning of a row in a worksheet.

Moves to the cell in the upper-left corner of the window when SCROLL

LOCK is turned on.

Selects the first command on the menu when a menu or submenu is visible.

CTRL+HOME moves to the beginning of a worksheet.

CTRL+SHIFT+HOME extends the selection of cells to the beginning of the worksheet.

PAGE DOWN Moves one screen down in a worksheet.

ALT+PAGE DOWN moves one screen to the right in a worksheet.

CTRL+PAGE DOWN moves to the next sheet in a workbook.

CTRL+SHIFT+PAGE DOWN selects the current and next sheet in a workbook.

PAGE UP Moves one screen up in a worksheet.

ALT+PAGE UP moves one screen to the left in a worksheet.

CTRL+PAGE UP moves to the previous sheet in a workbook.

CTRL+SHIFT+PAGE UP selects the current and previous sheet in a workbook.

SPACEBAR In a dialog box, performs the action for the selected button,

or selects or clears a check box.

CTRL+SPACEBAR selects an entire column in a worksheet.

SHIFT+SPACEBAR selects an entire row in a worksheet.

CTRL+SHIFT+SPACEBAR selects all objects on a worksheet when an object is selected.

ALT+SPACEBAR displays the Control menu for the Excel window.

TAB Moves one cell to the right in a worksheet.

Moves between unlocked cells in a protected worksheet.

Moves to the next option or option group in a dialog box.

SHIFT+TAB moves to the previous cell in a worksheet or the previous option in a dialog box.

CTRL+TAB switches to the next tab in dialog box.

CTRL+SHIFT+TAB switches to the previous tab in a dialog box.


source: Friend's email