Difference between revisions of "User:Wikgdqywt"

From Irish WhiteWater Kayaking and Canoeing Wiki
Jump to navigationJump to search
Line 90: Line 90:
  
 
&nbsp;perhaps you have  accomplished in Excel  over  hundreds of  financial statements  ,you may have  to use Excel to realize  the complicated calculation of  thousands of times  ,maybe you think  Excel is  just so so,  even  without new idea  .<br>But  we  repeated  the  handy  method of using  only  Excel all  the one percent skills  .The topic from  a Excel some  little-known techniques  of  about Excel  ,enjoy the  different customs  .&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;one  ,for  different types of data  with different colors  displayed on the  pay table  ,if you want  greater than or equal to 2000  yuantotal wages  to  red  display  ,greater than or equal to  1500 yuanof the  total wages  for the  shows  ,below 1000 yuan  to  total wages  Brown  display  ,other  black  display  ,so we can  set  .<br>1 open the  payroll  workbook  ,select the  total wages  in the column  ,performing  format  conditional formatting  commands  ,open  conditional formatting  dialog box  .Click  the  drop-down button  second  to the right of the box  ,select the  greater than or equal to  option  ,at the back of the  box  2000input values.<br>Click the  format  open  button  ,the Format Cells  dialog box  ,the  font    is set to  red  .2  press the button  ,and modeled after the  above operations  for the other  conditions  (  greater than or equal to 1500  ,the font is  blue  ;less than 1000  ,the font is  Brown  )  .<br>The 3  set is complete,press the  OK  .Have a look  the payroll  ,salary amount  data  is it right?  According to your requirements  in different colors  out of  .&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;two  ,the classification of the establishment of  the drop-down list  we  often  filled  to enterprise  name  entered into the table  ,in order to keep the  name consistency  ,using the  data  function  to build a  classification of  filling  a  drop-down list  .<br>1  in the Sheet2 ,the  company name  by category  (  such as  industry  ,business  ,individual businesses    are input to  different columns  ,to establish a corporate  name database  .2  selectedA column  (  industry  of  the column  )  ,in the  name  column  ,enter  industry  character  ,press    confirm  .<br>According to  the above,  the B  ,C  ...  ...  The column  named  business  ,individual enterprises  ...  ...  The 3 switch to  Sheet1,  select  input  business  class  column  (  such as  C  )  ,performing  data  validity  open  command  ,data validity  dialog box  .<br>In the  Settings  tab,  click  allow    drop-down button  ,select  sequence  options  ,sources  in the following  box  ,enter  industry  ,business  ,individual enterprises  ...  ...  Sequence  (  between elements of the  English  commas  )  ,decided to quit  .<br>Then select the  required  input company name  column  (  such as  D  )  ,then open the  data  dialog box  ,select  sequence  option  in the  source  box  ,enter  the equation: =INDIRECT  (  C1  ),decided to quit  .<br>4  selectedC column  any cell  (such as C4  ),click  the  drop-down button  ,choose the corresponding  business  class  in  the cell  .And then select the  cell corresponding to the  D  column of cells  (  such as D4  ),click the drop-down  button  ,can from  the corresponding category of  enterprise name  list  to select the  name of the enterprise  in  the cell  .<br>Note:  later in  print statements  ,if  do not need to  print  category  column  ,the column  can be  selected  ,right click your mouse  ,select  hidden  option  ,the column is  hidden  .Three  ,establish a  common  document  menu  in the  menu bar  to build  a  common  document  menu  ,the commonly used  workbook  file  add to them,  at any time convenient call  .<br>1  empty space on the toolbarright-click  ,select  custom  options  ,custom  dialog box  open  .In  command    ,select  categories  below  the new  menu  item  ,then  command  below  the new  menu  drag  the menu bar  .<br>According to  change your selections  button  ,the  pop-up menu    box,  enter a name  (  such as  common  .)  .2  below  choose one  (  such as  insert  option)  ,on the right  order  the  choice of a  (  such as  hyperlinks  option)  ,drag it to the new  menu  (  commonly used  document  )  ,and modeled after the  above operations  performed on it  (  such as the  named  payroll  etc.<br>  )  ,the establishment of the first  workbook  file  list name  .Repeat the above operation,  more  add a few  document  list name  .3  selectedcommonly used  document  menu,  a menu item  (  such as  payroll    ,right mouse click  ,in  the pop-up menu  ,choose  assigned  hyperlinks  to  open  options  ,Hyperlink  dialog box  open  distribution  .<br>By pressing the      drop-down button  ,navigate to the  Workbook  (  such as  salary.Xls    folder  ,and select the  workbook  file  .Repeat the above operation,  the  menu item  and its  corresponding  workbook  document  links  up  .<br>In 4 after the  need to open the  common  document  menu in  a workbook  document,  as long as the  start  menu  ,click  commonly used  document  in which  the corresponding  option  .Note:  Although we will  hyperlinks  option  until the  common  document  menu,  but does not affect the  insert  menu  hyperlinks  menu item and the  common  Toolbar  insert hyperlink  button function  .<br>Four  ,making  symbol  toolbar  in  professional editing  form,  often  need to import some  special  symbols  ,in order to  facilitate the input,  we  can create a  belongs to own  symbol  toolbar  .<br>1  Tools >  macro  to  record new macro  command  ,open  record new macro  dialog box  ,enter the  name  such as  fuhao1  ??and  macro security  presence  personal macro Workbook  ,then  identify  start recording  .<br>Select the  recording  Toolbar  relative  button  ,then  will need  special symbol input  into a cell  ,and then click the  recording  of the  stop  on the toolbar  ,complete macro  recording  .According to  the above,  recorded  one one  other  special symbols in the  input  macro  .<br>2 open the  custom  dialog box  ,in the  Toolbar    ,click the  new  pop-up  new toolbar  dialog box  ,enter the name  --  symbol  ,are identified,  namely  in the work area  in  a tool bar  .Switch to  command    ,select  categories  below  macro  ,order  below  custom button  drag  symbol  bar  (  the number of  special symbols  on the drag  a  button  )  .<br>3  select one ofa  button  ,modeled as second  -  first  of them  named  .4  right-click anamed after the  button  ,in the ensuing  pop-up menu  ,choose  assign  option  ,open  assign  dialog box  ,select  the appropriate macro  (  such as fuhao1)  ,decided to quit  .<br>Repeat this  step of the operation  ,the button  and  the corresponding macro  link  up  .The closure of 5  custom  dialog box  ,later  can be used  as  ordinary  toolbar  ,the use of  symbol  toolbar  ,cell to cell  quickly enter  professional  symbols  .<br>In five  ,with  visual  manager  save multiple  print page  some  sheet  ,often need to  print wherein  different regions,  with  visual  manager  .  .1 open the  need to print a  sheet  ,with the mouse in  need not  print  row  (or column  )  marked on the  tractor  ,select them  and  right mouse click  ,in  the ensuing  shortcut menu,  choose the  option  hide  ,will not  need to print a  row  (  or column  )  to hide  .<br>2  view  view  manager  command  ,open the  visual  manager  dialog box  ,click  add  button  ,pop-up  add  view  dialog box  ,enter a name  (  such as  report  )  ,click  button  .3 will be  hidden rows  (  or  columns  )  is displayed  ,and  the operation is repeated,  adding  other  print  view  .<br>In 4 after the  need to print  a  form,  open  view  manager  ,select the  need to print a  form name  ,click the  show  ,the sheet  immediately  according to the  preset  interface  display,  simple setting  ,typesetting  ,press the  print  button  on the toolbar  ,all  on OK  .<br>Six  ,make  data  on-demand  sort  if you want the  staff  at the  Department  for sorting  ,these  departments  of  both  information  not  according to the phonetic  sequence  ,not  according to the  stroke order  ,how to do  ?Can use  custom sequence  to sort  .<br>1  format  options  command  ,open the    dialog box,  enter the  custom sequence  label  ,the  input sequence  below  the input sector  in  the sorted sequence  (such as  organ  ,fleet  ,a  workshop  ,two workshops  ,three  workshop    ,click  add  and  OK  button to exit  .<br>2  selecteddepartments  column  in any one  cell  ,performing  data  sort  command  ,open the  dialog box,  click  sorting  options  button  ,the pop-up  sort options  dialog box  ,click  the  drop-down button  ,select  just  custom  sequence  ,two press    button on the back,  all the data  in  requirements for a  sort  .<br>&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;seven  ,the  data is  completely hidden  portions of the sheet  cell content  does not want to let  visitors  access  ,had to  hide it  .<br>1  selectHide content  cell  (regional)  ,performing  format  cells  open  command  ,the Format Cells  dialog  in  ,digital  label  classification  below and  select  option  ,and then the right  below  type  enter  ;;;(  three  English  state  the  semicolon  )  .<br>2  thenswitched to  protect  tab,  select one of the  hidden  option  ,click  button to exit  .3  the implementation of the to  protect  to  protect sheet  open  command  ,the protecting sheet  dialog box  ,set the  password,  OK  .<br>After such  settings  ,the  cell content  is no longer  displayed  ,is to use  Excel  function also  cannot make its  appear  transparent  .Tip: in the  protection  label  ,please do not  remove  locked  in front of  the check box in the  V  ,this can prevent  others to delete  your  hidden  data  .<br>Eight  ,in the  English  input method  ,intelligent  appeared in  edited  form,  some  cells  to  input  English  ,some  cells  to  input  Chinese  ,repeatedly  switching input method  is  not convenient  ,why not  set up  ,lets the input method  of intelligent  adjustment  ?Select  input  Chinese  cell  area  ,implementation of the  data  effectiveness of  open  command  ,data validity  dialog box  ,switch to the  input  mode  label  ,according to the  mode    drop-down button  ,select  open  option,  OK  .<br>When  selected  to  input  Chinese  range  in any one  cell,  Chinese  IME  (  input method  in the list of  first  Chinese  input method  )  is automatically opened  ,when  other  cells,  Chinese  input method  automatically closes  .<br>Nine  ,make  automatic corrections  input  unified text  you  is it right?  Often  enter certain  fixed text  ,such as  newspaper  computer  and trouble  ?You  look down  .1  Tools >  AutoCorrect  open  command  ,automatic  correction  dialog box  .<br>2  replacement  in  the box below  to enter  PCW  (  or other  characters  ,PCW  with a lowercase  )  ,in the  substituted for  enter  below  newspaper  computer  ,then click  add  and  OK  .The 3  later if you need toinput  the  text  PCW  ,as long as the input  character  ?This can  not consider  PCW  size  ?,then  confirm  became  .<br>In  ten  ,a custom Excel  function Excel  although abundant  ,but did not  meet our  need  .We  can define  a function  ,to accomplish some  particular operations  .Below,  we will  from the definition of a  calculation of  trapezoid area  function  : 1  Tools >  macro  → VisualBasic  editor  menu  (  or  press the  shortcuts  )  ,open the Visual  Basic editor window  .<br>2  in the window,to perform  insert  module  menu command  ,insert a new module  -  module 1  .The 3  on the right side of thecode window  enter the following  code  :Function  V  (  a  ,B  ,H  )  V =  h*  (  a+b  )  /2End  Function 4  to close the window,a custom  function  .<br>After  using the built-in  function  like  using a custom  function  .Tip: use  the above  method to customize the  function usually  can only be  used in  the corresponding  workbook  .Eleven  ,the header  arranged under the  picture  for the sheet  to add background  ,is lined on  the  work  table  below  ,can be only the  lining  in the header  below  ?1format  sheet  and  background  open  command  ,sheet background  dialog box  ,select  as a background  picture,  press the  button  ,the picture  is lined in the  entire sheet  below  .<br>2  while holding down the Ctrl key,use the mouse  without  lining  picture cell  (  regional  )  drag  ,and  select the  cell  (  regional  )  .In 3  format  Toolbar  fill color  to the right of the  drop-down button  ,in  the subsequent  palette  ,select  white  .<br>After such  settings  ,leaving the  cells  lining  the  picture  below  ,the  selected cell  (  area  )  below  without  lining  pictures  (in fact,  is the picture  is  white  cover  )  .Tips  ?Lining in the  cell  below is  not  support printing  .<br>Twelve  ,use a hyphen  &amp  ;to  merge text  if we want  more  content is merged  into one column  ,do not need to use  function  ,a small  hyphen  &amp  ;you can use it  .(  this  assumes that the B  ,C  ,D  columns are merged  into one column  )  .<br>1  listed in the Dinserted behind the  two  column  (  E  ,F  )  ,then D1  cell of theinput  formula  :=B1&amp  ;C1&amp  ;D1  .2  selected againD1  cell,with  the fill handle  the  formula  to the D  column  below the  cell  ,B  ,C  ,D column  content  is  merged into the  E column corresponding to the  cell  .<br>3  selectedE column  ,performing  copy  ,and then select the  F column  ,performing  editor  ,paste  commands  ,open  paste  dialog box  ,select one of the  value  options  ,press the  OK  ,the E column  content  (  not  formula)  that  is copied to  the F column  .<br>4  B,C  ,D  ,E  column delete  ,merge completed  work  .Tips  :completed in first  ,2 stepoperation  ,combined  effect has been achieved,  but  if the  deletion of B  ,C  ,D column  ,the formula  error  .<br>So  for the third step  operation  ,will be  converted to  constant  value  formula  .&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;generation  ,often  a friend asked  how to print  the results section    ,many people have  taken  to record a macro  or VBA  method  to achieve  this  ,for beginners  there is a certain degree of difficulty  .<br>From this  consideration,  I  here is  a  function of the realization of the  simple method  .Here  it is assumed that the students  results stored in the  Sheet1  tableA1  to G64cellarea,  of which first  behavioral problems,  second behavioral  subject name  .<br>The 1 switch to  an Sheet2 worksheet  ,select  cell A1  ,enter the formula  :=IF  (  MOD  (  ROW  )  ,=0  (3),  (  0MOD,IF  ?ROW  (  )  ,3(=1  ,sheet1  !A  INDEX  (  Sheet1  ū!$A:$G  ,INT  (  (  (  ROW  )  /3  (+4  ))  ,COLUMN  (  +1  ))  )  )  )  .<br>2  selected againA1  cell,with  the fill handle  the  formula copied to  B1 to  G1 cell  ;then  again  at the same time  ,select A1  to G1range,with  the fill handle  the  formula  copied to A2  to G185cells.<br>So far  ,the results section  the basic shape,  the following simple  modification  .3  adjustrow height and  width  ,and  select A1  to G2range(  first  student achievement  of area  )  ,according to the  format  Toolbar  frame    drop-down button  ,in the  subsequent  frame  list,  select  all  frame line  option  for the selected  area  ,add a border  (  if  not  need to  frame  ,can not carry out  this  step  and  the following operation  )  .<br>4 at the same time,  select A1  to G3cellarea  ,click on the  common  Toolbar  format  brush  button  ,and then  press and hold the left mouse button  ,drag  from  A4  G186cellarea  ,for all  the results section  add a border  .<br>Press the  button  ,then  print out  results  .In fourteen  ,Excel  help you select the  function to the  function of processing  data,  often do not know  what  more appropriate  use of  function  .Excel  search  function  function can help you  narrow the scope,  choose appropriate  function  .<br>Implementation of the  insert  function  command  ,open the  insert function  dialog box  ,in the  search  function  in the  box below  the input requirements  (  such as  count  )  ,and then click the  go  ,the system  will  immediately  with  count  - related functions  selected ,  and displayed in the  function  of the list box below  in  .<br>Combined with the  view the corresponding help  file  ,can  quickly determine  the required functions  .In fifteen  ,while viewing a  different  sheet  of cells  within the data  sometimes  ,we compiled  a  work  table  (  Sheet1  ),need to see  another sheet  (  Sheet2  ,Sheet3  .<br>.....  )  a  cell contents,  Excel can use the  monitor  function to achieve  .Implementation of the  view  toolbar  -  Watch window  open  command  ,the monitoring window  ,click  the  add  button  ,start  monitoring  add watch  dialog box  ,use the mouse to select  the  cell  needs to view  ,and then click the  add  .<br>Repeat  the  operation  ,add other  point lookout  .Later  ,no matter in which  the work table,  just open the  monitor  ,you can view  all monitored  point  within a cell  data and related  information  .<br>In sixteen  ,for the cell  rapid  picture frame  in  Excel 2002  previous versions,for the cell  area to add  frame  is inconvenient to operate  ,Excel 2002  thisfunction  for a new  development  .Click the  format  Toolbar  frame    drop-down button  ,on the pop-up  drop-down list,  choose  drawing  frame  option  ,or to perform  view  toolbar  to  border  command  ,launched the  border  toolbar  .<br>Click the toolbar  the left-most  dropdown button  ,select  a  style of the border  ,and then in the  need to  add a border  cell  area  of drag,  can provide  the corresponding cell  area rapid  drawing  frame  .<br>Tips  : if the  wrong  frame  ,never mind  ,the selected  Toolbar  erasure  frame  button  ,then the error  frame  dragging  ,can  remove  the error  frame  .If  need  to draw a different  color frame  ,can  according to the  toolbar  on the right side of the  color line  button  on the pop-up  palette  ,select  the  color,  then draw  frame  can be  .<br>③  thiscan also function  in the cell  picture  diagonal  slash  .&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;seventeen  ,control of  cell specific  input  text length  can you think of  when you  input  cell  is  filled with  four digits  a  two digit number  ,or  in  the input  text  in the cell  you have  entered the  digital time,  Excel  will automatically judge  ,real-time  analysis  and display a warning  ,that nice ah  !To achieve this function  ,Excel,  is also not difficult  .<br>For example,  we  put the cursor  into a register  year  in the cell  ,in order to enter  the unity and  the convenience of the calculation  ,we hope that the  year  is  a four digit  to represent  .So  ,we can click  data  menu    option  .<br>In the  Settings  card  validity  conditions  allow  dropdown menu select  text length  .And then in the  data  dropdown menu select  equal to  ,and    length  .At the same time  ,we have  to  error  warning  card,  invalid input  data when the display  error  warning  is set to  stop  ,and in the  title  false information  column  in the  input text  are  illegal  !and  please enter  the four digit year  .<br>Word.  Obviously  ,if there are  people in the  cell of the  input is not  a  four digit,  Excel will  play the  show  warning dialog box  ,to tell you  the cause of the error  ,and  until you  enter the correct  style  numerical  rear can  continue to input  .<br>Magic  ?Actually,  in the Excel  data validity  judgment  ,there are many  special  types of data  formats  ,such as  text    sequence  size    the time distance  ah  ,if you are interested,  why not  self-assertive  ,design their own  a  standard  ,make your Excel  display  out of  out of the ordinary  .<br>.Eighteen  ,group  filled  form  fixed  cell  we know that  every time you open the  Excel  ,software  is always the default  open  multiple worksheets  .Thus  we can see that the  Excel has  powerful  leaflet  form  processing capacity  ,more suitable for  a plurality of  interconnected form  to coordinate work  .<br>To coordinate the  relationship  ,of course  first  requires  synchronization input  .Therefore  ,in many cases  ,will need  at the same time  in the  form  of the same  cell  type in the same  content  .<br>How  to  form  the group  editor  ?We  click on the first  sheet tab  name  ,then  hold down the Shift key  ,click the last  table  tab  name  (if we want to  correlate with the  form is not  together  ,can  hold down the Ctrl key  to  select  )  .<br>At this time,  we see  the Excel title bar  name  appeared  working group  ,we  can be carried out on the  working group of the  editing  work  .In need of  an  input  form  content  in the cell  free to write  something,  we find that  ,working group  of  all forms  in the same location  are displayed  corresponding  content  .<br>However  ,only  sync input  is not enough  .For example  ,we  need to  form  in the same location of the  uniform data  format change  how to do  ?First of all  ,we  have to change  the first  table of data  format  ,and then click the  Edit  menu  filler  option  ,and then in  the  sub  menu select  to the same  group of sheets  .<br>At this time,  Excel  will pop up  filling  group working  table  dialog  ,here  we choose the  format  a  ,identified  ,in the same group  all  form  the location data  format  has changed  .Nineteen  ,change  the size of the text  written  in Excel,  to  form processing  and  data operation  to provide the most powerful  support  than  formula  ,also  is not a database  ,but  function  .<br>Don  Excel function  only in response to the  numbers,  as  is  written in the  form content  ,Excel have  to edit it  and special  function  .For example,  to change the text  size  .In Excel 2002,  provided at least  three  relevant  text  case-sensitive conversion  function  .<br>They are:  =UPPER  (  source  data format  )  ,the text  of all  converted to uppercase  ;=LOWER  (  source  data format  )  ,the text  of all  converted to lowercase  ;=PROPER  (  source  data format  )  ,to convert text  appropriate  case  ,such as  to make  every  word the first letter  for  capital  etc.<br>  .For example  ,we are in  a form  of  A1 cell  input  lowercase  excel  ,then the target  cell  type  (  A1  ),enter  the results obtained  will be  EXCEL  .Similarly,  if  we are in  A3 cell  type  ,then we  in  the target cell  type  (  A3  ),then we get  the result is  Mr.<br>Weiwei  .Twenty  ,to extract a string  of  specific characters  in addition to the direct  input  ,from the existing  cell content  extracting specific  character input  ,the absolute is a  time-saving and  convenient method  ,especially for some  pattern similar to the  information  is more such  ,for example  ,nationality  through  information such as  employee list  .<br>If we  want to  fast from  A4 cell  extraction  appellation  words  ,it is best to use  =RIGHT  (  source data  grid  ,the extracted characters  .)  function  ,it said  from A4  cellon the right side of  the characters begin to  extract the  2 charactersinput  to this location  .<br>Of course  ,if you want to  extract the  name  words  ,is  to use  =LEFT  (  source data  grid  ,the extracted characters  .)  function  .There is also a situation  ,we do not  start  from  left and right ends  ,but directly from the  data center  extraction of several  characters  .<br>For example,  we  want from  A5 cell  extraction  Wuhan  two words  in  the target cell  ,simply  type  (  A5,4,2  )can be  .Meaning  :in the A5  cellextract  fourth characters  two characters  ,namely fourth  and fifth  two characters  .<br>In twenty-one  ,the  cardinal  ordinal number  will be  converted into  English  the cardinal  ordinal number  is  converted to  a complicated problem  .Because it does not have a  fixed patterns  :most figures  in  into  ordinal numbers  are used in  th  suffix  ,but generally  is  1,2,3the figure is  respectively with the  ST  ,nd  and  Rd    .<br>But  ,11,12,13the 3 numbers  are not the same  ,they still  ends with  .Therefore  ,to realize it  seems very complex  .In fact  ,as long as  our manage clear thinking  ,search  function  ,only need  to write a  formula  ,it  can be easily  converted to  .<br>Do not believe  ,please see  :=A2&amp  ;IF  (  OR  (  VALUE  (  RIGHT  (  A2,2  ))  ={11,12,13}  )  ,″ th ″(OR  ,IF  (  VALUE  (  RIGHT  (  A2  ))  ={1,2,3  ,}  ,CHOOSE  (  RIGHT  (  A2  ),ST  ,nd  ,Rd  ,  )  .<br>)  )  .The formula  despite a long list  ,but  the meaning is  very  clear  : if the  number is  11,12,13,plus the  suffix  ;if  first  principles  invalid  ,check the  last digit  ,with  ST  ,to  use  2the  nd  ,with  the use of  Rd  ;if  first  ,2principlesare invalid,  then use  th  .<br>Therefore  ,the cardinals and ordinals and  conversion is realized  so  easy and fast  .In twenty-two  ,with special symbols  to complete the  number and  financial  dealings  knows  ,in the  book  when filling  a  conventional  safe  fill  method  ,which is  the amount  of  space  to complete  ,or in the  amount of  data  is preceded by    symbol  .<br>In fact  ,in the Excel also has  similar input  method  ,that is the  REPT  function  .Its basic  format is  =REPT  (  special characters  ,padding bits  )  .For example  ,we want to  in  A2  cellnumbers in the  end  with  #  filled  to 16  ,the  formula was changed to  simply  =  (  A2&amp  ;REPT  (  #  ,16-LEN(  A2  ))  )  can;  if we want to  A3 cell  numbers from  the left  #  No.<br>  fill  to 16  ,will be  changed to  (  #  ,16-LEN(  A3  ))  )  &amp  ;A3  ;in addition  ,if we  want to use  #  number  in the A4  valuefrom both sides of  filling  ,is  need to be changed to  =REPT  (  #  ,8-LEN(  A4  )/2  )&amp  ;A4&amp  ;REPT  (  #  .<br>)  8-LEN(A4  )/2  );if you have  enough  professional  ,in the A5  cell numbers,immediate  plus  $  symbols in the words  ,then  changed to  :=  (  TEXT  (  A5  ,$#  ,##0.00 ″  (&amp;REPT  (  #  ,16-LEN(  TEXT  (  A5  ,$#  ,##0.<br>00  .)  )  )  )  ,will certainly be able to meet your  requirements  .Twenty-three  ,create text  histogram  besides repetitive  input  ,the  function  another  derivative  application  that  can be directly in the work  table  created by the  pure  text  consisting of  histogram  .<br>Its principle  is simple  ,is the use of  special symbols in the  intelligent  repeat  ,according to the  specified cell  the results  show  different lengths of the  comparative effectiveness  .For example,  we first  make an  annual  balance sheet  ,and then the  E  as  the histogram    month display  area  ,the  G  as  over budget  in the histogram  display area  .<br>Then  according to the table  for the  D  value,  use the  font  N  character  displays  .The specific steps are as follows  :in the E3  written in a cellformula  =IF  (  D30  ,REPT  (  n  ,ROUND  (  D3*100,0  ))  ,.<br>)  ,also  drag the fill handle  to G14  .We see that  ,a  Excel  chart function  without the use of  plain text  histogram has been  right in front of you  ,convenient  ,simple and clear  .In twenty-four  ,the  total number of  calculation  cell  sometimes  ,we  may have on  the number of characters  in a cell  of interest  ,need to calculate  the total number of words  in a cell  .<br>To solve this problem  ,in addition to the use of  the  SUBSTITUTE  function of the  virtual computing  ,but also  use the  TRIM  function to  remove the spaces  .For example,  A1 now  entered in the cell  is  how  many  words  ?,then we can use the  following  expressions to  help  :=IF  (  LEN  (  A1  )=0,0  ,LEN  (  TRIM  (  A1  ))  -LEN  (  SUBSTITUTE  (  TRIM  (  A1  ),,,  +1  ))  )  the  type  the meaning  is to use the  SUBSTITUTE  function creates a new  string  ,and the use of  TRIM  function to remove  the  spaces between characters  ,and then calculate  the string  and  the original string  digital  differential  ,so that  the number of  space  ,the  number of spaces  +1  ,reached the  cell  number of characters  .<br>In twenty-five  ,the  euro conversion  which is  Excel 2002  new tools.If you  install Excel 2002  when the choice is adefault,  it  may not be  in the  menu  to find it  .However  ,we  can first select  tools  menu  add-ins  ,and then in the  pop-up window to  check the  Euro tool  options  ,  Excel 2002  willinstall itself  .<br>After the completion of  our  open again  tools  menu  ,click the  euro conversion  ,an independent  specialized for  the euro and the  European Union Member States  currency conversion  window  will appear  .<br>With other Excel  function window  ,we can  through the mouse  set the currency  conversion  source region  and  target area  ,then choose the  before and after conversion of the  different currencies  .<br>Shown below  is  euro 100  were  converted into  other  currencies  EU members  list  .Of course  ,in order to make the  euro  shows  the more professional,  we can also  click  on the Excel toolbar  button  ,so that all the  euro  converted  monetary values  are  the euro  style  .<br>
 
&nbsp;perhaps you have  accomplished in Excel  over  hundreds of  financial statements  ,you may have  to use Excel to realize  the complicated calculation of  thousands of times  ,maybe you think  Excel is  just so so,  even  without new idea  .<br>But  we  repeated  the  handy  method of using  only  Excel all  the one percent skills  .The topic from  a Excel some  little-known techniques  of  about Excel  ,enjoy the  different customs  .&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;one  ,for  different types of data  with different colors  displayed on the  pay table  ,if you want  greater than or equal to 2000  yuantotal wages  to  red  display  ,greater than or equal to  1500 yuanof the  total wages  for the  shows  ,below 1000 yuan  to  total wages  Brown  display  ,other  black  display  ,so we can  set  .<br>1 open the  payroll  workbook  ,select the  total wages  in the column  ,performing  format  conditional formatting  commands  ,open  conditional formatting  dialog box  .Click  the  drop-down button  second  to the right of the box  ,select the  greater than or equal to  option  ,at the back of the  box  2000input values.<br>Click the  format  open  button  ,the Format Cells  dialog box  ,the  font    is set to  red  .2  press the button  ,and modeled after the  above operations  for the other  conditions  (  greater than or equal to 1500  ,the font is  blue  ;less than 1000  ,the font is  Brown  )  .<br>The 3  set is complete,press the  OK  .Have a look  the payroll  ,salary amount  data  is it right?  According to your requirements  in different colors  out of  .&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;two  ,the classification of the establishment of  the drop-down list  we  often  filled  to enterprise  name  entered into the table  ,in order to keep the  name consistency  ,using the  data  function  to build a  classification of  filling  a  drop-down list  .<br>1  in the Sheet2 ,the  company name  by category  (  such as  industry  ,business  ,individual businesses    are input to  different columns  ,to establish a corporate  name database  .2  selectedA column  (  industry  of  the column  )  ,in the  name  column  ,enter  industry  character  ,press    confirm  .<br>According to  the above,  the B  ,C  ...  ...  The column  named  business  ,individual enterprises  ...  ...  The 3 switch to  Sheet1,  select  input  business  class  column  (  such as  C  )  ,performing  data  validity  open  command  ,data validity  dialog box  .<br>In the  Settings  tab,  click  allow    drop-down button  ,select  sequence  options  ,sources  in the following  box  ,enter  industry  ,business  ,individual enterprises  ...  ...  Sequence  (  between elements of the  English  commas  )  ,decided to quit  .<br>Then select the  required  input company name  column  (  such as  D  )  ,then open the  data  dialog box  ,select  sequence  option  in the  source  box  ,enter  the equation: =INDIRECT  (  C1  ),decided to quit  .<br>4  selectedC column  any cell  (such as C4  ),click  the  drop-down button  ,choose the corresponding  business  class  in  the cell  .And then select the  cell corresponding to the  D  column of cells  (  such as D4  ),click the drop-down  button  ,can from  the corresponding category of  enterprise name  list  to select the  name of the enterprise  in  the cell  .<br>Note:  later in  print statements  ,if  do not need to  print  category  column  ,the column  can be  selected  ,right click your mouse  ,select  hidden  option  ,the column is  hidden  .Three  ,establish a  common  document  menu  in the  menu bar  to build  a  common  document  menu  ,the commonly used  workbook  file  add to them,  at any time convenient call  .<br>1  empty space on the toolbarright-click  ,select  custom  options  ,custom  dialog box  open  .In  command    ,select  categories  below  the new  menu  item  ,then  command  below  the new  menu  drag  the menu bar  .<br>According to  change your selections  button  ,the  pop-up menu    box,  enter a name  (  such as  common  .)  .2  below  choose one  (  such as  insert  option)  ,on the right  order  the  choice of a  (  such as  hyperlinks  option)  ,drag it to the new  menu  (  commonly used  document  )  ,and modeled after the  above operations  performed on it  (  such as the  named  payroll  etc.<br>  )  ,the establishment of the first  workbook  file  list name  .Repeat the above operation,  more  add a few  document  list name  .3  selectedcommonly used  document  menu,  a menu item  (  such as  payroll    ,right mouse click  ,in  the pop-up menu  ,choose  assigned  hyperlinks  to  open  options  ,Hyperlink  dialog box  open  distribution  .<br>By pressing the      drop-down button  ,navigate to the  Workbook  (  such as  salary.Xls    folder  ,and select the  workbook  file  .Repeat the above operation,  the  menu item  and its  corresponding  workbook  document  links  up  .<br>In 4 after the  need to open the  common  document  menu in  a workbook  document,  as long as the  start  menu  ,click  commonly used  document  in which  the corresponding  option  .Note:  Although we will  hyperlinks  option  until the  common  document  menu,  but does not affect the  insert  menu  hyperlinks  menu item and the  common  Toolbar  insert hyperlink  button function  .<br>Four  ,making  symbol  toolbar  in  professional editing  form,  often  need to import some  special  symbols  ,in order to  facilitate the input,  we  can create a  belongs to own  symbol  toolbar  .<br>1  Tools >  macro  to  record new macro  command  ,open  record new macro  dialog box  ,enter the  name  such as  fuhao1  ??and  macro security  presence  personal macro Workbook  ,then  identify  start recording  .<br>Select the  recording  Toolbar  relative  button  ,then  will need  special symbol input  into a cell  ,and then click the  recording  of the  stop  on the toolbar  ,complete macro  recording  .According to  the above,  recorded  one one  other  special symbols in the  input  macro  .<br>2 open the  custom  dialog box  ,in the  Toolbar    ,click the  new  pop-up  new toolbar  dialog box  ,enter the name  --  symbol  ,are identified,  namely  in the work area  in  a tool bar  .Switch to  command    ,select  categories  below  macro  ,order  below  custom button  drag  symbol  bar  (  the number of  special symbols  on the drag  a  button  )  .<br>3  select one ofa  button  ,modeled as second  -  first  of them  named  .4  right-click anamed after the  button  ,in the ensuing  pop-up menu  ,choose  assign  option  ,open  assign  dialog box  ,select  the appropriate macro  (  such as fuhao1)  ,decided to quit  .<br>Repeat this  step of the operation  ,the button  and  the corresponding macro  link  up  .The closure of 5  custom  dialog box  ,later  can be used  as  ordinary  toolbar  ,the use of  symbol  toolbar  ,cell to cell  quickly enter  professional  symbols  .<br>In five  ,with  visual  manager  save multiple  print page  some  sheet  ,often need to  print wherein  different regions,  with  visual  manager  .  .1 open the  need to print a  sheet  ,with the mouse in  need not  print  row  (or column  )  marked on the  tractor  ,select them  and  right mouse click  ,in  the ensuing  shortcut menu,  choose the  option  hide  ,will not  need to print a  row  (  or column  )  to hide  .<br>2  view  view  manager  command  ,open the  visual  manager  dialog box  ,click  add  button  ,pop-up  add  view  dialog box  ,enter a name  (  such as  report  )  ,click  button  .3 will be  hidden rows  (  or  columns  )  is displayed  ,and  the operation is repeated,  adding  other  print  view  .<br>In 4 after the  need to print  a  form,  open  view  manager  ,select the  need to print a  form name  ,click the  show  ,the sheet  immediately  according to the  preset  interface  display,  simple setting  ,typesetting  ,press the  print  button  on the toolbar  ,all  on OK  .<br>Six  ,make  data  on-demand  sort  if you want the  staff  at the  Department  for sorting  ,these  departments  of  both  information  not  according to the phonetic  sequence  ,not  according to the  stroke order  ,how to do  ?Can use  custom sequence  to sort  .<br>1  format  options  command  ,open the    dialog box,  enter the  custom sequence  label  ,the  input sequence  below  the input sector  in  the sorted sequence  (such as  organ  ,fleet  ,a  workshop  ,two workshops  ,three  workshop    ,click  add  and  OK  button to exit  .<br>2  selecteddepartments  column  in any one  cell  ,performing  data  sort  command  ,open the  dialog box,  click  sorting  options  button  ,the pop-up  sort options  dialog box  ,click  the  drop-down button  ,select  just  custom  sequence  ,two press    button on the back,  all the data  in  requirements for a  sort  .<br>&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;seven  ,the  data is  completely hidden  portions of the sheet  cell content  does not want to let  visitors  access  ,had to  hide it  .<br>1  selectHide content  cell  (regional)  ,performing  format  cells  open  command  ,the Format Cells  dialog  in  ,digital  label  classification  below and  select  option  ,and then the right  below  type  enter  ;;;(  three  English  state  the  semicolon  )  .<br>2  thenswitched to  protect  tab,  select one of the  hidden  option  ,click  button to exit  .3  the implementation of the to  protect  to  protect sheet  open  command  ,the protecting sheet  dialog box  ,set the  password,  OK  .<br>After such  settings  ,the  cell content  is no longer  displayed  ,is to use  Excel  function also  cannot make its  appear  transparent  .Tip: in the  protection  label  ,please do not  remove  locked  in front of  the check box in the  V  ,this can prevent  others to delete  your  hidden  data  .<br>Eight  ,in the  English  input method  ,intelligent  appeared in  edited  form,  some  cells  to  input  English  ,some  cells  to  input  Chinese  ,repeatedly  switching input method  is  not convenient  ,why not  set up  ,lets the input method  of intelligent  adjustment  ?Select  input  Chinese  cell  area  ,implementation of the  data  effectiveness of  open  command  ,data validity  dialog box  ,switch to the  input  mode  label  ,according to the  mode    drop-down button  ,select  open  option,  OK  .<br>When  selected  to  input  Chinese  range  in any one  cell,  Chinese  IME  (  input method  in the list of  first  Chinese  input method  )  is automatically opened  ,when  other  cells,  Chinese  input method  automatically closes  .<br>Nine  ,make  automatic corrections  input  unified text  you  is it right?  Often  enter certain  fixed text  ,such as  newspaper  computer  and trouble  ?You  look down  .1  Tools >  AutoCorrect  open  command  ,automatic  correction  dialog box  .<br>2  replacement  in  the box below  to enter  PCW  (  or other  characters  ,PCW  with a lowercase  )  ,in the  substituted for  enter  below  newspaper  computer  ,then click  add  and  OK  .The 3  later if you need toinput  the  text  PCW  ,as long as the input  character  ?This can  not consider  PCW  size  ?,then  confirm  became  .<br>In  ten  ,a custom Excel  function Excel  although abundant  ,but did not  meet our  need  .We  can define  a function  ,to accomplish some  particular operations  .Below,  we will  from the definition of a  calculation of  trapezoid area  function  : 1  Tools >  macro  → VisualBasic  editor  menu  (  or  press the  shortcuts  )  ,open the Visual  Basic editor window  .<br>2  in the window,to perform  insert  module  menu command  ,insert a new module  -  module 1  .The 3  on the right side of thecode window  enter the following  code  :Function  V  (  a  ,B  ,H  )  V =  h*  (  a+b  )  /2End  Function 4  to close the window,a custom  function  .<br>After  using the built-in  function  like  using a custom  function  .Tip: use  the above  method to customize the  function usually  can only be  used in  the corresponding  workbook  .Eleven  ,the header  arranged under the  picture  for the sheet  to add background  ,is lined on  the  work  table  below  ,can be only the  lining  in the header  below  ?1format  sheet  and  background  open  command  ,sheet background  dialog box  ,select  as a background  picture,  press the  button  ,the picture  is lined in the  entire sheet  below  .<br>2  while holding down the Ctrl key,use the mouse  without  lining  picture cell  (  regional  )  drag  ,and  select the  cell  (  regional  )  .In 3  format  Toolbar  fill color  to the right of the  drop-down button  ,in  the subsequent  palette  ,select  white  .<br>After such  settings  ,leaving the  cells  lining  the  picture  below  ,the  selected cell  (  area  )  below  without  lining  pictures  (in fact,  is the picture  is  white  cover  )  .Tips  ?Lining in the  cell  below is  not  support printing  .<br>Twelve  ,use a hyphen  &amp  ;to  merge text  if we want  more  content is merged  into one column  ,do not need to use  function  ,a small  hyphen  &amp  ;you can use it  .(  this  assumes that the B  ,C  ,D  columns are merged  into one column  )  .<br>1  listed in the Dinserted behind the  two  column  (  E  ,F  )  ,then D1  cell of theinput  formula  :=B1&amp  ;C1&amp  ;D1  .2  selected againD1  cell,with  the fill handle  the  formula  to the D  column  below the  cell  ,B  ,C  ,D column  content  is  merged into the  E column corresponding to the  cell  .<br>3  selectedE column  ,performing  copy  ,and then select the  F column  ,performing  editor  ,paste  commands  ,open  paste  dialog box  ,select one of the  value  options  ,press the  OK  ,the E column  content  (  not  formula)  that  is copied to  the F column  .<br>4  B,C  ,D  ,E  column delete  ,merge completed  work  .Tips  :completed in first  ,2 stepoperation  ,combined  effect has been achieved,  but  if the  deletion of B  ,C  ,D column  ,the formula  error  .<br>So  for the third step  operation  ,will be  converted to  constant  value  formula  .&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;generation  ,often  a friend asked  how to print  the results section    ,many people have  taken  to record a macro  or VBA  method  to achieve  this  ,for beginners  there is a certain degree of difficulty  .<br>From this  consideration,  I  here is  a  function of the realization of the  simple method  .Here  it is assumed that the students  results stored in the  Sheet1  tableA1  to G64cellarea,  of which first  behavioral problems,  second behavioral  subject name  .<br>The 1 switch to  an Sheet2 worksheet  ,select  cell A1  ,enter the formula  :=IF  (  MOD  (  ROW  )  ,=0  (3),  (  0MOD,IF  ?ROW  (  )  ,3(=1  ,sheet1  !A  INDEX  (  Sheet1  ū!$A:$G  ,INT  (  (  (  ROW  )  /3  (+4  ))  ,COLUMN  (  +1  ))  )  )  )  .<br>2  selected againA1  cell,with  the fill handle  the  formula copied to  B1 to  G1 cell  ;then  again  at the same time  ,select A1  to G1range,with  the fill handle  the  formula  copied to A2  to G185cells.<br>So far  ,the results section  the basic shape,  the following simple  modification  .3  adjustrow height and  width  ,and  select A1  to G2range(  first  student achievement  of area  )  ,according to the  format  Toolbar  frame    drop-down button  ,in the  subsequent  frame  list,  select  all  frame line  option  for the selected  area  ,add a border  (  if  not  need to  frame  ,can not carry out  this  step  and  the following operation  )  .<br>4 at the same time,  select A1  to G3cellarea  ,click on the  common  Toolbar  format  brush  button  ,and then  press and hold the left mouse button  ,drag  from  A4  G186cellarea  ,for all  the results section  add a border  .<br>Press the  button  ,then  print out  results  .In fourteen  ,Excel  help you select the  function to the  function of processing  data,  often do not know  what  more appropriate  use of  function  .Excel  search  function  function can help you  narrow the scope,  choose appropriate  function  .<br>Implementation of the  insert  function  command  ,open the  insert function  dialog box  ,in the  search  function  in the  box below  the input requirements  (  such as  count  )  ,and then click the  go  ,the system  will  immediately  with  count  - related functions  selected ,  and displayed in the  function  of the list box below  in  .<br>Combined with the  view the corresponding help  file  ,can  quickly determine  the required functions  .In fifteen  ,while viewing a  different  sheet  of cells  within the data  sometimes  ,we compiled  a  work  table  (  Sheet1  ),need to see  another sheet  (  Sheet2  ,Sheet3  .<br>.....  )  a  cell contents,  Excel can use the  monitor  function to achieve  .Implementation of the  view  toolbar  -  Watch window  open  command  ,the monitoring window  ,click  the  add  button  ,start  monitoring  add watch  dialog box  ,use the mouse to select  the  cell  needs to view  ,and then click the  add  .<br>Repeat  the  operation  ,add other  point lookout  .Later  ,no matter in which  the work table,  just open the  monitor  ,you can view  all monitored  point  within a cell  data and related  information  .<br>In sixteen  ,for the cell  rapid  picture frame  in  Excel 2002  previous versions,for the cell  area to add  frame  is inconvenient to operate  ,Excel 2002  thisfunction  for a new  development  .Click the  format  Toolbar  frame    drop-down button  ,on the pop-up  drop-down list,  choose  drawing  frame  option  ,or to perform  view  toolbar  to  border  command  ,launched the  border  toolbar  .<br>Click the toolbar  the left-most  dropdown button  ,select  a  style of the border  ,and then in the  need to  add a border  cell  area  of drag,  can provide  the corresponding cell  area rapid  drawing  frame  .<br>Tips  : if the  wrong  frame  ,never mind  ,the selected  Toolbar  erasure  frame  button  ,then the error  frame  dragging  ,can  remove  the error  frame  .If  need  to draw a different  color frame  ,can  according to the  toolbar  on the right side of the  color line  button  on the pop-up  palette  ,select  the  color,  then draw  frame  can be  .<br>③  thiscan also function  in the cell  picture  diagonal  slash  .&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;&nbsp  ;seventeen  ,control of  cell specific  input  text length  can you think of  when you  input  cell  is  filled with  four digits  a  two digit number  ,or  in  the input  text  in the cell  you have  entered the  digital time,  Excel  will automatically judge  ,real-time  analysis  and display a warning  ,that nice ah  !To achieve this function  ,Excel,  is also not difficult  .<br>For example,  we  put the cursor  into a register  year  in the cell  ,in order to enter  the unity and  the convenience of the calculation  ,we hope that the  year  is  a four digit  to represent  .So  ,we can click  data  menu    option  .<br>In the  Settings  card  validity  conditions  allow  dropdown menu select  text length  .And then in the  data  dropdown menu select  equal to  ,and    length  .At the same time  ,we have  to  error  warning  card,  invalid input  data when the display  error  warning  is set to  stop  ,and in the  title  false information  column  in the  input text  are  illegal  !and  please enter  the four digit year  .<br>Word.  Obviously  ,if there are  people in the  cell of the  input is not  a  four digit,  Excel will  play the  show  warning dialog box  ,to tell you  the cause of the error  ,and  until you  enter the correct  style  numerical  rear can  continue to input  .<br>Magic  ?Actually,  in the Excel  data validity  judgment  ,there are many  special  types of data  formats  ,such as  text    sequence  size    the time distance  ah  ,if you are interested,  why not  self-assertive  ,design their own  a  standard  ,make your Excel  display  out of  out of the ordinary  .<br>.Eighteen  ,group  filled  form  fixed  cell  we know that  every time you open the  Excel  ,software  is always the default  open  multiple worksheets  .Thus  we can see that the  Excel has  powerful  leaflet  form  processing capacity  ,more suitable for  a plurality of  interconnected form  to coordinate work  .<br>To coordinate the  relationship  ,of course  first  requires  synchronization input  .Therefore  ,in many cases  ,will need  at the same time  in the  form  of the same  cell  type in the same  content  .<br>How  to  form  the group  editor  ?We  click on the first  sheet tab  name  ,then  hold down the Shift key  ,click the last  table  tab  name  (if we want to  correlate with the  form is not  together  ,can  hold down the Ctrl key  to  select  )  .<br>At this time,  we see  the Excel title bar  name  appeared  working group  ,we  can be carried out on the  working group of the  editing  work  .In need of  an  input  form  content  in the cell  free to write  something,  we find that  ,working group  of  all forms  in the same location  are displayed  corresponding  content  .<br>However  ,only  sync input  is not enough  .For example  ,we  need to  form  in the same location of the  uniform data  format change  how to do  ?First of all  ,we  have to change  the first  table of data  format  ,and then click the  Edit  menu  filler  option  ,and then in  the  sub  menu select  to the same  group of sheets  .<br>At this time,  Excel  will pop up  filling  group working  table  dialog  ,here  we choose the  format  a  ,identified  ,in the same group  all  form  the location data  format  has changed  .Nineteen  ,change  the size of the text  written  in Excel,  to  form processing  and  data operation  to provide the most powerful  support  than  formula  ,also  is not a database  ,but  function  .<br>Don  Excel function  only in response to the  numbers,  as  is  written in the  form content  ,Excel have  to edit it  and special  function  .For example,  to change the text  size  .In Excel 2002,  provided at least  three  relevant  text  case-sensitive conversion  function  .<br>They are:  =UPPER  (  source  data format  )  ,the text  of all  converted to uppercase  ;=LOWER  (  source  data format  )  ,the text  of all  converted to lowercase  ;=PROPER  (  source  data format  )  ,to convert text  appropriate  case  ,such as  to make  every  word the first letter  for  capital  etc.<br>  .For example  ,we are in  a form  of  A1 cell  input  lowercase  excel  ,then the target  cell  type  (  A1  ),enter  the results obtained  will be  EXCEL  .Similarly,  if  we are in  A3 cell  type  ,then we  in  the target cell  type  (  A3  ),then we get  the result is  Mr.<br>Weiwei  .Twenty  ,to extract a string  of  specific characters  in addition to the direct  input  ,from the existing  cell content  extracting specific  character input  ,the absolute is a  time-saving and  convenient method  ,especially for some  pattern similar to the  information  is more such  ,for example  ,nationality  through  information such as  employee list  .<br>If we  want to  fast from  A4 cell  extraction  appellation  words  ,it is best to use  =RIGHT  (  source data  grid  ,the extracted characters  .)  function  ,it said  from A4  cellon the right side of  the characters begin to  extract the  2 charactersinput  to this location  .<br>Of course  ,if you want to  extract the  name  words  ,is  to use  =LEFT  (  source data  grid  ,the extracted characters  .)  function  .There is also a situation  ,we do not  start  from  left and right ends  ,but directly from the  data center  extraction of several  characters  .<br>For example,  we  want from  A5 cell  extraction  Wuhan  two words  in  the target cell  ,simply  type  (  A5,4,2  )can be  .Meaning  :in the A5  cellextract  fourth characters  two characters  ,namely fourth  and fifth  two characters  .<br>In twenty-one  ,the  cardinal  ordinal number  will be  converted into  English  the cardinal  ordinal number  is  converted to  a complicated problem  .Because it does not have a  fixed patterns  :most figures  in  into  ordinal numbers  are used in  th  suffix  ,but generally  is  1,2,3the figure is  respectively with the  ST  ,nd  and  Rd    .<br>But  ,11,12,13the 3 numbers  are not the same  ,they still  ends with  .Therefore  ,to realize it  seems very complex  .In fact  ,as long as  our manage clear thinking  ,search  function  ,only need  to write a  formula  ,it  can be easily  converted to  .<br>Do not believe  ,please see  :=A2&amp  ;IF  (  OR  (  VALUE  (  RIGHT  (  A2,2  ))  ={11,12,13}  )  ,″ th ″(OR  ,IF  (  VALUE  (  RIGHT  (  A2  ))  ={1,2,3  ,}  ,CHOOSE  (  RIGHT  (  A2  ),ST  ,nd  ,Rd  ,  )  .<br>)  )  .The formula  despite a long list  ,but  the meaning is  very  clear  : if the  number is  11,12,13,plus the  suffix  ;if  first  principles  invalid  ,check the  last digit  ,with  ST  ,to  use  2the  nd  ,with  the use of  Rd  ;if  first  ,2principlesare invalid,  then use  th  .<br>Therefore  ,the cardinals and ordinals and  conversion is realized  so  easy and fast  .In twenty-two  ,with special symbols  to complete the  number and  financial  dealings  knows  ,in the  book  when filling  a  conventional  safe  fill  method  ,which is  the amount  of  space  to complete  ,or in the  amount of  data  is preceded by    symbol  .<br>In fact  ,in the Excel also has  similar input  method  ,that is the  REPT  function  .Its basic  format is  =REPT  (  special characters  ,padding bits  )  .For example  ,we want to  in  A2  cellnumbers in the  end  with  #  filled  to 16  ,the  formula was changed to  simply  =  (  A2&amp  ;REPT  (  #  ,16-LEN(  A2  ))  )  can;  if we want to  A3 cell  numbers from  the left  #  No.<br>  fill  to 16  ,will be  changed to  (  #  ,16-LEN(  A3  ))  )  &amp  ;A3  ;in addition  ,if we  want to use  #  number  in the A4  valuefrom both sides of  filling  ,is  need to be changed to  =REPT  (  #  ,8-LEN(  A4  )/2  )&amp  ;A4&amp  ;REPT  (  #  .<br>)  8-LEN(A4  )/2  );if you have  enough  professional  ,in the A5  cell numbers,immediate  plus  $  symbols in the words  ,then  changed to  :=  (  TEXT  (  A5  ,$#  ,##0.00 ″  (&amp;REPT  (  #  ,16-LEN(  TEXT  (  A5  ,$#  ,##0.<br>00  .)  )  )  )  ,will certainly be able to meet your  requirements  .Twenty-three  ,create text  histogram  besides repetitive  input  ,the  function  another  derivative  application  that  can be directly in the work  table  created by the  pure  text  consisting of  histogram  .<br>Its principle  is simple  ,is the use of  special symbols in the  intelligent  repeat  ,according to the  specified cell  the results  show  different lengths of the  comparative effectiveness  .For example,  we first  make an  annual  balance sheet  ,and then the  E  as  the histogram    month display  area  ,the  G  as  over budget  in the histogram  display area  .<br>Then  according to the table  for the  D  value,  use the  font  N  character  displays  .The specific steps are as follows  :in the E3  written in a cellformula  =IF  (  D30  ,REPT  (  n  ,ROUND  (  D3*100,0  ))  ,.<br>)  ,also  drag the fill handle  to G14  .We see that  ,a  Excel  chart function  without the use of  plain text  histogram has been  right in front of you  ,convenient  ,simple and clear  .In twenty-four  ,the  total number of  calculation  cell  sometimes  ,we  may have on  the number of characters  in a cell  of interest  ,need to calculate  the total number of words  in a cell  .<br>To solve this problem  ,in addition to the use of  the  SUBSTITUTE  function of the  virtual computing  ,but also  use the  TRIM  function to  remove the spaces  .For example,  A1 now  entered in the cell  is  how  many  words  ?,then we can use the  following  expressions to  help  :=IF  (  LEN  (  A1  )=0,0  ,LEN  (  TRIM  (  A1  ))  -LEN  (  SUBSTITUTE  (  TRIM  (  A1  ),,,  +1  ))  )  the  type  the meaning  is to use the  SUBSTITUTE  function creates a new  string  ,and the use of  TRIM  function to remove  the  spaces between characters  ,and then calculate  the string  and  the original string  digital  differential  ,so that  the number of  space  ,the  number of spaces  +1  ,reached the  cell  number of characters  .<br>In twenty-five  ,the  euro conversion  which is  Excel 2002  new tools.If you  install Excel 2002  when the choice is adefault,  it  may not be  in the  menu  to find it  .However  ,we  can first select  tools  menu  add-ins  ,and then in the  pop-up window to  check the  Euro tool  options  ,  Excel 2002  willinstall itself  .<br>After the completion of  our  open again  tools  menu  ,click the  euro conversion  ,an independent  specialized for  the euro and the  European Union Member States  currency conversion  window  will appear  .<br>With other Excel  function window  ,we can  through the mouse  set the currency  conversion  source region  and  target area  ,then choose the  before and after conversion of the  different currencies  .<br>Shown below  is  euro 100  were  converted into  other  currencies  EU members  list  .Of course  ,in order to make the  euro  shows  the more professional,  we can also  click  on the Excel toolbar  button  ,so that all the  euro  converted  monetary values  are  the euro  style  .<br>
 +
 +
== Only for 90,91,92,93 born after 90, too realistic, if your f ==
 +
 +
Only for  90,91,92,93bornafter 90  ,too realistic,  friends  if you are  a few years this  was born  ,I hope you will seriously  after reading  this article  ,you will  understand many reasons  like a  flower  ,but  is very loyal  &shy  ;relationresultSeems to be verystrong  ,in fact,  than those who  have  fragile  &shy  ;relationresultSeems to be very happy,but the sad smile,  and who understand.<br>..  &shy  ;relationresultIn fact,many times  &shy  ;relationresultSome90people areafflicted with &shy  in  self  ;relationresultLovelove each other very much  &shy  ;relationresultHewould rather die sad  &shy  ;relationresultAlsothe choice to go  &shy  ;relationresultThen turn around andleave &shy  ;relationresultEither random wanton tears.<br>..  &shy  ;relationresultIn fact many times&shy  ;relationresultTheseafter 90 people  understand very well  &shy  ;relationresultThey areafraid of lonely  &shy  ;relationresultBecausewhen a person  &shy  ;relationresultThey willmake blind and disorderly conjectures  &shy  ;relationresultTheywill remember the  story without an ending  &shy  ;relationresultThink ofthe  vague  but  clear  face  &shy  ;relationresultBecausewhen a person  &shy  ;relationresultTheywill feel very  insecure  &shy  ;relationresultTheir requestis always  low &shy  ;relationresultAs long aslove  accompany  them  .<br>..  &shy  ;relationresultIn fact many times&shy  ;relationresultAfterthis group of people  are very  sensitive to &shy  ;relationresultItis easy to  suspect  &shy  ;relationresultAn eye ,an action  &shy  ;relationresultWill allow them tobe  a whole day &shy  ;relationresultSo donlet them  scare  &shy  ;relationresultDonlet them hurt  &shy  ;relationresultIn fact many times&shy  ;relationresultAfterthis class of  people are  sentimental  &shy  ;relationresultThey arealways melancholy and moody  &shy  ;relationresultJusteasy to  be moved by what one sees  .<br>&shy  ;relationresultAfterthese people  like to use words  to write  their  mood &shy  ;relationresultIt is alsoone of their  sustenance  ...  &shy  ;relationresultIn fact many times&shy  ;relationresult90 in this classare  in contradiction  &shy  ;relationresultIs to continue orsuspended?  &shy  ;relationresultIsinsist or give up  ?&shy  ;relationresultThe seemingly emotionalthey  &shy  ;relationresultOftenin  the end.<br>..  &shy  ;relationresultAlways makerational  control the  whole thinking  ...  &shy  ;relationresultIn fact many times&shy  ;relationresultThis kind of personalways live in the past  &shy  ;relationresultThey alwaysinadvertently  in the present life  to find some  sense of deja vu  &shy  ;relationresultAlthoughthey  agreed  to forget the past  &shy  ;relationresultBut theyforget.<br>..  &shy  ;relationresultIn the pastin  mind  ingrained  ...  &shy  ;relationresultIn fact many times&shy  ;relationresultAfterthis kind of person  is afraid of  seeing others  sweet &shy  ;relationresultNotjealous of &shy  ;relationresultJustfeel  and previous  himself as  &shy  ;relationresultThenin  the  memory of  &shy  ;relationresultPastpain  to  awaken their  consciousness  &shy  ;relationresultOneslowly  licking their wounds  .<br>..  &shy  ;relationresultIn fact many times&shy  ;relationresultInthis class  are very  persistent  &shy  ;relationresultSometimesnot  know they  insist on  what &shy  ;relationresultThey arelooking forward to  the  never ending story  ending  &shy  ;relationresultStill waiting formore damage  &shy  ;relationresultThey aresilly &shy  ;relationresultInthis  class of human &shy  ;relationresultToo many shortcomings&shy  ;relationresultToosmelly  ,not  self-willed  ,and  sensitive suspicious  &shy  ;relationresultSo close to them or not&shy  ;relationresultEitheruse the sincerity  treats them  &shy  ;relationresultBecause they are very brittle heart&shy  ;relationresultYouvulnerable  .<br>..  &shy  ;relationresultAfter weare  fools  ,the  fools  ...  &shy  ;relationresultDonknow what the future  how far  .....&shy  ;relationresultWhetherand how many people  in  a  mobile phone  ,always hung with  QQ  ,a lot of people  together in one  block  ,a  mobile phone,  each  playing  each  &shy  ;relationresultClassmate partyrequired  two projects  :eat,  KTV  &shy  ;relationresultThe childstarted calling  his  uncle or aunt  &shy  ;relationresultNever lonely ,whenever you are alone  ,or in a crowed  &shy  ;relationresultJust likein the song  sings ,  alone  ,is a person  ,carnival  is a group of lonely people  ,&shy  ;relationresultNot soyoung cynic  ,encounter  injustice  when,  tell yourself,  the society is this  &shy  ;relationresultCannot  watch TV  ,but the computer is a necessity  in &shy  ;relationresultWilltake  out  three things: the  mobile phone  ,keys  ,money &shy  ;relationresultNever knowwhat  the  money  ,not how to eat,  how not to  wear &shy  ;relationresultNegative,refuse to grow up  .<br>Don  to be that mature.  &shy  ;relationresultAcquaintances before it isLao  ,strangers  not to utter a single word  &shy  ;relationresultThere must be ahobby  is  sleeping  with &shy  ;relationresultA dayon the Internet bubble  ,and do not know what to do  .<br>&shy  ;relationresultMost a word that often saysis  boring  ,although  they  spent  a lot of time  on the internet  .&shy  ;relationresultHungry toeat  breakfast  ,lunch  and eat together  &shy  ;relationresultTyping was quite inaccurate,but still playing very fast  &shy  ;relationresultBefore 12 a.<br>m.and  rarely  sleep  &shy  ;relationresultAnything can be ,because  do not have so much  time  ,also do not care  so much  about  &shy  ;relationresultThere is no reasonnot  to capital  pride  ,but in actuality they  inferiority  ,look  definitely  ,expect  recognition  ,being  hated  failure in life  when even  have the courage to say no  .<br>&shy  ;relationresultThought nobody can understand you,and as the  other people did not  reason  .&shy  ;relationresultBecause other people are in love soin love himself  ,more are practicing  love  and not  love  ,then  you even  begin to doubt  who  adhere to the love  .<br>&shy  ;relationresultOnce thought thataccompany for a lifetime in  friends  ,one day  a  month  ,you  suddenly find that they  are missing  &shy  ;relationresultWake up in the night,it  was shocked to discover that  ,never  alone  &shy  ;relationresultThe older,more  easily  lonely  &shy  ;relationresultAfter 90 of us,there are a lot of dreams,  some realized  some shattered  .<br>&shy  ;relationresultAfter 90 of us,some famous,  some  unknown to the public  .&shy  ;relationresultAfter 90,struggling over a loss  ,or  survive  .&shy  ;relationresultAfter 90,youth retreat  young  tender  ,began to adapt to  the social big family  .<br>&shy  ;relationresultOur heartsare very clear  ,we  experienced too much  .&shy  ;relationresultHad afling caution to the winds  pursuit  ,has become  not to be worth a hair  .Parents have  blocking  things  ,until  their injuries,  understand  ,parents  turned out to be  right  .<br>&shy  ;relationresultOncemany times  asked myself  ,why live  ?Later,  had  to  go to  the meaning of life  .&shy  ;relationresultIn order to have thelove can  not  love  reading  .&shy  ;relationresultHope that90 after us,happiness  .<br>

Revision as of 22:59, 3 July 2012

Like the subtle, subtle love

                longing for the quiet feeling, not imprint is engraved on my heart., not passion.I hope to have an ordinary life, quiet life.As long as the silent companionship, smiling eyes eyes have tenderness all in winding.
Like to drink a cup of tasteless and insipid white boiling water, can satisfy people's demand for water.Quietly embrace, will be able to feel the love in the heart beat of the heart will flow.            longing for the sky light cloud, and the horizon that faint bluish, envy clouds elegant Smart, like the blue LFT, secretly to rave reviews on the hidden in the bottom of my heart , to look for the blue sky the lft.
Days ago, that's the no perfect thing.Why bother , with subtle smile to resolve that the hearts of melancholy.Like the subtle to miss a collection, not to rise, not to show off.Just for my heart that light touch, the lingering tenderness.
Let the light moving along with the light wind.Not to think about the right and wrong, and wrong.Break a let, let Miss sleeping.Like the subtle feeling the night of quiet beauty, rain and wind , clear, light snow.
This light is a kind of artistic conception , tasteless and insipid and tasteless is pale, pale like chrysanthemum is pale, is misplaced hustle and bustle of peace after is calm like water, indifferent, it is so faint feel a belongs to own world.
Heart like a sky of the rain queen is as pure.Like the subtle fragrance, can't stand some flowers that a strong smell, like painted as a woman, too vulgar to be endured in a domineering.Kind of elegant and pure fragrance alone is my best love, like a small woman taste, elegant and subtle, depicted with a touch of fragrance.
!Like the color of light, the light purple, light pink, light blue, light green.Has people to pity also cherish the feeling.Don't like too much publicity color, like a person's personality, like the stand aloof from worldly success.
Like the hazy feeling, dreamy , want to tell you.Like the subtle appreciation, so happy or sad poems, articles, or speak in excitement emotion or the side of the text, they will often let us forget yourself where, in the romantic themes, be immersed in love, happy with their happiness, sadness their sorrow , will leave their troubles gradually forgotten.
Let this a hint to accompany me forever, no matter what the outside groundless talk, tempestuous waves.Whatever the world changed.So forever living in peace, in peace work, light person, don't hope Liufang colour, don't expect yanye away, give life to a calm, to the life of a real, give yourself a grateful, to others a tolerance.

After 15 will eat snacks

  People who love to eat zero must have a look this article , oh.Snacks to eat properly will benefit the health of body, the following fifteen after dinner to eat some healthy snacks!   1 sunflower seeds Can beauty.
Sunflower seeds contain protein, fat, vitamins and minerals, which is particularly rich in linoleic acid content.Linoleic acid helps to maintain the delicate skin , prevent dry skin and melanin.  2 peanut Can prevent the skin disease.
Peanut is rich in vitamin B2, it is our country dweller weekday meals is the lack of vitamins.Therefore intends to eat some peanuts, can not only supplement the daily dietary vitamin B2 deficiency, but also contribute to the prevention of cleft lip, eye redness itching, seborrheic dermatitis and other diseases     3 walnut Can show a.
Walnut is rich in auxin, make a strong nail is not easy to crack and walnut is rich in plant protein, can promote the growth of nails.Often eat walnuts, contribute to the nail show toughness.   4 jujube Prevention of scurvy.
Date in the vitamin C content is very rich, be nutritionists called "live vitamin C pill".If a lack of vitamin C in the diet, we will feel tired and fatigue, and even produce scurvy.  5 cheese Fixed gear.
The cheese is calcium "bonanza", can make the teeth stronger.Nutritionists indicated through research , an adult eat 150 grams of cheese, contribute to reach the old teeth not old target.  6 Fig Promote blood circulation.
Figs contain an aspirin-like chemicals.Can dilute the blood, increase blood flow, so that the brain blood supply full   7 pumpkin seeds and nuts Polyunsaturated fatty acid, carotenoid, peroxide and enzymes and other substances, appropriate food to ensure that blood flow to the brain, is one's face glowing with health, be in fine fig   8 toffee Sugar, calcium, eating properly can add cerebral energy, God is refreshing, moisturizing skin.
  9 chocolate Make one's mood and beauty effect , can produce such as be concerned with love and romance as in vivo reactive substances.  10 sesame paste Have hair, hair, blood work, eat can prevent white hair , hair loss disease, a raven-haired beauty   11.
A Qi, blood, Zhiyi Yuet yan.But attention should be paid to health.  12 MINT To wet your throat, halitosis , anger, God is clear throat.  13 oranges, oranges, apples and other fruits Rich in vitamin C, can slow or block the synthesis of melanin, whiten the skin, is alkaline food, can cause the blood to maintain a neutral or weakly alkaline, and fitness, beauty role.
  14 dried beef, grilled fillet Rich in protein, iron, zinc, proper diet is the skin rosy.  15 milk beverage Containing 1/3 milk, sometimes also fortified with vitamins and trace elements, is a nutritious drink.

[is] beverage bottle bottom deadly secret for you please rea

I go to the supermarket put all beverage bottle bottom all over, only the vat of farmer spring opaque barrel is written 2, other no matter how beautiful the bottle all is 1, for everybody's health, I especially reprinted this article, hope you are reproduced , let more people know the dangers , we can live a healthy life !The UAE is a twelve years old girl, for sixteen consecutive months with a bottle of mineral water, she got cancer.
The bottle contains a PET called the plastic material, with a safe, if you are frugal or convenient and repeated use, have carcinogenic crisis.Mineral water bottle bottom has an arrow with the triangle, the triangle has a number.
  general mineral water bottle, the bottom label 1   farmer spring 4 liter, the bottom label 2   tea plastic thermal cup, the bottom label 5   PET polyethylene terephthalate common mineral water bottles, bottles for carbonated beverages.
Heat resistance to 70 ℃ easy deformation, are harmful to human body material melt out.1 plastic products for 10 months after release, possible carcinogen DEHP.Can not be placed in car sun; not installed wine, oil and other substance   HDPE high density polyethylene common white bottles , cleaning supplies, bath products.
Don't be used as a cup, or used as a storage container for other items.Cleaning is not thorough, don't recycle.  PVC PVC common raincoat, building materials, plastic film, plastic boxes.Plasticity is good, price is cheap, it is commonly used, can heat 81 ℃.
Temperature easy bad substances, has rarely been used for food packaging.Difficult to easy cleaning residue, don't recycle.If installed drinks don't buy.  PE polyethylene common cling film, plastic film.
High temperature harmful substances, toxic compounds with food into the body, may cause breast cancer, neonatal birth defects and other diseases.Cling film don't come into the microwave oven.  PP polypropylene bottles , yogurt, common milk bottle of juice beverage bottle, a microwave oven box.
High melting point is 167 ℃, is the only one who can put into microwave oven plastic box, can be repeatedly used after careful cleaning.Need to pay attention to , some microwave lunch box, a box body with 5 PP manufacturing, but cover but in 1 PE, because PE is not affected by high temperature, so it can not and the box body are put into microwave oven.
  PS polystyrene common bowls of instant noodle box, food box.Can't be put in a microwave oven, so as to avoid high temperature and release chemicals.The acid loading (such as orange juice), alkaline substances, can decompose carcinogenic substances.
Avoid fast food box packaged hot food.Don't use microwave oven to cook instant noodles in bowl.  PC other common bottle, space cup, bottle.Department stores such as gifts to the glass material used.
It is easy to release toxic substances of bisphenol A, is harmful to the human body.Do not use when heating, not under the sun.My happiness is I hope everyone healthy and happy not to forget to share with

Bill Gates's ten words, absolutely let you change my life

1 life is unfair.Do not you want to transform it , and can only adapt to it.(because you can do it).2 the world won't care about your self-esteem, people see only what you have done.Before you have success, not too much emphasis on self-esteem.
(because you have more emphasis on self-esteem, the more unfavorable to you).3 you just graduated from high school, usually does not become CEO, until you get the CEO job in hand so far.(until this time, people will not mind if you just graduated from high school).
4 if you mess up, do not complain, you can only learn in silence.(you have to cheer up quietly , rises spiritedly).    5 you should know: before you , your parents do not like so "boring".You should think of, this is that they pay you in order to support the huge price.
(you never want to Thanksgiving and honor them , is the hard truth).6 in the school, your first few test is not that important, but into the community is not.No matter where you go, you have to be graded.
(social, the company should be ranked second, is a common thing, courage to face competition.).7 school holidays, the company is not working , you almost can not rest, could easily have been very few holidays.
(or your occupation career is backward, and even let you always behind).8 in the school, the teacher will help you learn , not to the company.If you think your teacher is very strict, that is you do not have to work into the company.
Because, if your company is not severe, you'll lose your job.(you must clearly understand that: the company more than the school should be strict with themselves.).9 people like to watch TV, but you do not see, it is not your life.
As long as the company's work, you are too busy to watch TV play.(we advise you not to look at, or you go watch TV series, and can eat with appetite, then you will lose the qualified success).10 never criticize others behind the scenes, especially not criticize your boss ignorance, mean and incompetent.

Not to scold!This bitch

A rag man accidentally cut a young woman in jeans, because no other requirements 50 yuan of compensation, the old man kneel down ten times.    the old man hands only 8 yuan 4 hair.        this is the daughter and her mother's photo, carved out of a mold face: when the reporter arrived at higher education press No.
15 street, a middle-aged woman of eider down wear gray is pushing a tattered clothes the old man, mouth shouting: "to lose money !"Hundreds of people gathered around.    standing beside a 20 year old woman, blue jeans legs was slashed a hole two or three cm long.
The old man was pushed tears kept pleading, hands holding a stack of banknotes , a total of 8 yuan and 4 minutes.    "don't break a small opening, as for such difficult people."Look down on people, people have to persuade "be lenient wherever it is possible".
Woman to speak , middle-aged women without a care , determined to make the old man out of pocket.        facing "huge" compensation for the elderly knees: reportedly, then the higher education press and go to the nearby intersection, just the old man riding a tricycle car turning, wire will young woman has a small mouth incident pants.
Her mother asked her old compensate 50 yuan.            in desperation, the old man "splash" kneel down, not to each other without any reaction, old person kneels down continuously ten times.
    the decline of the masses in the nearby mansion when angered, Mr. Wu security angrily say: "old man treated such an, they were really that's going too far."Then, he will pocket 23 yuan money in old man hand.
    journalists trying to interview the mother and daughter, the middle-aged woman said: "ignore her."        passers-by for elderly people in compensation for.    in the old man pleaded with the conciliation unsuccessful cases, the middle-aged woman dials 110 warnings finally.
About five fifty, Germany, the police station rushed to the scene to mediation, but the middle-aged woman thinks that the compensation money enough, refuse to compromise.Then, the crowd spontaneously took out the money, a yuan, two yuan, ten yuan.
.....The final round up 50 yuan.    again the old man kneel down to the crowd , and kept saying: "thank you, thank you."The middle-aged woman the money, took her daughter away without a word.    then the crowd expressed 50 yuan compensation results on the old unfair.
Police also said the helpless, saying it is a civil dispute, they can only act as a mediator role.        also is a person, why to trample on the dignity of others???                then, read have all given me to!What forum blog !To turn away, I do not believe, this opinion has not given them governs!Let more people pay attention to this matter!I am here for the old man thank you ah!!!    see did not turn: please don't come to my space, I have such a friend.

Where 4xi8g^ ^ Taobao internal staff to buy things(^ ^) rea

If you have online shopping experience, you must know the taobao , you know this site can enter taobao home, but you can't know taobao and various internal employee shopping channel; for example: authentic shopping channel, from here to enter all taobao.
com quality businesses, don't worry deceived bought fake taobao promotion; channel, looking for promotional merchandise from entering the right;... - 1 [] , taobao promotion entrance - looking for promotional specials, from the entrance on the.
- 2 [], taobao authentic mall entrance - from here into all taobao quality businesses, no longer worry deceived purchased a fake.- 3 [], taobao Shop Street entrance - taobao industry outstanding shop Top10 charts, data update everyday.
From here to enter, find good shops too easy.- 4 [], taobao brand library entrance by the well-known brands of classification, for example you want to find Nokia brand related products, access from here can easily find the brand high-quality seller.
- 5 [], taobao billboard entrance - buyers search the most commodities, are most concerned about the brand, sales of the largest commodity, attention index, a week hotspot information, as in Taobao billboard [].
- 6, [] women sale entrance - if you want to buy a dress goods, can access from here.- 7, [beauty] entrance - if you want to buy beauty products, access from here.- 8, [] shoes packets jewelry entrance - if you want to buy shoes bags jewelry commodity , please access from here.
[] - 9, Taiwan fashion entrance - all from the motherland treasure island Taiwan fashion apparel, women may pay attention to.- 10, [food] taobao entrance - women are the best place to Amoy delicious snacks.
Snack foods specialty / nutritional food / drink tea - 11 , [taobao Mens] entrance - if you want to buy men's goods, can access from here.[] - 12, home life entrance - if you want to buy home life commodities, please click here to enter.
Home daily / Creative Home Furnishing / bedding cushion / curtain / cloth / kitchen / bathroom nursing / furniture / crafts / cross stitch, as in [13] - home life, [] digital mobile phone entrance - if you prepare the best digital goods, please access from here.
Computer / notebook / brand mobile phone /MP3/MP44 / copycat mobile phone / digital camera / camcorder / Accessories / storage / supplies, as in [] - 14, digital mobile phone Taobao [] - Electric City entrance brand appliances, formal invoices, taobao.
com and Jingdong Mall, new competition such as the new weapons.- 15, [] a mall entrance - have everything that one expects to find, all price sale goods, buy cheap MMGG people can go to have a look oh.
- 16 , [] featured quality shop entrance - taobao recommended low-cost authentic good shops, access from here , can be assured to buy oh.- Oh, that, my friend told me not to tell outsiders (I think never mind, taobao.

[move] a fool for love, this is love!After the tears have be

The townis a fool ,not born that ,at the age of 5 in a gas poisoningincident, only he survived, and he always sleeping father tried last strength to push him to the door and let go ,from then on ,he would just silly smile ,no pipe is happy or sad ,is said to have suffered a brain injury .
A fool and a beautiful mother and sister ,he always asks his mother ,his father go .. ,his mother told him :his father died ,he became a star to heaven, in heaven watching us .For every night, lying in the Yard Lawn looking at the stars, look side silly laugh .
.. ..A fool when I was 11 years old ,love his mother because nephropathy is dead, dying to tell the fool to take good care of his sister ,and his sister is 6 years old .A fool just silly smile ,every night will be to look at the stars, he said that the stars in the sky one more ,that is his mother ,next to his father .
With the help of the fool ,set up a simple fast food stalls ,sandwiches ,stalls from sister school is not far .A fool at home never in my sister ,he hated because of her sister ,sister mind such a idiot brother ,but he likes lying in the doorway watching sister sister school ,each sister when he was found ,he like the children do something wrong hide ,then silly smile ,do not know is happy or sad .
Fool every morning up very early to sister do after breakfast to fast food stand up work .The only hobby is watching the stars at night ...A skillful ,sandwich like restaurants ,school teachers and students love to his stand to buy breakfast ,but do not know who the fool is a beautiful sister in the school ,because of her sister mind if people know is her brother ,fool just silly smile ,regardless of happy or sad .
Fool work very hard ,but he never spent money ,who do not know him so desperate to earn money what .Fool work often hands ,feet shoes is also often lack a ,sister will say :cut vegetables also hurt hand ,shoes will be lost, do not put your own lost !It was in fact a fool !Fools listen or silly smile ,don sad .
.Fool home every night before bed will be in a small notebook and write a few words ,curious to see his sister ,a fool always not to look to her, finished hid ,sister tried several times but failed to find .
.Finally don talk him in writing what a fool at the age of 17 ,when sister has been on the junior high school ,a booth also moved to a sister school not far place ,sold the breakfast every day in the school ,walk around ,is always wearing a shabby and dirty clothes ,the shoes are always one less only ,but when the work will with an air of importance put on aprons ,still just silly smile .
One day, in the booth since sell breakfast is waiting to hear the two female students about his sister ,said her morning to class after his face is not good, severe back pain .Fool heard for a moment, then called my sister ,throwing down his job to run to the school ,so he shouted to sister ,across the school janitor and teachers classroom block to sister ,sister to see on the desk ,looked wax yellow ,cold sweat, fool without the silly smile ,the face was anxious ,called my sister back sister will go to hospitals .
He met school teacher asked him :what are you doing ?She quickly put down !Fools because of anger :her red face ...Is my sister ,my ..Is her brother .Fool a road would repeat this phrase back his sister went to school near the hospital ,school teachers and students are very surprised, because have never heard of her brother .
.Fool in the ward door looked at her ,she woke up ,and fools have outside the ward stayed 3 days3 nights.That gave her doctor told her :do not worry ,your medical expenses you brother already all ready .
Sister difficult looked up outside the idiot brother ,eyes up some questions .A fool then resumed normal ,silly to his sister ,but dare not enter .The doctor said to his sister ,his early on to fool stalls to buy breakfast ,he know has been working very hard ,also know never spend money ,have struggled to understand the fool to earn so much money to do ,until today, he finally came to understand .
Because the fool behind sister find him shouting :mother ..This is dead ...For you ..Save the younger sister ..Yes, I am. Don sister die !The original fool mother alive told the fool, his sister also have very serious disease ,he must take good care of my sister .
...The doctor told my sister she needed a kidney transplant ,a kidney transplant cost his idiot brother has enough to pay ,but haven kidney .The doctor told my sister for a fool knows her sister disease in need of kidney transplant when he cried ,said to him .
..Yes, I am. I was her ..Brother ,but the results is a fool kidney was not right, fool knows the result ,looked very depressed ,has said :I am ..Her brother ah .That fool you :I ,my kidney did not change for sister fool still in the ward entrance and looked at my sister ,silly smile .
This sister had tears watching out of the door ,who had always made her feel shame stupid brother ,with a weak voice said to him :you stand at the door, what to do ,how to do not come in .
Fool for a while ,timidly say: i ...May I come in? Sister tears smiled and nodded .Fool sister back to come to bed ,my sister let ask him why his hands behind his back ,and insisted on his hands ,a fool will hand out, hand was bandaged ,shoes also has only one ,that is to take my sister to the hospital to be blown on hand Hang Road ,shoes were lost a .
Sister also like before say :how so stupid ah ,hand was hurt ,the shoes will be lost !Just say this of his time ,but now my eyes are full of tenderness and pain ...This is he a fool after first in her sister to go into her room .
.Time passed ,sister of the disease is serious with each passing day ,from time to time lapsed into a coma ...In enthusiastic doctors unremitting efforts ,the right kidney was finally found ,the operation was a success ,sister finally from the hands of death was saved ,but when she woke up without seeing a familiar silly smile .
..The doctor told her ,her brother in order to pay her medical expenses ,to a very far place to work, and she made a full recovery to come to take her home ,called her mind restored ..Sister every few days are recycled to a letter writing the crooked letter ,that is her fool give her brother to write ,is very simple and is the same :I ,hello to recuperate .
..Discharged on the day ,fool did not come to the hospital to meet my sister ,sister received only the doctor gave her a lovely teddy bear ,the teddy bear feet even with a little bit of blood .
..The doctor told her ,because fools delivery costs only enough to give her kidney transplant ,so long time hospitalization costs a lot, the fool in order to give her to pay the hospital ,every day except breakfast to sell, but also to look for other work ,so long as can earn it even manure to do the .
The doctor in the fool to come to the hospital to see sister time to find the good news source fool ,he is still a silly smile ,he is very polite to doctor bowed ,and the doctor said :i .
.To sister ..Buy a gift ..And so on ..Younger sister. Wake up ..Send her a fool and dragged his exhausted body ,happy to go to the store to buy a snow white teddy bear ...Maybe too tired one He went back to the hospital ,the road crossed the road by a speeding car bumped to fly ,to the hospital when already coma ,but hands still catch dress teddy bear bags ,blood down hand drops to teddy bear feet .
..Leaving said to the doctor :bear ...Give ..Sister ,then silly smile leave, also do not know he is happy or sad ....The doctor told my sister ,who is he imitates the fool handwriting ,he said he did not want to let you know that there was no rehabilitation when he has not been in the news ,the doctor said he wanted to help the fool fulfill his wishes ,so wrote these letters .
..Sister sat holding a white teddy bear ,so no noise ,she silently back home was very poor ,but very clean neat ,especially in her sister ,than when she was at the house also is neat ,furniture surface has been covered with a thin layer of dust ,desk is a potted flower, flowers very bright, in the flower pot next to a beautiful card ,facial has rows of crooked words :welcome to my sister home !Fool knows her sister will recover soon when he was ready to meet my sister home !Just at this time, she also did not listen to that silly laughter !My sister came to a room ,in order to fool things discovered she had always wanted to see the little book that book is left with a sandwich taste ,it is the fool left crooked writing :.
.. ... ... ... ... ... My sister likes to sleep late ,the early time to light ,don her sister morning don to eat sandwiches, likes to eat instant noodles ,to give her to go back to work younger sister doesn me into her room ,don me too close to her ,without her consent not to get into her room sister doesn others to know that I am her brother ,absolutely let her classmates know that I was her brother sister is not in good health ,but never let her know she was like a mother to give her sister disease I save .
.. ... Sister disease can finally cured sister hold a little book crying since then ,sister every night, like a fool like before ,like lying in the yard lawn and watch the stars ,but the stars was a fool ,that is her brother ,next to his father and mother ,they in the sky with her .
...relationresultWritelog is not easy to want to read ,please leave your footprints ,which afraid is an expression !Although I can not back to step one one !relationresultBut I will beupdated every day log !And all the messages I will see !Leave your message !Thank you.
________________________________________________________________________ master recommended : after the reproduced to your space, every reprint several diary you can increase the popularity
, relationresultMorewelcome to crush Mo Xiaomei QQ:295608 to introduce your friendshope that friends can be happy always ,more great articles ,music ,please add to Mo Xiaomei QQ:295608 spaceto

Surgical operation

1shockcommon first-aid measures , relationresultAnswer: 1,on trauma hemorrhage patients ,to take immediate measures to control hemorrhage .In 2 ,keeping respiratory tract unobstructed ,take the shock position 4,3other:warm ,minimize the move ,fracture of provisional fixed ,when necessary the use of analgesic drugs .
relationresult2shockpatients condition observation points , relationresultAnswer:A ,supplement blood volume : personal care 2 ,establishment of intravenous access 1-2 3,reasonable ,accurate record 24 hoursrehydration 4out of5,close observation of disease conditions ,the 15-30minuterecording of vital signs ,consciousness ,complexion ,skin temperature ,acral pupil .
Urine volume more than 30ML/ hours ,prompting shock .Two :1,given the shock position ,head elevation 20-30 degree,lower limb elevation of 15to 20 degrees.2 ,the use of anti shock trousers 3,the use of vasoactive drugs .
Three :increased myocardial function 4 :keeping the respiratory tract unobstructed .Five :prevention of infection .Six :regulation of body temperature ,warm or cool .Seven :prevention of accidental injury .
relationresultThe 3patient controlled analgesiapatient nursing points , relationresultAnswer: 1 ,strengthen the monitoring of vital signs ,especially SPO2 monitoring.In 2 patients,sleepiness ,strengthen monitoring respiration .
3 ,maintain respiratory tract unobstructed ,choose a comfortable posture ,respiratory depression ,immediate treatment .In 4 ,urinary retention catheterization 5,nausea ,and vomiting after intramuscular injection of metoclopramide ,reduce gastric retention .
relationresult4systemic infectiontreatment principle , relationresultAnswer: 1,treating the primary focus of infection ,control the source of infection and systemic support therapy .2 ,without obtaining the culture results ,according to the character of lesions ,timely ,effective combination with adequate doses of antibiotics ,according to the bacterial culture and drug sensitivity test results ,to adjust the effective antibiotics .
For fungal sepsis ,try to disable the broad-spectrum antibiotic ,effective ,targeted antibiotics ,and use of systemic antifungal agents .relationresult5tetanus treatmentprinciples? , relationresultAnswer: 1,clear the source of toxicant ,radical debridement of necrotic tissue and foreign bodies ,3% hydrogen peroxide solutionafter cleaning ,sufficient drainage .
In 2 ,and free toxin ,injection of tetanus antitoxin .3 ,control and relieving spasm ,enable the patient to quiet ,to reduce unnecessary stimulation .4 ,prevention of complications ,maintain respiratory tract unobstructed ,support therapy and use of antibiotics .
relationresultThe 7most criticalcomplications after operation in patients with hyperthyroidism is what ?What should I do ?relationresultAnswer: 1,postoperative respiratory difficulties and asphyxia .
2 ,immediate bedside rescue ,timely cut suture ,open incision ,removal of hematoma .If breathing is difficult without improvement ,tracheotomy .Get better to the operation room ,further examination ,hemostasis and other processing .
Laryngeal edema ,available m 30mg intravenous drip ,no good one puncture or incision of trachea .relationresult8subtotal thyroidectomycomplication which to have ?relationresultAnswer: 1,postoperative respiratory difficulties and asphyxia in 2 recurrent laryngeal nerveinjury in 3 ,superior laryngeal nerve injury in 4 ,twitch 5 ,thyroid crisis .
relationresult9after radical resection of breast cancerpatients for health education , relationresultAnswer: 1,activity :soon after the procedure avoids the use of the paretic upper limb handling ,lifting heavy objects .
Contraception :2,5 years after surgeryto avoid pregnancy .In 3 ,chemotherapy or radiotherapy : a periodic review of blood, such as a white blood cell count is less than 4 x 109,,should be suspended .
Pay attention to the protection of the skin ,appear to timely treatment of radioactive dermatitis .In 4 ,milk or prosthesis :discharge can be worn without the weight of the milk ,cure available at the rear weight of the milk ,3 months after radicalbreast reconstruction surgery ,a tumor metastasis or mastitis ,prohibited the prosthesis implantation .
5 ,self examination :regular breast self-examination in the final menstrual 7-10 days after.relationresult10subphrenic abscessclinical performance? , relationresultAnswer: 1,systemic symptoms :fever ,rapid pulse ,thick greasy tongue fur ,onset of fatigue ,anorexia ,weight loss ,night sweats ,leukocyte and neutrophil percentage increase .
2 ,abscess part can be durative blunt painful ,deep breathing is aggravating ,often located near the midline of the rib under xiphoid .relationresult11theprevention of intra-abdominal pressure measure , relationresultAnswer: 1,maintain emotional stability 2to ensure adequaterest ,avoid fatigue and a heavy physical activity 3,pay attention to keep warm ,to prevent the cold caused by coughing ,coughing when available hand to press the abdomen in 4 ,to maintain smooth stool ,constipation, confusion of laxatives ,eat high fiber food ,drinking water, to avoid forced defecation .
5 ,avoid valsalva .relationresult12 brieflywhat is dumping syndrome , relationresultAnswer:a large amount of hypertonic food quickly into the duodenum or jejunum ,large amounts of extracellular fluid is transferred to the intestinal lumen, circulating blood volume reduced suddenly, intestinal irritation after the release of a variety of gastrointestinal hormones ,such as vasoactive peptide ,neurotensin ,cause a series of vasomotor function disorder .
relationresult13patients with colon carcinomapreoperative for bowel preparation ?relationresultAnswer:now cleaning intestinal tract using whole gut lavage :in the preoperative 12-14 hoursstart taking 37 degreesisotonic balanced electrolyte solution ,forming capacity of diarrhea ,achieve bowel cleaning purposes, the total not less than 6000 .
Also available oral 5%-10%mannitol ,to make effective patient diarrhea ,to clean the role of the gut ,but this method in intraoperative disable electric knife .Frail ,heart and kidney organ disorders and ileus is not selected .
relationresultIn 14patients with primary liver cancerprevention measures of preoperative hepatic encephalopathy , relationresultAnswer: 1,strengthen the monitoring of vital signs and state of consciousness was observed, there appears to be a personality changes in behavior ,such as euphoria ,apathy or asterixis ,prodromal symptoms ,and notify physician .

About the next life I and you together

 &nbsp ;&nbsp ;&nbsp ;if has the next gerneration ,remember not to be too far away from me ,&nbsp ;&nbsp ;because I we have no chance to meet .&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;if you can find me before , remember not too early to marry someone else ,want to believe we will meet .
&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;if the next life we can meet ,remember to let you fall in love with me first ,so that you can forgive my ll self-wills.include good and bad .relationresultIf the next lifeis I love you ,remember to be more care about me ,to protect me.
Always put me in your heart, like this life I love the way you love me .&nbsp ;&nbsp ;&nbsp ;&nbsp ;relationresultIf Ican be your favorite person ,remember me to say a few more words I love you relationresultThis is becauselife you owe .
&nbsp ;&nbsp ;&nbsp ;&nbsp ;if the next life ,remember don ,Frank is the best explanation. For I will forgive you. , relationresultIfthe next life ,I will be for you to do what you like ,but you must remember to praise me.
Give me a kiss ,just as a small reward .&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;if the next life ,remember to take care of yourself ,because I worry about you the body. &nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;if the next life ,and I remember more words ,because I feared your cold.
, relationresultIfthe next life ,if you left me out in the cold, remember to allow me to get angry to you . Because I get angry to you ,also only in order to let you feel my existence. &nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;if the next life ,remember the promise ,I will do it .
Don like this in the lifetime ,so many empty promise to me. &nbsp ;&nbsp ;&nbsp ;&nbsp ;if to next lifetime ,we offer to happy. Everybody don .relationresultIfthe next life ,remember when I was very unhappy with me ,because my heart just want to tell you.
&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;if the next life ,remember don me sad. I can be happy ,because of you .&nbsp ;&nbsp ;if the next life ,I remember you told me you loved me ,believe what I said was true .
relationresultIfthe next life ,we still can ,remember before don too hurtful words . Because I still can too much damage. &nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;if the next life ,we still want to separate ,and I remember about good again next life .

A silly brother to my own sister this!Ha-ha.Adults only.

The townis a fool ,not born that ,at the age of 5 in a gas poisoningincident, only he survived, and he always sleeping father tried last strength to push him to the door and let go ,from then on ,he would just silly smile ,no pipe is happy or sad ,is said to have suffered a brain injury .
A fool and a beautiful mother and sister ,he always asks his mother ,his father go ,his mother told him :his father died ,he became a star to heaven, in heaven watching us .For every night, lying in the Yard Lawn looking at the stars, look side silly smile .
A fool when I was 11 years old ,love his mother because nephropathy is dead ,dying to tell the fool to take good care of his sister ,and his sister is 6 years old .A fool just silly smile ,every night will be to look at the stars, he said that the stars in the sky one more ,that is his mother ,next to his father .
With the help of the fool ,set up a simple fast food stalls ,sandwiches ,stalls from sister school is not far .A fool at home never in my sister ,he hated because of her sister ,sister mind such a idiot brother ,but he likes lying in the doorway watching sister sister school ,each sister when he was found ,he like the children do something wrong hide ,then silly smile ,do not know is happy or sad .
Fool every morning up very early to sister do after breakfast to fast food stand up work .The only hobby is watching the stars at night ...A skillful ,sandwich like restaurants ,school teachers and students love to his stand to buy breakfast ,but do not know who the fool is a beautiful sister in the school ,because of her sister mind if people know is her brother ,fool just silly smile ,regardless of happy or sad .
Fool work very hard ,but he never spent money ,who do not know him so desperate to earn money what .Fool work often hands ,feet shoes is also often lack a ,sister will say :cut vegetables also hurt hand ,shoes will be lost, do not put your own lost !It was in fact a fool !Fools listen or silly smile ,don sad .
.Fool home every night before bed will be in a small notebook and write a few words ,curious to see his sister ,a fool always not to look to her, finished hid ,sister tried several times but failed to find .
.Finally don talk him in writing what a fool at the age of 17 ,when sister has been on the junior high school ,a booth also moved to a sister school not far place ,sold the breakfast every day in the school ,walk around ,is always wearing a shabby and dirty clothes ,the shoes are always one less only ,but when the work will with an air of importance put on aprons ,still just silly smile .
One day, in the booth since sell breakfast is waiting to hear the two female students about his sister ,said her morning to class after his face is not good, severe back pain .Fool heard for a moment, then called my sister ,throwing down his job to run to the school ,so he shouted to sister ,across the school janitor and teachers classroom block to sister ,sister to see on the desk ,looked wax yellow ,cold sweat, fool without the silly smile ,the face was anxious ,called my sister back sister will go to hospitals .
He met school teacher asked him :what are you doing ?She quickly put down !Fools because of anger :her red face ...Is my sister ,my ..Is her brother .Fool a road would repeat this phrase back his sister went to school near the hospital ,school teachers and students are very surprised, because have never heard of her brother .
.Fool in the ward door looked at her ,she woke up ,and fools have outside the ward stayed 3 days3 nights.That gave her doctor told her :do not worry ,your medical expenses you brother already all ready .
Sister difficult looked up outside the idiot brother ,eyes up some questions .A fool then resumed normal ,silly to his sister ,but dare not enter .The doctor said to his sister ,his early on to fool stalls to buy breakfast ,he know has been working very hard ,also know never spend money ,have struggled to understand the fool to earn so much money to do ,until today, he finally came to understand .
Because the fool behind sister find him shouting :mother ..This is dead ...For you ..Save the younger sister ..Yes, I am. Don sister die !The original fool mother alive told the fool, his sister also have very serious disease ,he must take good care of my sister .
...The doctor told my sister she needed a kidney transplant ,a kidney transplant cost his idiot brother has enough to pay ,but haven kidney .The doctor told my sister for a fool knows her sister disease in need of kidney transplant when he cried ,said to him .
..Yes, I am. I was her ..Brother ,but the results is a fool kidney was not right, fool knows the result ,God is depressed ,has said :I am ..Her brother ah .That fool you :I ,my kidney did not change for sister fool still in the ward entrance and looked at my sister ,silly smile .
This sister had tears watching out of the door ,who had always made her feel shame stupid brother ,with a weak voice said to him :you stand at the door, what to do ,how to do not come in .
Fool for a while ,timidly say: i ...May I come in? Sister tears smiled and nodded .Fool sister back to come to bed ,my sister let ask him why his hands behind his back ,and insisted on his hands ,a fool will hand out, hand was bandaged ,shoes also has only one ,that is to take my sister to the hospital to be blown on hand Hang Road ,shoes were lost a .
Sister also like before say :how so stupid ah ,hand was hurt ,the shoes will be lost !Just say this of his time ,but now my eyes are full of tenderness and pain ...This is he a fool after first in her sister to go into her room .
.Time passed ,sister of the disease is serious with each passing day ,from time to time lapsed into a coma ...In enthusiastic doctors unremitting efforts ,the right kidney was finally found ,the operation was a success ,sister finally from the hands of death was saved ,but when she woke up without seeing a familiar silly smile .
..The doctor told her ,her brother in order to pay her medical expenses ,to a very far place to work, and she made a full recovery to come to take her home ,called her mind restored ..Sister every few days are recycled to a letter writing the crooked letter ,that is her fool give her brother to write ,is very simple and is the same :I ,hello to recuperate .
..Discharged on the day ,fool did not come to the hospital to meet my sister ,sister received only the doctor gave her a lovely teddy bear ,the teddy bear feet even with a little bit of blood .
..The doctor told her ,because fools delivery costs only enough to give her kidney transplant ,so long time hospitalization costs a lot, the fool in order to give her to pay the hospital ,every day except breakfast to sell, but also to look for other work ,so long as can earn it even manure to do the .
The doctor in the fool to come to the hospital to see sister time to find the good news source fool ,he is still a silly smile ,he is very polite to doctor bowed ,and the doctor said :i .
.To sister ..Buy a gift ..And so on ..Younger sister. Wake up ..Send her a fool and dragged his exhausted body ,happy to go to the store to buy a snow white teddy bear ...Maybe too tired one He went back to the hospital ,the road crossed the road by a speeding car bumped to fly ,to the hospital when already coma ,but hands still catch dress teddy bear bags ,blood down hand drops to teddy bear feet .
..Leaving said to the doctor :bear ...Give ..Sister ,then silly smile leave, also do not know he is happy or sad ....The doctor told my sister ,who is he imitates the fool handwriting ,he said he did not want to let you know that there was no rehabilitation when he has not been in the news ,the doctor said he wanted to help the fool fulfill his wishes ,so wrote these letters .
..Sister sat holding a white teddy bear ,so no noise ,she silently back home was very poor ,but very clean neat ,especially in her sister ,than when she was at the house also is neat ,furniture surface has been covered with a thin layer of dust ,desk is a potted flower, flowers very bright, in the flower pot next to a beautiful card ,facial has rows of crooked words :welcome to my sister home !Fool knows her sister will recover soon when he was ready to meet my sister home !Just at this time, she also did not listen to that silly laughter !My sister came to a room ,in order to fool things discovered she had always wanted to see the little book that book is left with a sandwich taste ,it is the fool left crooked writing :.
.. ... ... ... ... ... My sister likes to sleep late ,the early time to light ,don her sister morning don to eat sandwiches, likes to eat instant noodles ,to give her to go back to work younger sister doesn me into her room ,don me too close to her ,without her consent not to get into her room sister doesn others to know that I am her brother ,absolutely let her classmates know that I was her brother sister is not in good health ,but never let her know she was like a mother to give her sister disease I save .
.. ... Sister disease can finally cured sister hold a little book crying since then ,sister every night, like a fool like before ,like lying in the yard lawn and watch the stars ,but the stars was a fool ,that is her brother ,next to his father and mother ,they in the sky with her .
...&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp

Chen Xiaoqiao for rag old mad hip-hop let your mouth shut

­ ­ ­ ­ beauty Chen Xiaoqiao candidates ­ continuous storms expected, let your mouth shut ­ Received tattered old crazy dance   ­          

2011 of the most awesome's funny sentence ~ ~ death is not t

Most peopleon the Internet, books and periodicals have seen many classic quotations ?However ,this classic you read ?Believe me ,you will smile !Not afraid of dead speed to onlookers !relationresult relationresult &nbsp ;&nbsp ;1 yourcrap how Hunan TV ad !&nbsp ;&nbsp ;&nbsp ;2I want tolean into a flash of lightning lit up all the wretched fatso .
relationresult &nbsp ;&nbsp ;3 did notremove the lovers will break only hard mistress .relationresult &nbsp ;&nbsp ;4hairgone without a trace ,dandruff more outstanding .relationresult &nbsp ;&nbsp ;5when the mood is depressedwith the tooth brush .
relationresult &nbsp ;&nbsp ;6 cucumberis shot ,the life lies in hi !relationresult &nbsp ;&nbsp ;7 mindis the daily necessities ,not ornaments .relationresult &nbsp ;&nbsp ;8tattoois not necessarily a rogue ,he may be Yue Fei .
relationresult relationresult &nbsp ;&nbsp ;9world of the most painfulis not between life and death but will test the others are review and I preview .relationresult &nbsp ;&nbsp ;10your smilethan the sun that Tuo shit is brilliant .
relationresult &nbsp ;&nbsp ;11two if a man on thelong ,eyeball is romantic .relationresult &nbsp ;&nbsp ;12. My heartis not a bus ,not have the vacancy you sit down .relationresult &nbsp ;&nbsp ;13to accompany me tocount the stars IQ points on the number of the moon !relationresult &nbsp ;&nbsp ;14MermaidI love you only you can split .
relationresult &nbsp ;&nbsp ;15my ears are nottrash don throw anything here .relationresult &nbsp ;&nbsp ;16 sisterhad died, to burn a brother sister !relationresult &nbsp ;&nbsp ;17you have abrother called diving play called latent .
relationresult &nbsp ;&nbsp ;18of the most uselessthing is salary ,looked angry ,wipe my ass too thin .relationresult &nbsp ;&nbsp ;19medicinemedicine pseudotumor cerebri, wine not worried .
relationresult &nbsp ;&nbsp ;20sorry,signature is too personal ,cause the system can not be displayed ,please refresh .relationresult &nbsp ;&nbsp ;21lifeis like shit ,we dung beetles as intoxicated .
relationresult &nbsp ;&nbsp ;22the lastslobber left the comrades need !Put the bottle of orange to me .relationresult &nbsp ;&nbsp ;23others,to do when the mask than reality ,more beautiful .
relationresult &nbsp ;&nbsp ;24 Iwant to be a lady is living his aging mother into a slut .relationresult &nbsp ;&nbsp ;25thick skinnedpeople most a word that often says my question to you is not thin a .
relationresult &nbsp ;&nbsp ;26If thecharacter is what ?Is to constantly strive for little people .relationresult &nbsp ;&nbsp ;27for menwith milk is the mother .To a woman the rich is Lang .
relationresult relationresult &nbsp ;&nbsp ;28 look atyour photos I have special impulse is to P into black and white hanging on the wall !relationresult &nbsp ;&nbsp ;29q-how can worry aboutlike a sheaf of snowflake beer .
relationresult &nbsp ;&nbsp ;30.With light body health ,he gambled light rolling on all cylinders !relationresult &nbsp ;&nbsp ;31 May: the sky is the sun and the moon ,sorry I am not native !relationresult &nbsp ;&nbsp ;32refused toexpress reason often is we are not a world of man .
I TM is the Mars ?With earth and man ?relationresult &nbsp ;&nbsp ;33I now strive tomake money in order to buy 2012plane tickets.relationresult &nbsp ;&nbsp ;34 donturn me on ,because I here with caller ID .
relationresult &nbsp ;&nbsp ;35 do youthink people call you free your beauty ?Know the Internet is disposable utensils ?relationresult &nbsp ;&nbsp ;36signaturechanged every day not the money anyway .
relationresult &nbsp ;&nbsp ;37 boss,a bowl of tears .relationresult &nbsp ;&nbsp ;38 Iwith Cupid chases you wearing a bulletproof vest to fly .relationresult relationresult &nbsp ;&nbsp ;39others,to do when the mask than reality ,more beautiful .
relationresult &nbsp ;&nbsp ;the 40 death is not terrible ,terrible is you can die .relationresult &nbsp ;&nbsp ;41grandfather said:Jay Chou monk monk because he sure is a good read by the sweet !relationresult &nbsp ;&nbsp ;42 springmagician essential props :Qing Dong !relationresult &nbsp ;&nbsp ;43life isdisturbed ,no exact lyrics ,but be struck with fright .
relationresult relationresult &nbsp ;&nbsp ;44or 10086good to me,I sent him a message ,he gave me 3.&nbsp ;&nbsp ;&nbsp ;45mistress.Because I make it wonderful life to broken .
relationresult &nbsp ;&nbsp ;46 salaryas great aunt ,once a month ,a week or so gone .relationresult &nbsp ;&nbsp ;each of the 47 girlswant to have a eight award ,but not everyone can be a riverside .
relationresult &nbsp ;&nbsp ;48man,man ,how I wish you are good .relationresult &nbsp ;&nbsp ;49 mygood character and no worries .relationresult &nbsp ;&nbsp ;50sundownersheartbroken people dancing career .
relationresult relationresult &nbsp ;&nbsp ;must admit ,these errors can make people laugh me !Life is like a mirror ,you smile to him ,he will smile to you !Share the happiness to people around you .

Excel will move the table 35 cheats school

 perhaps you have accomplished in Excel over hundreds of financial statements ,you may have to use Excel to realize the complicated calculation of thousands of times ,maybe you think Excel is just so so, even without new idea .
But we repeated the handy method of using only Excel all the one percent skills .The topic from a Excel some little-known techniques of about Excel ,enjoy the different customs .&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;one ,for different types of data with different colors displayed on the pay table ,if you want greater than or equal to 2000 yuantotal wages to red display ,greater than or equal to 1500 yuanof the total wages for the shows ,below 1000 yuan to total wages Brown display ,other black display ,so we can set .
1 open the payroll workbook ,select the total wages in the column ,performing format conditional formatting commands ,open conditional formatting dialog box .Click the drop-down button second to the right of the box ,select the greater than or equal to option ,at the back of the box 2000input values.
Click the format open button ,the Format Cells dialog box ,the font is set to red .2 press the button ,and modeled after the above operations for the other conditions ( greater than or equal to 1500 ,the font is blue ;less than 1000 ,the font is Brown ) .
The 3 set is complete,press the OK .Have a look the payroll ,salary amount data is it right? According to your requirements in different colors out of .&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;two ,the classification of the establishment of the drop-down list we often filled to enterprise name entered into the table ,in order to keep the name consistency ,using the data function to build a classification of filling a drop-down list .
1 in the Sheet2 ,the company name by category ( such as industry ,business ,individual businesses are input to different columns ,to establish a corporate name database .2 selectedA column ( industry of the column ) ,in the name column ,enter industry character ,press confirm .
According to the above, the B ,C ... ... The column named business ,individual enterprises ... ... The 3 switch to Sheet1, select input business class column ( such as C ) ,performing data validity open command ,data validity dialog box .
In the Settings tab, click allow drop-down button ,select sequence options ,sources in the following box ,enter industry ,business ,individual enterprises ... ... Sequence ( between elements of the English commas ) ,decided to quit .
Then select the required input company name column ( such as D ) ,then open the data dialog box ,select sequence option in the source box ,enter the equation: =INDIRECT ( C1 ),decided to quit .
4 selectedC column any cell (such as C4 ),click the drop-down button ,choose the corresponding business class in the cell .And then select the cell corresponding to the D column of cells ( such as D4 ),click the drop-down button ,can from the corresponding category of enterprise name list to select the name of the enterprise in the cell .
Note: later in print statements ,if do not need to print category column ,the column can be selected ,right click your mouse ,select hidden option ,the column is hidden .Three ,establish a common document menu in the menu bar to build a common document menu ,the commonly used workbook file add to them, at any time convenient call .
1 empty space on the toolbarright-click ,select custom options ,custom dialog box open .In command ,select categories below the new menu item ,then command below the new menu drag the menu bar .
According to change your selections button ,the pop-up menu box, enter a name ( such as common .) .2 below choose one ( such as insert option) ,on the right order the choice of a ( such as hyperlinks option) ,drag it to the new menu ( commonly used document ) ,and modeled after the above operations performed on it ( such as the named payroll etc.
) ,the establishment of the first workbook file list name .Repeat the above operation, more add a few document list name .3 selectedcommonly used document menu, a menu item ( such as payroll ,right mouse click ,in the pop-up menu ,choose assigned hyperlinks to open options ,Hyperlink dialog box open distribution .
By pressing the drop-down button ,navigate to the Workbook ( such as salary.Xls folder ,and select the workbook file .Repeat the above operation, the menu item and its corresponding workbook document links up .
In 4 after the need to open the common document menu in a workbook document, as long as the start menu ,click commonly used document in which the corresponding option .Note: Although we will hyperlinks option until the common document menu, but does not affect the insert menu hyperlinks menu item and the common Toolbar insert hyperlink button function .
Four ,making symbol toolbar in professional editing form, often need to import some special symbols ,in order to facilitate the input, we can create a belongs to own symbol toolbar .
1 Tools > macro to record new macro command ,open record new macro dialog box ,enter the name such as fuhao1 ??and macro security presence personal macro Workbook ,then identify start recording .
Select the recording Toolbar relative button ,then will need special symbol input into a cell ,and then click the recording of the stop on the toolbar ,complete macro recording .According to the above, recorded one one other special symbols in the input macro .
2 open the custom dialog box ,in the Toolbar ,click the new pop-up new toolbar dialog box ,enter the name -- symbol ,are identified, namely in the work area in a tool bar .Switch to command ,select categories below macro ,order below custom button drag symbol bar ( the number of special symbols on the drag a button ) .
3 select one ofa button ,modeled as second - first of them named .4 right-click anamed after the button ,in the ensuing pop-up menu ,choose assign option ,open assign dialog box ,select the appropriate macro ( such as fuhao1) ,decided to quit .
Repeat this step of the operation ,the button and the corresponding macro link up .The closure of 5 custom dialog box ,later can be used as ordinary toolbar ,the use of symbol toolbar ,cell to cell quickly enter professional symbols .
In five ,with visual manager save multiple print page some sheet ,often need to print wherein different regions, with visual manager . .1 open the need to print a sheet ,with the mouse in need not print row (or column ) marked on the tractor ,select them and right mouse click ,in the ensuing shortcut menu, choose the option hide ,will not need to print a row ( or column ) to hide .
2 view view manager command ,open the visual manager dialog box ,click add button ,pop-up add view dialog box ,enter a name ( such as report ) ,click button .3 will be hidden rows ( or columns ) is displayed ,and the operation is repeated, adding other print view .
In 4 after the need to print a form, open view manager ,select the need to print a form name ,click the show ,the sheet immediately according to the preset interface display, simple setting ,typesetting ,press the print button on the toolbar ,all on OK .
Six ,make data on-demand sort if you want the staff at the Department for sorting ,these departments of both information not according to the phonetic sequence ,not according to the stroke order ,how to do ?Can use custom sequence to sort .
1 format options command ,open the dialog box, enter the custom sequence label ,the input sequence below the input sector in the sorted sequence (such as organ ,fleet ,a workshop ,two workshops ,three workshop ,click add and OK button to exit .
2 selecteddepartments column in any one cell ,performing data sort command ,open the dialog box, click sorting options button ,the pop-up sort options dialog box ,click the drop-down button ,select just custom sequence ,two press button on the back, all the data in requirements for a sort .
&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;seven ,the data is completely hidden portions of the sheet cell content does not want to let visitors access ,had to hide it .
1 selectHide content cell (regional) ,performing format cells open command ,the Format Cells dialog in ,digital label classification below and select option ,and then the right below type enter ;;;( three English state the semicolon ) .
2 thenswitched to protect tab, select one of the hidden option ,click button to exit .3 the implementation of the to protect to protect sheet open command ,the protecting sheet dialog box ,set the password, OK .
After such settings ,the cell content is no longer displayed ,is to use Excel function also cannot make its appear transparent .Tip: in the protection label ,please do not remove locked in front of the check box in the V ,this can prevent others to delete your hidden data .
Eight ,in the English input method ,intelligent appeared in edited form, some cells to input English ,some cells to input Chinese ,repeatedly switching input method is not convenient ,why not set up ,lets the input method of intelligent adjustment ?Select input Chinese cell area ,implementation of the data effectiveness of open command ,data validity dialog box ,switch to the input mode label ,according to the mode drop-down button ,select open option, OK .
When selected to input Chinese range in any one cell, Chinese IME ( input method in the list of first Chinese input method ) is automatically opened ,when other cells, Chinese input method automatically closes .
Nine ,make automatic corrections input unified text you is it right? Often enter certain fixed text ,such as newspaper computer and trouble ?You look down .1 Tools > AutoCorrect open command ,automatic correction dialog box .
2 replacement in the box below to enter PCW ( or other characters ,PCW with a lowercase ) ,in the substituted for enter below newspaper computer ,then click add and OK .The 3 later if you need toinput the text PCW ,as long as the input character ?This can not consider PCW size ?,then confirm became .
In ten ,a custom Excel function Excel although abundant ,but did not meet our need .We can define a function ,to accomplish some particular operations .Below, we will from the definition of a calculation of trapezoid area function : 1 Tools > macro → VisualBasic editor menu ( or press the shortcuts ) ,open the Visual Basic editor window .
2 in the window,to perform insert module menu command ,insert a new module - module 1 .The 3 on the right side of thecode window enter the following code :Function V ( a ,B ,H ) V = h* ( a+b ) /2End Function 4 to close the window,a custom function .
After using the built-in function like using a custom function .Tip: use the above method to customize the function usually can only be used in the corresponding workbook .Eleven ,the header arranged under the picture for the sheet to add background ,is lined on the work table below ,can be only the lining in the header below ?1format sheet and background open command ,sheet background dialog box ,select as a background picture, press the button ,the picture is lined in the entire sheet below .
2 while holding down the Ctrl key,use the mouse without lining picture cell ( regional ) drag ,and select the cell ( regional ) .In 3 format Toolbar fill color to the right of the drop-down button ,in the subsequent palette ,select white .
After such settings ,leaving the cells lining the picture below ,the selected cell ( area ) below without lining pictures (in fact, is the picture is white cover ) .Tips ?Lining in the cell below is not support printing .
Twelve ,use a hyphen &amp ;to merge text if we want more content is merged into one column ,do not need to use function ,a small hyphen &amp ;you can use it .( this assumes that the B ,C ,D columns are merged into one column ) .
1 listed in the Dinserted behind the two column ( E ,F ) ,then D1 cell of theinput formula :=B1&amp ;C1&amp ;D1 .2 selected againD1 cell,with the fill handle the formula to the D column below the cell ,B ,C ,D column content is merged into the E column corresponding to the cell .
3 selectedE column ,performing copy ,and then select the F column ,performing editor ,paste commands ,open paste dialog box ,select one of the value options ,press the OK ,the E column content ( not formula) that is copied to the F column .
4 B,C ,D ,E column delete ,merge completed work .Tips :completed in first ,2 stepoperation ,combined effect has been achieved, but if the deletion of B ,C ,D column ,the formula error .
So for the third step operation ,will be converted to constant value formula .&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;generation ,often a friend asked how to print the results section ,many people have taken to record a macro or VBA method to achieve this ,for beginners there is a certain degree of difficulty .
From this consideration, I here is a function of the realization of the simple method .Here it is assumed that the students results stored in the Sheet1 tableA1 to G64cellarea, of which first behavioral problems, second behavioral subject name .
The 1 switch to an Sheet2 worksheet ,select cell A1 ,enter the formula :=IF ( MOD ( ROW ) ,=0 (3), ( 0MOD,IF ?ROW ( ) ,3(=1 ,sheet1 !A INDEX ( Sheet1 ū!$A:$G ,INT ( ( ( ROW ) /3 (+4 )) ,COLUMN ( +1 )) ) ) ) .
2 selected againA1 cell,with the fill handle the formula copied to B1 to G1 cell ;then again at the same time ,select A1 to G1range,with the fill handle the formula copied to A2 to G185cells.
So far ,the results section the basic shape, the following simple modification .3 adjustrow height and width ,and select A1 to G2range( first student achievement of area ) ,according to the format Toolbar frame drop-down button ,in the subsequent frame list, select all frame line option for the selected area ,add a border ( if not need to frame ,can not carry out this step and the following operation ) .
4 at the same time, select A1 to G3cellarea ,click on the common Toolbar format brush button ,and then press and hold the left mouse button ,drag from A4 G186cellarea ,for all the results section add a border .
Press the button ,then print out results .In fourteen ,Excel help you select the function to the function of processing data, often do not know what more appropriate use of function .Excel search function function can help you narrow the scope, choose appropriate function .
Implementation of the insert function command ,open the insert function dialog box ,in the search function in the box below the input requirements ( such as count ) ,and then click the go ,the system will immediately with count - related functions selected , and displayed in the function of the list box below in .
Combined with the view the corresponding help file ,can quickly determine the required functions .In fifteen ,while viewing a different sheet of cells within the data sometimes ,we compiled a work table ( Sheet1 ),need to see another sheet ( Sheet2 ,Sheet3 .
..... ) a cell contents, Excel can use the monitor function to achieve .Implementation of the view toolbar - Watch window open command ,the monitoring window ,click the add button ,start monitoring add watch dialog box ,use the mouse to select the cell needs to view ,and then click the add .
Repeat the operation ,add other point lookout .Later ,no matter in which the work table, just open the monitor ,you can view all monitored point within a cell data and related information .
In sixteen ,for the cell rapid picture frame in Excel 2002 previous versions,for the cell area to add frame is inconvenient to operate ,Excel 2002 thisfunction for a new development .Click the format Toolbar frame drop-down button ,on the pop-up drop-down list, choose drawing frame option ,or to perform view toolbar to border command ,launched the border toolbar .
Click the toolbar the left-most dropdown button ,select a style of the border ,and then in the need to add a border cell area of drag, can provide the corresponding cell area rapid drawing frame .
Tips : if the wrong frame ,never mind ,the selected Toolbar erasure frame button ,then the error frame dragging ,can remove the error frame .If need to draw a different color frame ,can according to the toolbar on the right side of the color line button on the pop-up palette ,select the color, then draw frame can be .
③ thiscan also function in the cell picture diagonal slash .&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;&nbsp ;seventeen ,control of cell specific input text length can you think of when you input cell is filled with four digits a two digit number ,or in the input text in the cell you have entered the digital time, Excel will automatically judge ,real-time analysis and display a warning ,that nice ah !To achieve this function ,Excel, is also not difficult .
For example, we put the cursor into a register year in the cell ,in order to enter the unity and the convenience of the calculation ,we hope that the year is a four digit to represent .So ,we can click data menu option .
In the Settings card validity conditions allow dropdown menu select text length .And then in the data dropdown menu select equal to ,and length .At the same time ,we have to error warning card, invalid input data when the display error warning is set to stop ,and in the title false information column in the input text are illegal !and please enter the four digit year .
Word. Obviously ,if there are people in the cell of the input is not a four digit, Excel will play the show warning dialog box ,to tell you the cause of the error ,and until you enter the correct style numerical rear can continue to input .
Magic ?Actually, in the Excel data validity judgment ,there are many special types of data formats ,such as text sequence size the time distance ah ,if you are interested, why not self-assertive ,design their own a standard ,make your Excel display out of out of the ordinary .
.Eighteen ,group filled form fixed cell we know that every time you open the Excel ,software is always the default open multiple worksheets .Thus we can see that the Excel has powerful leaflet form processing capacity ,more suitable for a plurality of interconnected form to coordinate work .
To coordinate the relationship ,of course first requires synchronization input .Therefore ,in many cases ,will need at the same time in the form of the same cell type in the same content .
How to form the group editor ?We click on the first sheet tab name ,then hold down the Shift key ,click the last table tab name (if we want to correlate with the form is not together ,can hold down the Ctrl key to select ) .
At this time, we see the Excel title bar name appeared working group ,we can be carried out on the working group of the editing work .In need of an input form content in the cell free to write something, we find that ,working group of all forms in the same location are displayed corresponding content .
However ,only sync input is not enough .For example ,we need to form in the same location of the uniform data format change how to do ?First of all ,we have to change the first table of data format ,and then click the Edit menu filler option ,and then in the sub menu select to the same group of sheets .
At this time, Excel will pop up filling group working table dialog ,here we choose the format a ,identified ,in the same group all form the location data format has changed .Nineteen ,change the size of the text written in Excel, to form processing and data operation to provide the most powerful support than formula ,also is not a database ,but function .
Don Excel function only in response to the numbers, as is written in the form content ,Excel have to edit it and special function .For example, to change the text size .In Excel 2002, provided at least three relevant text case-sensitive conversion function .
They are: =UPPER ( source data format ) ,the text of all converted to uppercase ;=LOWER ( source data format ) ,the text of all converted to lowercase ;=PROPER ( source data format ) ,to convert text appropriate case ,such as to make every word the first letter for capital etc.
.For example ,we are in a form of A1 cell input lowercase excel ,then the target cell type ( A1 ),enter the results obtained will be EXCEL .Similarly, if we are in A3 cell type ,then we in the target cell type ( A3 ),then we get the result is Mr.
Weiwei .Twenty ,to extract a string of specific characters in addition to the direct input ,from the existing cell content extracting specific character input ,the absolute is a time-saving and convenient method ,especially for some pattern similar to the information is more such ,for example ,nationality through information such as employee list .
If we want to fast from A4 cell extraction appellation words ,it is best to use =RIGHT ( source data grid ,the extracted characters .) function ,it said from A4 cellon the right side of the characters begin to extract the 2 charactersinput to this location .
Of course ,if you want to extract the name words ,is to use =LEFT ( source data grid ,the extracted characters .) function .There is also a situation ,we do not start from left and right ends ,but directly from the data center extraction of several characters .
For example, we want from A5 cell extraction Wuhan two words in the target cell ,simply type ( A5,4,2 )can be .Meaning :in the A5 cellextract fourth characters two characters ,namely fourth and fifth two characters .
In twenty-one ,the cardinal ordinal number will be converted into English the cardinal ordinal number is converted to a complicated problem .Because it does not have a fixed patterns :most figures in into ordinal numbers are used in th suffix ,but generally is 1,2,3the figure is respectively with the ST ,nd and Rd .
But ,11,12,13the 3 numbers are not the same ,they still ends with .Therefore ,to realize it seems very complex .In fact ,as long as our manage clear thinking ,search function ,only need to write a formula ,it can be easily converted to .
Do not believe ,please see :=A2&amp ;IF ( OR ( VALUE ( RIGHT ( A2,2 )) ={11,12,13} ) ,″ th ″(OR ,IF ( VALUE ( RIGHT ( A2 )) ={1,2,3 ,} ,CHOOSE ( RIGHT ( A2 ),ST ,nd ,Rd , ) .
) ) .The formula despite a long list ,but the meaning is very clear : if the number is 11,12,13,plus the suffix ;if first principles invalid ,check the last digit ,with ST ,to use 2the nd ,with the use of Rd ;if first ,2principlesare invalid, then use th .
Therefore ,the cardinals and ordinals and conversion is realized so easy and fast .In twenty-two ,with special symbols to complete the number and financial dealings knows ,in the book when filling a conventional safe fill method ,which is the amount of space to complete ,or in the amount of data is preceded by symbol .
In fact ,in the Excel also has similar input method ,that is the REPT function .Its basic format is =REPT ( special characters ,padding bits ) .For example ,we want to in A2 cellnumbers in the end with # filled to 16 ,the formula was changed to simply = ( A2&amp ;REPT ( # ,16-LEN( A2 )) ) can; if we want to A3 cell numbers from the left # No.
fill to 16 ,will be changed to ( # ,16-LEN( A3 )) ) &amp ;A3 ;in addition ,if we want to use # number in the A4 valuefrom both sides of filling ,is need to be changed to =REPT ( # ,8-LEN( A4 )/2 )&amp ;A4&amp ;REPT ( # .
) 8-LEN(A4 )/2 );if you have enough professional ,in the A5 cell numbers,immediate plus $ symbols in the words ,then changed to := ( TEXT ( A5 ,$# ,##0.00 ″ (&REPT ( # ,16-LEN( TEXT ( A5 ,$# ,##0.
00 .) ) ) ) ,will certainly be able to meet your requirements .Twenty-three ,create text histogram besides repetitive input ,the function another derivative application that can be directly in the work table created by the pure text consisting of histogram .
Its principle is simple ,is the use of special symbols in the intelligent repeat ,according to the specified cell the results show different lengths of the comparative effectiveness .For example, we first make an annual balance sheet ,and then the E as the histogram month display area ,the G as over budget in the histogram display area .
Then according to the table for the D value, use the font N character displays .The specific steps are as follows :in the E3 written in a cellformula =IF ( D30 ,REPT ( n ,ROUND ( D3*100,0 )) ,.
) ,also drag the fill handle to G14 .We see that ,a Excel chart function without the use of plain text histogram has been right in front of you ,convenient ,simple and clear .In twenty-four ,the total number of calculation cell sometimes ,we may have on the number of characters in a cell of interest ,need to calculate the total number of words in a cell .
To solve this problem ,in addition to the use of the SUBSTITUTE function of the virtual computing ,but also use the TRIM function to remove the spaces .For example, A1 now entered in the cell is how many words ?,then we can use the following expressions to help :=IF ( LEN ( A1 )=0,0 ,LEN ( TRIM ( A1 )) -LEN ( SUBSTITUTE ( TRIM ( A1 ),,, +1 )) ) the type the meaning is to use the SUBSTITUTE function creates a new string ,and the use of TRIM function to remove the spaces between characters ,and then calculate the string and the original string digital differential ,so that the number of space ,the number of spaces +1 ,reached the cell number of characters .
In twenty-five ,the euro conversion which is Excel 2002 new tools.If you install Excel 2002 when the choice is adefault, it may not be in the menu to find it .However ,we can first select tools menu add-ins ,and then in the pop-up window to check the Euro tool options , Excel 2002 willinstall itself .
After the completion of our open again tools menu ,click the euro conversion ,an independent specialized for the euro and the European Union Member States currency conversion window will appear .
With other Excel function window ,we can through the mouse set the currency conversion source region and target area ,then choose the before and after conversion of the different currencies .
Shown below is euro 100 were converted into other currencies EU members list .Of course ,in order to make the euro shows the more professional, we can also click on the Excel toolbar button ,so that all the euro converted monetary values are the euro style .

Only for 90,91,92,93 born after 90, too realistic, if your f

Only for 90,91,92,93bornafter 90 ,too realistic, friends if you are a few years this was born ,I hope you will seriously after reading this article ,you will understand many reasons like a flower ,but is very loyal &shy ;relationresultSeems to be verystrong ,in fact, than those who have fragile &shy ;relationresultSeems to be very happy,but the sad smile, and who understand.
.. &shy ;relationresultIn fact,many times &shy ;relationresultSome90people areafflicted with &shy in self ;relationresultLovelove each other very much &shy ;relationresultHewould rather die sad &shy ;relationresultAlsothe choice to go &shy ;relationresultThen turn around andleave &shy ;relationresultEither random wanton tears.
.. &shy ;relationresultIn fact many times&shy ;relationresultTheseafter 90 people understand very well &shy ;relationresultThey areafraid of lonely &shy ;relationresultBecausewhen a person &shy ;relationresultThey willmake blind and disorderly conjectures &shy ;relationresultTheywill remember the story without an ending &shy ;relationresultThink ofthe vague but clear face &shy ;relationresultBecausewhen a person &shy ;relationresultTheywill feel very insecure &shy ;relationresultTheir requestis always low &shy ;relationresultAs long aslove accompany them .
.. &shy ;relationresultIn fact many times&shy ;relationresultAfterthis group of people are very sensitive to &shy ;relationresultItis easy to suspect &shy ;relationresultAn eye ,an action &shy ;relationresultWill allow them tobe a whole day &shy ;relationresultSo donlet them scare &shy ;relationresultDonlet them hurt &shy ;relationresultIn fact many times&shy ;relationresultAfterthis class of people are sentimental &shy ;relationresultThey arealways melancholy and moody &shy ;relationresultJusteasy to be moved by what one sees .
&shy ;relationresultAfterthese people like to use words to write their mood &shy ;relationresultIt is alsoone of their sustenance ... &shy ;relationresultIn fact many times&shy ;relationresult90 in this classare in contradiction &shy ;relationresultIs to continue orsuspended? &shy ;relationresultIsinsist or give up ?&shy ;relationresultThe seemingly emotionalthey &shy ;relationresultOftenin the end.
.. &shy ;relationresultAlways makerational control the whole thinking ... &shy ;relationresultIn fact many times&shy ;relationresultThis kind of personalways live in the past &shy ;relationresultThey alwaysinadvertently in the present life to find some sense of deja vu &shy ;relationresultAlthoughthey agreed to forget the past &shy ;relationresultBut theyforget.
.. &shy ;relationresultIn the pastin mind ingrained ... &shy ;relationresultIn fact many times&shy ;relationresultAfterthis kind of person is afraid of seeing others sweet &shy ;relationresultNotjealous of &shy ;relationresultJustfeel and previous himself as &shy ;relationresultThenin the memory of &shy ;relationresultPastpain to awaken their consciousness &shy ;relationresultOneslowly licking their wounds .
.. &shy ;relationresultIn fact many times&shy ;relationresultInthis class are very persistent &shy ;relationresultSometimesnot know they insist on what &shy ;relationresultThey arelooking forward to the never ending story ending &shy ;relationresultStill waiting formore damage &shy ;relationresultThey aresilly &shy ;relationresultInthis class of human &shy ;relationresultToo many shortcomings&shy ;relationresultToosmelly ,not self-willed ,and sensitive suspicious &shy ;relationresultSo close to them or not&shy ;relationresultEitheruse the sincerity treats them &shy ;relationresultBecause they are very brittle heart&shy ;relationresultYouvulnerable .
.. &shy ;relationresultAfter weare fools ,the fools ... &shy ;relationresultDonknow what the future how far .....&shy ;relationresultWhetherand how many people in a mobile phone ,always hung with QQ ,a lot of people together in one block ,a mobile phone, each playing each &shy ;relationresultClassmate partyrequired two projects :eat, KTV &shy ;relationresultThe childstarted calling his uncle or aunt &shy ;relationresultNever lonely ,whenever you are alone ,or in a crowed &shy ;relationresultJust likein the song sings , alone ,is a person ,carnival is a group of lonely people ,&shy ;relationresultNot soyoung cynic ,encounter injustice when, tell yourself, the society is this &shy ;relationresultCannot watch TV ,but the computer is a necessity in &shy ;relationresultWilltake out three things: the mobile phone ,keys ,money &shy ;relationresultNever knowwhat the money ,not how to eat, how not to wear &shy ;relationresultNegative,refuse to grow up .
Don to be that mature. &shy ;relationresultAcquaintances before it isLao ,strangers not to utter a single word &shy ;relationresultThere must be ahobby is sleeping with &shy ;relationresultA dayon the Internet bubble ,and do not know what to do .
&shy ;relationresultMost a word that often saysis boring ,although they spent a lot of time on the internet .&shy ;relationresultHungry toeat breakfast ,lunch and eat together &shy ;relationresultTyping was quite inaccurate,but still playing very fast &shy ;relationresultBefore 12 a.
m.and rarely sleep &shy ;relationresultAnything can be ,because do not have so much time ,also do not care so much about &shy ;relationresultThere is no reasonnot to capital pride ,but in actuality they inferiority ,look definitely ,expect recognition ,being hated failure in life when even have the courage to say no .
&shy ;relationresultThought nobody can understand you,and as the other people did not reason .&shy ;relationresultBecause other people are in love soin love himself ,more are practicing love and not love ,then you even begin to doubt who adhere to the love .
&shy ;relationresultOnce thought thataccompany for a lifetime in friends ,one day a month ,you suddenly find that they are missing &shy ;relationresultWake up in the night,it was shocked to discover that ,never alone &shy ;relationresultThe older,more easily lonely &shy ;relationresultAfter 90 of us,there are a lot of dreams, some realized some shattered .
&shy ;relationresultAfter 90 of us,some famous, some unknown to the public .&shy ;relationresultAfter 90,struggling over a loss ,or survive .&shy ;relationresultAfter 90,youth retreat young tender ,began to adapt to the social big family .
&shy ;relationresultOur heartsare very clear ,we experienced too much .&shy ;relationresultHad afling caution to the winds pursuit ,has become not to be worth a hair .Parents have blocking things ,until their injuries, understand ,parents turned out to be right .
&shy ;relationresultOncemany times asked myself ,why live ?Later, had to go to the meaning of life .&shy ;relationresultIn order to have thelove can not love reading .&shy ;relationresultHope that90 after us,happiness .