Shortcut Keys of MS Excel/ Microsoft Office tricks.

F2 : Edit the selected cell.
F5: Go to a specific cell .
F7: Spell check selected text and /or document.
F11: Create Chart
Ctrl+Shift+; : Enter the current time.
Ctrl+; :Enter the current date.
Alt+shift+F1: Insert new worksheet.
Shift+F3: Open the excel formula window.
Shift+F5: Bring up search box.
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+5: Strike through highlighted selection.
Ctrl+P: Bring up the print dialogue box to bring printing.
Ctrl+Z: Undo last action.
Ctrl+F9: Minimize current window.
Ctrl+F10: Maximize current window.
Ctrl+F6: Switch between open work books/windows.
Ctrl+Page down: Move between Excel worksheets in the same excel document.
Ctrl+Tab: move between two or more excel files.
Alt+=: Create a formula to sum all of the above cells.
Ctrl+'  : Insert the value of the above cell into the cell currently selected.
Ctrl+shift+! : Format number in comma format.
Ctrl+Shift+$ : Format number in currency format.
Ctrl+Shift+# : Format number in date format.
Crtl+Shift+% : Format number in percentage format.
Crtl+Shift+^ : Format number in scientific format.
Crtl+Shift+@ : Format number in time format.
Crtr+Arrow key : move to next section.
Ctrl+Space: Select the entire colum.
Shift +Space : Select entire row.

Read More

Review: Microsoft Surface2 and Surface pro 2 launch and Price !! 2013

Microsoft as come up with two new launch on its surface tablets its Microsoft surface 2 and surface pro 2!!
it has come up with new latest and best updates to overcome the last defaults  with improved processing power and battery life. It is compact with windows 8.1 system, the popular Outlook program and a whopping 100,000 applications, up from the 10,000 in the previous version.Surface 2 is available in 32GB and 64GB configuration, where as  Surface pro is 64GB and 128GB configurations with 4 GB of RAM and 256GB and 512GB

Features of Surface 2:

It is best for personal usage  and offers gaming ans entertainment.
It has NVIDIA Tegra 4 processor, making apps run faster and smoother and increasing battery life to up to 10 hours for video playback.
It has USB 3.0 for up to four times faster file transfers.
It has 10.6" Clear-type Full HD display .
It has 3.5-megapixel front camera and 5-megapixel rear camera.

 Price tag:

Price of Surface 2 will start at $449 .



Surface Pro 2:

It the one of the best tablet which you can replace it through your laptop  , it allows you to run  all windows software including MS Office suite, you can also  access apps from windows store, it is compact with 4th generation Intel Core i5 processor . it helps to perform your task fast and  as a 75% longer battery life  than the earlier one.

Price tag !

 It's price is around at $899 !
 
Note: It is still not cleared that when it'll be launched on India!!!

Read More

Microsoft Said:Hack Us And Get $100,000 Award

Friend's i think you all know that Window 8.1 which is the enhanced version of Window 8 is launched on 27 June 2013.And Window 8.1 is coming with some great features which is not in the Window 8.Like start button in homepage etc.

When an operating system is launched,The company first check its vulnerabilities.

Now Microsoft wants white hats and blue hats to find out the vulnerabilities. Qualifying submissions and accompanying defensive ideas will also grant the blue hat bonus worth up-to 50,000 $ also those who will point out the critical vulnerabilities in Microsoft's Internet Explorer present in Windows 8.1 update will be awarded 11,000 $ .

So this is the great announcement i see in the official blog of Microsoft.

SEE ALSO:

• Window 8 Enterprise Evaluation Free Download And guide To Install
• Window 8 Shortcut Keys

Read More

Microsoft has unveiled Surface tablet

Hello friends,

Microsoft has unveiled Surface, a tablet computer to compete with Apple’s iPad.

CEO Steve Ballmer was on hand to announce the new tablet, calling it part of a “whole new family of devices” the company is developing.

One version of the device, which won’t go on sale until sometime in the fall, is about 9.3 millimetres thick and works on the Windows RT operating system. It comes with a kickstand to hold it upright and a touch keyboard cover that snaps on using magnets. The device weighs under 680 grams and will cost about as much as other tablet computers. Its debut is set to coincide with the upcoming fall release of Microsoft’s much-anticipated Windows 8 operating system.

Steven Sinofsky, president of Microsoft’s Windows division, called the device a “tablet that’s a great PC PC that’s a great tablet.”

Features:

A slightly thicker version, less than 14 millimetres thick and under 910 grams, will work on Microsoft’s upcoming Windows 8 Pro operating system and cost as much as an Ultrabook, the company said. The pro version comes with a stylus that allows users to make handwritten notes on documents such as PDF files.

Each tablet comes with a keyboard cover that is just 3 millimetres thick. The kickstand for both tablets was just 0.7 millimetres thick, slimmer than a credit card.

Microsoft has been making software for tablets since 2002, when it shipped the Windows XP Tablet PC Edition. Many big PC makers produced tablets that ran the software, but they were never big sellers. The tablets were based on PC technology, and were heavy, with short battery lives.

Microsoft didn’t say how long the Surface would last on battery power.

Read More