Shortcut Key Ctrl With Excel.

                                                       Ctrl With Excel......

 Shortcut Keys                                        Description

• Ctrl + A                      :- Select all contents of the worksheet.
• Ctrl + B                      :- Bold highlighted selection.
• Ctrl + C                      :- Copy select cell.
• Ctrl + D                      :- Auto copy & past in upper cell.
• Ctrl + F                       :- Open the "find" window.
• Ctrl + G                      :- Open the "Go to" window.
• Ctrl + H                      :- Open the "replace"window.
• Ctrl + I                        :- Italic highlighted selection.
• Ctrl + K                      :- Insert link.
• Ctrl + L                       :- Create table.
• Ctrl + N                      :- Open new workbook.
• Ctrl + O                      :- Open your save history.
• Ctrl + P                       :- Bring up the pint dialog box to begin the printing process.
• Ctrl + Q                      :- Quick analysis.
• Ctrl + R                      :- Auto copy & past in left cell.
• Ctrl + S                       :- Save the open worksheet.
• Ctrl + U                      :- Underline highlighted selection.
• Ctrl + V                      :- Paste copied cell.
• Ctrl + X                      :- Cut select cell.
• Ctrl + Y                      :- Redo last action.
• Ctrl + Z                       :- Undo last action.
• Ctrl + ;                        :- Enter the current date.
• Ctrl + Shift + ;            :- Enter the current time.
• Ctrl + Shift + =           :- Insert a new column or row.
• Ctrl + Shift + 1           :- Format number in comma format.
• Ctrl + Shift + 2           :- Format number in time format.
• Ctrl + Shift + 3           :- Format number in date format.
• Ctrl + Shift + 4           :- Format number in currency format.
• Ctrl + Shift + 5           :- Format number in percentage format.
• Ctrl + Shift + 6           :- Format number in scientific format.
• Ctrl + F3                     :- Open excel name manager.
• Ctrl + F6                     :- Switch between workbooks or windows.
• Ctrl + F9                     :- Minimize current window.
• Ctrl + F10                   :- Maximize currently selected window.
• Ctrl + Page up            :- Move between work sheets in the same document.
• Ctrl + Page down       :- Move between work sheets in the same document.
• Ctrl + Tab                   :- Move between two or more open excel file.
• Ctrl + Space                :- Select entire column.
• Ctrl + Home               :- Move to cell A1.
• Ctrl + Arrow Key       :- Move to next section of text.
• Ctrl + -                        :- Delete the selected column or row.
• Ctrl + +                       :- Add the selected column or row.
• Ctrl + ~                       :- Switch between showing Excel formulas or their values in cells.

    

Shortcut Keys with Alt.

                                                            ALT With......



Shortcut Keys                                      Description

• Alt + F                :- File menu option in current program.
• Alt + E                :- Edit options in current program.
• Alt + Tab            :- Switch between open program.
• Alt + F4              :- Close the active program.
• 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.
• Alt + Shift + F1  :- Insert new worksheet.
• Alt + =                :- Create a formula to sum all of the above cell.

How to change screen saver in windows 7

Do you want to change your screen saver....?It is very easy process.Follow as below steps.

Step 1.

         First right click on your desktop.Then go to Personalization.See below screen shot.

Step 2.

          Now you've seen "Screen saver" button under the window.Click here.

 

                                 

 

Step 3.

          Then select left side button.See below.

                                          Now you change yourself & preview.But if you want to add 3D Text,select the this button.Then click setting button.

Step 4.

         Now you can type word yourself.Then adjust the setting.

How to change power action button in windows 7

Want you change power button change windows 7.....?It is very easy.Follow below these step.....

Step 1

          First right click the start button.Then you can see below window.

Step 2

          Then select start manu button.

 

 

Step 3
  
         Now select this button(red cruve) & you can change youself.

How to change mouse pointer in windows 07

step :- 1

           go to control panel.

step :- 2

           select view by "Category".



   

 

 

step :- 3
 

           select "Hardware and Sound".

 

 step :- 4

 

           Click "mouse" button.

step :- 5

           Click "point" button.

          

 

 

 

 

       Now you can change yourself.Then apply & ok.

Windows 7 Disk Cleanup

                                                             

1.First You Clik "Home" Tab.
2.Then Click Search Bar & Type "disk cleanup".
3.You Can See Select disk cleanup.
4.Then Double Click Here.
5.Now You Can See Below Picture.

6. Click Ok Button.

7.Click Ok & Permenantly Delete.