Useful Microsoft Excel keyboard shortcut..!!!

Hi All,

Today every professional person aware that how use Microsoft Excel for work in office.
So with using keyboard shortcut we can finish the work more speedy. So that here I am provide you the all keyboard shortcut used for Microsoft excel.

• CTRL+A Selects the entire worksheet.
• 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+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+PgUp        Switches between worksheet tabs, from left-to-right.
• CTRL+PgDn         Switches between worksheet tabs, from right-to-left.
• CTRL+SHIFT+( Unhides any hidden rows within the selection.
• CTRL+SHIFT+& Applies the outline border to the selected cells.
• CTRL+SHIFT_ Removes the outline border from the selected cells.
• CTRL+SHIFT+~ Applies the General number format.
• CTRL+SHIFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses).
• CTRL+SHIFT+% Applies the Percentage format with no decimal places.
• CTRL+SHIFT+^ Applies the Scientific number format with two decimal places.
• CTRL+SHIFT+# Applies the Date format with the day, month, and year.
• CTRL+SHIFT+@ Applies the Time format with the hour and minute, and AM or PM.
• CTRL+SHIFT+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
• CTRL+SHIFT+* 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+SHIFT+: Enters the current time.
• CTRL+SHIFT+" Copies the value from the cell above the active cell into the cell or the Formula Bar.

• CTRL+SHIFT+Plus (+) Displays the Insert dialog box to insert blank cells.
• CTRL+Minus (-) Displays the Delete dialog box to delete the selected cells.
• 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+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 strikethrough.
• CTRL+6 Alternates between hiding and displaying objects.
• CTRL+8 Displays or hides the outline symbols.
• CTRL+9 Hides the selected rows.
• CTRL+0 Hides the selected columns.
• CTRL+F Displays the Find and Replace dialog box, with the Find tab selected.
• SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action.
• CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.
• CTRL+G Displays the Go To dialog box.
• F5 also displays this dialog box.
• CTRL+H Displays the Find and Replace dialog box, with the Replace tab selected.
• 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 Table dialog box.
• CTRL+N Creates a new, blank workbook.
• 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 tab in Microsoft Office Backstage view.
• CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected.
• 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+T Displays the Create Table dialog box.
• CTRL+U Applies or removes underlining.
• CTRL+SHIFT+U switches between expanding and collapsing of the formula bar.
• CTRL+V Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.
• CTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
• 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 that you typed.

Read more »

All useful Microsoft word keyboard shortcut..!!!

Hi All,


Today most professional person use Microsoft office for work in office.
With using keyboard we can finish the work more speedy. So that here I am provide you the all keyboard shortcut used for Microsoft word.


 Command Name Keyboard shortcuts
------------------------------------------------- All Caps CTRL+SHIFT+A Annotation ALT+CTRL+M App Maximize ALT+F10 App Restore ALT+F5 Apply Heading1 ALT+CTRL+1 Apply Heading2 ALT+CTRL+2 Apply Heading3 ALT+CTRL+3 Apply List Bullet CTRL+SHIFT+L Auto Format ALT+CTRL+K Auto Text F3 or ALT+CTRL+V Bold CTRL+B or CTRL+SHIFT+B Bookmark CTRL+SHIFT+F5 Browse Next CTRL+PAGE DOWN Browse Previous CTRL+PAGE UP Browse Sel ALT+CTRL+HOME Cancel ESC Center Para CTRL+E Change Case SHIFT+F3 Char Left LEFT Char Left Extend SHIFT+LEFT Char Right RIGHT Char Right Extend SHIFT+RIGHT Clear DELETE Close or Exit ALT+F4 Close Pane ALT+SHIFT+C Column Break CTRL+SHIFT+ENTER Column Select CTRL+SHIFT+F8 Copy CTRL+C or CTRL+INSERT Copy Format CTRL+SHIFT+C Copy Text SHIFT+F2 Create Auto Text ALT+F3 Customize Add Menu ALT+CTRL+= Customize Keyboard ALT+CTRL+NUM + Customize Remove Menu ALT+CTRL+- Cut CTRL+X or SHIFT+DELETE Date Field ALT+SHIFT+D Delete Back Word CTRL+BACKSPACE Delete Word CTRL+DELETE Dictionary ALT+SHIFT+F7 Do Field Click ALT+SHIFT+F9 Doc Close CTRL+W or CTRL+F4 Doc Maximize CTRL+F10 Doc Move CTRL+F7 Doc Restore CTRL+F5 Doc Size CTRL+F8 Doc Split ALT+CTRL+S Double Underline CTRL+SHIFT+D End of Column ALT+PAGE DOWN End of Column ALT+SHIFT+PAGE DOWN End of Doc Extend CTRL+SHIFT+END End of Document CTRL+END End of Line END End of Line Extend SHIFT+END End of Row ALT+END End of Row ALT+SHIFT+END End of Window ALT+CTRL+PAGE DOWN End of Window Extend ALT+CTRL+SHIFT+PAGE DOWN Endnote Now ALT+CTRL+D Extend Selection F8 Field Chars CTRL+F9 Field Codes ALT+F9 Find CTRL+F Font CTRL+D or CTRL+SHIFT+F Font Size Select CTRL+SHIFT+P Footnote Now ALT+CTRL+F Go Back SHIFT+F5 or ALT+CTRL+Z Go To CTRL+G or F5 Grow Font CTRL+SHIFT+. Grow Font One Point CTRL+] Hanging Indent CTRL+T Header Footer Link ALT+SHIFT+R Help F1 Hidden CTRL+SHIFT+H Hyperlink CTRL+K Indent CTRL+M Italic CTRL+I or CTRL+SHIFT+I Justify Para CTRL+J Left Para CTRL+L Line Down DOWN Line Down Extend SHIFT+DOWN Line Up UP Line Up Extend SHIFT+UP List Num Field ALT+CTRL+L Lock Fields CTRL+3 or CTRL+F11 Macro ALT+F8 Mail Merge Check ALT+SHIFT+K Mail Merge Edit Data Source ALT+SHIFT+E Mail Merge to Doc ALT+SHIFT+N Mail Merge to Printer ALT+SHIFT+M Mark Citation ALT+SHIFT+I Mark Index Entry ALT+SHIFT+X Mark Table of Contents Entry ALT+SHIFT+O Menu Mode F10 Merge Field ALT+SHIFT+F Microsoft Script Editor ALT+SHIFT+F11 Microsoft System Info ALT+CTRL+F1 Move Text F2 New CTRL+N Next Cell TAB Next Field F11 or ALT+F1 Next Misspelling ALT+F7 Next Object ALT+DOWN Next Window CTRL+F6 or ALT+F6 Normal ALT+CTRL+N Normal Style CTRL+SHIFT+N or ALT+SHIFT+CLEAR (NUM 5) Open CTRL+O or CTRL+F12 or ALT+CTRL+F2 Open or Close Up Para CTRL+0 Other Pane F6 or SHIFT+F6 Outline ALT+CTRL+O Outline Collapse ALT+SHIFT+- or ALT+SHIFT+NUM - Outline Demote ALT+SHIFT+RIGHT Outline Expand ALT+SHIFT+= Outline Expand ALT+SHIFT+NUM + Outline Move Down ALT+SHIFT+DOWN Outline Move Up ALT+SHIFT+UP Outline Promote ALT+SHIFT+LEFT Outline Show First Line ALT+SHIFT+L Overtype INSERT Page ALT+CTRL+P Page Break CTRL+ENTER Page Down PAGE DOWN Page Down Extend SHIFT+PAGE DOWN Page Field ALT+SHIFT+P Page Up PAGE UP Page Up Extend SHIFT+PAGE UP Para Down CTRL+DOWN Para Down Extend CTRL+SHIFT+DOWN Para Up CTRL+UP Para Up Extend CTRL+SHIFT+UP Paste CTRL+V or SHIFT+INSERT Paste Format CTRL+SHIFT+V Prev Cell SHIFT+TAB Prev Field SHIFT+F11 or ALT+SHIFT+F1 Prev Object ALT+UP Prev Window CTRL+SHIFT+F6 or ALT+SHIFT+F6 Print CTRL+P or CTRL+SHIFT+F12 Print Preview CTRL+F2 or ALT+CTRL+I Proofing F7 Redo ALT+SHIFT+BACKSPACE Redo or Repeat CTRL+Y or F4 or ALT+ENTER Repeat Find SHIFT+F4 or ALT+CTRL+Y Replace CTRL+H Reset Char CTRL+SPACE or CTRL+SHIFT+Z Reset Para CTRL+Q Revision Marks Toggle CTRL+SHIFT+E Right Para CTRL+R Save CTRL+S or SHIFT+F12 or ALT+SHIFT+F2 Save As F12 Select All CTRL+A or CTRL+CLEAR (NUM 5) or CTRL+NUM 5 Select Table ALT+CLEAR (NUM 5) Show All CTRL+SHIFT+8 Show All Headings ALT+SHIFT+A Show Heading1 ALT+SHIFT+1 Show Heading2 ALT+SHIFT+2 Show Heading3 ALT+SHIFT+3 Show Heading4 ALT+SHIFT+4 Show Heading5 ALT+SHIFT+5 Show Heading6 ALT+SHIFT+6 Show Heading7 ALT+SHIFT+7 Show Heading8 ALT+SHIFT+8 Show Heading9 ALT+SHIFT+9 Shrink Font CTRL+SHIFT+, Shrink Font One Point CTRL+[ Small Caps CTRL+SHIFT+K Space Para1 CTRL+1 Space Para15 CTRL+5 Space Para2 CTRL+2 Spike CTRL+SHIFT+F3 or CTRL+F3 Start of Column ALT+PAGE UP Start of Column ALT+SHIFT+PAGE UP Start of Doc Extend CTRL+SHIFT+HOME Start of Document CTRL+HOME Start of Line HOME Start of Line Extend SHIFT+HOME Start of Row ALT+HOME Start of Row ALT+SHIFT+HOME Start of Window ALT+CTRL+PAGE UP Start of Window Extend ALT+CTRL+SHIFT+PAGE UP Style CTRL+SHIFT+S Subscript CTRL+= Superscript CTRL+SHIFT+= Symbol Font CTRL+SHIFT+Q Thesaurus SHIFT+F7 Time Field ALT+SHIFT+T Toggle Field Display SHIFT+F9 Toggle Master Subdocs CTRL+\ Tool SHIFT+F1 Un Hang CTRL+SHIFT+T Un Indent CTRL+SHIFT+M Underline CTRL+U or CTRL+SHIFT+U Undo CTRL+Z or ALT+BACKSPACE Unlink Fields CTRL+6 or CTRL+SHIFT+F9 Unlock Fields CTRL+4 or CTRL+SHIFT+F11 Update Auto Format ALT+CTRL+U Update Fields F9 or ALT+SHIFT+U Update Source CTRL+SHIFT+F7 VBCode ALT+F11 Web Go Back ALT+LEFT Web Go Forward ALT+RIGHT Word Left CTRL+LEFT Word Left Extend CTRL+SHIFT+LEFT Word Right CTRL+RIGHT Word Right Extend CTRL+SHIFT+RIGHT Word Underline CTRL+SHIFT+ W

Read more »

Tricks to speed up Google chrome performance..!!!

Hi All,
Google chrome is widely used Internet browser these days.
As by changing some of its properties you can optimize its performance. Here are some very useful Google chrome tricks that will help you a lot.




1.Google process priority should be set to High:-
To implement this follow below steps
Go to Start->Run-> taskmgr then press enter.
Then in process tab find chrome.exe->right click on it->Set priority->High.
Press Ok and you have finish it.
See below screenshot o verify it.



2. Disable Google Chrome automatic updates.
This will stop the Google chrome update process "GoogleUpdater.exe" and let the browser work more lightly every time. It helps the browser start-up more quickly. It also save some CPU and RAM usages. We have discussed it here and showed how to disable it.


3. Enabling GPU acceleration and composting.
Now-a-days web pages are more and more graphically designed for the users. So the web browsers are implementing hardware acceleration technology for GPU. This will help the browser to accelerate the GPU (graphics processing unit) signals on pages. Go to browser address bar in Google Chrome and type "chrome://flags" and hit Enter. Enable both GPU composting on all pages and GPU accelerated SVG and CSS filters.



GPU acceleration and composting settings


4. Configuring Settings.
This part will show only those settings whose are important for the browser to get some extra speed. It is also a useful idea for slow internet connection.
Go to the wrench icon top-right corner and click on Settings. Expand the Show advanced settings from the bottom of this page.
Google Chrome Settings

     a. Sign in. Connect it if you really need to sync your bookmarks, extensions, themes etc. Otherwise remain it disconnected.

Sign in option to sync data
     b. Appearances. Un-tick on both Show home button and Always show bookmark.
Appearances Settings

     c. Privacy. Un-tick on Use a web service to help resolve navigation errors and Automatically send usage statistics and crash reports to Google.
Privacy settings

     d. Languages. Un-mark the offer to translate only if you don't use to read content in other languages without English.

Offer to Translate Languages
Read: How to Install English language in Windows 7
     e. HTTPS/SSL. No need to choose Check for server certificate revocation. Because certificate revocation is not needed normally.
HTPPS/SSL

5. Disable Developer mode.
If you aren't a developer then disable this mode by going wrench icon > Tools > Extensions > un-chek Developer mode.
Developer Mode



6. Clear Browsing Data.
There is nothing new to say that your browsing data will slow down the browser. So better is to practice clearing browsing data regularly. This option is available in wrench > Settings.

Clear all browsing data


After Implement these steps you will notice speed variation in performance of google chrome.


"Please share & comment if you like this post..!!!!"

Read more »

All Keyboard shortkey for Google Chrome..!!!

Hi All,


Here I am provide you All Keyboard short-key for Google Chrome.So you can do all task using Keyboard.
 

• CTRL + SHIFT + N : automatically opens up a Chrome ‘incognito’ window which allows you to surf on a PC without leaving behind any digital footprints.
• SHIFT + Escape: allows for fast access to Chrome’s task Manager utility that allows you to nix browser processes that have gone awry.
• CTRL + SHIFT + T: will open recently closed browser tabs.

Window And Tab Shortcuts:
Ctrl+N – Open a new window
Ctrl+Shift+N – Open a new window in incognito mode
Press Ctrl,and click a link – Open link in a new tab
Press Shift, and click a link – Open link in a new window
Alt+F4 - Close current window
Ctrl+T - Open a new tab
Ctrl+Shift+T – Reopen the last tab you’ve closed. Google Chrome remembers the last 10 tabs you’ve closed.
Drag link to tab – Open link in specified tab
Drag link to space between tabs – Open link in a new tab in the specified position on the tab strip
Ctrl+1 through Ctrl+8 – Switch to the tab at the specified position number. The number you press represents a position on the tab strip.
Ctrl+9 – Switch to the last tab
Ctrl+Tab or Ctrl+PgDown – Switch to the next tab
Ctrl+Shift+Tab or Ctrl+PgUp – Switch to the previous tab
Ctrl+W or Ctrl+F4 – Close current tab or pop-up
Alt+Home – Open your homepage
Ctrl+O, then select file – Open a file from your computer in Google Chrome


Shortcuts To Open Google Chrome Features:
Ctrl+B – Toggle bookmarks bar on and off
Ctrl+H – View the History page
Ctrl+J – View the Downloads page
Shift+Escape – View the Task manager


Webpage Shortcuts:
Ctrl+P – Print your current page
F5 – Reload current page
Esc – Stop page loading
Ctrl+F5 or Shift+F5 – Reload current page, ignoring cached content
Press Alt, and click a link – Download link
Ctrl+F – Open find-in-page box
Ctrl+G or F3 – Find next match for your input in the find-in-page box
Ctrl+Shift+G or Shift+F3 – Find previous match for your input in the find-in-page box
Ctrl+U – View source
Drag link to bookmarks bar – Bookmark the link
Ctrl+D – Bookmark your current webpage
Ctrl++ – Make text larger
Ctrl+- – Make text smaller
Ctrl+0 – Return to normal text size

Read more »