Google Find us on Google+ Computer Tips: Excel Tips

Friday, February 14, 2014

Excel Tips

                                    Changes in the spread sheet : Excel Work Book in production , at the same time we have to keep open several worksheet  use . In this model, each to worksheet switching window , under the mouse cursor into the tape to activate . It will be a little difficult for those who have the habit of using keybowrd . The shortcut is provided in Excel worksheet .  switch on the work sheet , Ctrl + F6 keys to press .
                     While pressing the keys, select Work pukkukal cares here in order to watch the tapes. Workbook opened for the work sheet, the fifth move, Ctrl + F6 keys that must be pressed for time.
                   Importent shortket ways: the application program, everyone can not be considered to be all-important. Others may simply not important to you. Ask them to change as well. Here are some of the more unusual and useful short cut key sets are here. Keep your stick can be used to print off the table.
 Control + "C":
 Copy Control + "X": Cut
 Control + "V": Paste
 F2: then press to edit the cell. (Easily editable message to Cell Reference the color set]
 F5: Go to
 F11: Instant Chart There
Shift + F3: Based Performance Wizard is available.
 Control + F3: name define.
 Control + "+": time option according to their cell, bed and Insert thrust line.
 Control + "": at the time of examination, wherein the cell, removing the bed and thrust line.
 Shift + Space: eriyavirk full bed set is then selected. Take care with what it perceives.
 Control + Space: The whole thrust  then selected columns. This is what the care should never.
 Control + "!" (or Control + Shift + "1"): number two decimal place format of the message
. Control + "$" (or Control + Shift + "4"): currency formet
 Control + "%" (or Control + Shift + "5"): Percentage format of the message.
 Control + "/" (or Control + Shift + "7"): Scientific as the format is.
 Control + "-" (or Control + Shift + "6"): The selacted small border around the set.


No comments:

Post a Comment