EXCEL basic operations and skills in Solitaire

peyatdbko

1, To input and up to the same value,abercrombie fitch hoodies, our usual practice is to copy and paste or direct drop-down, in fact, use the CTRL + D key combination can be done
3 n9 _( v/ E  M- b0 ~ example: The value of A1 :2008-10-27, I would like to A2 also enter the same date, just press CTRL + D in A2 and won 2008-10-27, copy too much trouble, drop-down usually into 2008 -10-28
ctrl + D can also be filled with more than one line down.
- S+ _% \6 \- T2 J0 ^# {  k such as to fill down the inside of the data A1 to A10. Can select the range A1 to A10 (10 cells), followed by a ctrl + D on it.
->
+ u3 f+ C3 |  ~- i) ?
3 a+ c# m  I  v3 a7 G$ M# Q However, as CTRL + 'is the same you can copy the cell above, CTRL + D can all of the above cell number format reproduced. If not copy the format and copy only the numbers, then use statistics CTRL + 'a,herve leger dresses, and after copying down the Edit
->

2, CTRL + R ; copy the data to the right the left the cell
  {, i; u' E6 C/ g$ P4 j9 s
, r3 \, E/ g: S" X" U
* u8 I+ p) O4 \6 M4 N. y3 q 3, copy the contents of the selected cells, then select the target cell, and then press Enter directly for fast paste!
->
, ~4 K" R- O+ F$ w: A' R7 C5 {
4, the cells enter the following formula: = TEXT (NOW (), \>
5, you want to move one or several cells to form a location, select them, press the Shift key while dragging the position to go until the black cursor into \or \effect)

-> ->
+ c3 v0 Y3 t1 j, K3 T/ W ->
& d* A' I9 {, e( \) C
; n; [5 c# O8 K; r/ f' ^ 6, at work, often see some people of a cell line of text in two or more lines , knocked on countless space bar.
7 k- N7 r; m/ ~0 B5 t+ @4 T example: in cell A1 I want to carve two rows show the name and age.
fact, you can do:
in A1, enter \
8 r6 N" t0 K% v3 a' ` Name
' ^; p1 D: Y* w Age
- m) v6 E- E5 C. g  z# c) c; W* z% N
->
9 u$ P3 K! L# a+ C! C9 S3 ~4 D% n
7, tell us about the scores of input method: (to the right of participation in computing and display, not text format)
; y' a, B! C$ M% Y example: half is: 0 1 / 2
* [+ Y/ i) y7 i( |- O three and one half to: 3 1 / 2
Note: 0 or 3 back as a space.
, H1 j7 ]1 c1 Z  B" P- N ->

8, of course, enter the ID number of the most common problem, there will be 123457E +17 or last three into 000 cases
; z( k4 u. @: ?
8 j; r2 K" g% m/ m first, ID number can be set out in the first cell formatting to text type can


2 n9 |; c8 [( w# y( O second, enter the ID number in front of the single quotes''and then enter the ID number
/ H! Y6 p+ D1 A: T ->

9 y% B. W8 T4 U
9, double-click the fill occurs when the small black cross formula, the formula could have been filled to the cell where you select the column (or row) at the bottom (or far right)
! E( J$ p0 x: p6 L/ Z* p/ e example: (A1: A14) a value, B value * 2 column as A, B1 can enter = a1 * 2, move the cursor to the lower right corner until the emergence of cell B1 black cross, double-click, OK
formula are not limited to numerical formula
% I* @' ]' o' ~  ^# | ->
6 G3 v  W3 R2 n% k6 s
10, in discrete cells enter the same content, select the cell you want to enter, select After typing in the cell, press Ctrl + Enter or can!
->

4 K! [8 k. Z% ]1 }7 S/ c
' `. `, K' Z# N1 T, [ 11, issue: a series of data to Execl copy elsewhere, but the number stored in text format, can not be aggregated and calculated change cell formatting to the numbers no good. Here are a

4 b+ O1 ]4 x+ t7 U way: in any cell type 1, a copy of this cell,ed hardy clothing, and then choose to change the cell value (B2: C21), right, on the shortcut menu, select \in the out dialog box, select the value, respectively, by.
% u# Q# e: g- W0 ~ or
a blank cell in the mid-point copy, then select which number you want into the column, then right-column select Paste Special in the operation \br>
6 j' s3 {( O! y" v* E Method 2: breakdown. Select the column to convert the point data menu is set out, and then point to complete you can
% I0 G# Q* T! D4 U+ f3 z' ~9 _6 l0 r
12, because taking 2 digits after the decimal point,christian louboutin pumps, causing a small deviation occurs when aggregate
3 g: P+ u: W/ G6 p work, often The data obtained only 2 digits after the decimal point (usually in the Format Cells in setting 2 decimal places), but are generally used in the summary summation formula, and then get 2 digits after the decimal point, this way, aggregate number and hand considered as summarized on the often different. Such as A1, A2, A3 for 1 / 3, taking 2 digits after the decimal point, shown as 0.33. A1, A2, A3 summarizes the definition of a formula A4 = A1 + A2 + A3, taking 2 digits after the decimal point, display of 1. If the hand count of 0.33 +0.33 +0.33 = 0.99, and A4 show the value of the discrepancies.
+ `0 A3 k, G0 a3 l. F% r can: Tools menu options ----- ---- ---- calculated to show the value of subject (the accuracy will be lower)
or in the sub-function obtained in round two with a decimal, If B1 = round (A1, 2), B2 = round (A2, 2) ... ...
7 k/ A% |% N9 \5 H2 l. o* i4 O

: x+ E2 U; d" {- T& y- ]7 p8 a1 e
6 ?7 I5 L& u' M% E
$ q( G: p9 j; g3 O" {' `0 J8 n
/ s5 P3 C; Y/ y( Q: J" d! m: r3 g 13, talk on cell 【select, copy, move, delete】 shortcuts

■ Select
0 l) A& v: h; r
$ H% J' Q0 g; a( u) \+ o ☆ quickly selected range of cells
* j* G# ?- P$ A9 R/ A press 【Shift】 key, mouse over the active cell / region of the edge mouse that hit a four-pointed arrow, double-click the active cell (area) of the edge of the range of cells can be quickly selected activities to this line or this column until the next blank cell.

! T6 i) B* ^% z9 [, q: |# B down selection, until an empty cell until the encounter A11
8 R5 p6 U) g- ]3 W8 V
right choice, until an empty cell D6 encountered so far
+ z$ {9 g3 [; R ▲ empathy can push up and to the left selection method.

☆ select a continuous range of cells
start by first selecting the cells in the cell, and then press 【Shift】, click on the target range of cells in the last cell, to select a starting unit grid for the upper left, lower right corner of the last cell in the rectangular area.

  g' e7 ]9 x* b$ S7 J3 [, o
☆ select discontinuous range of cells
7 Z3 L" L" s" P% R4 S) t% j first select the first cell or range of cells, and then hold down the Ctrl】 【other selected cell or range of cells.

☆ into cells
press 【Shift】,cheap nike shoes, drag the fill handle down or right to delete cells
  R% k2 |3 t/ L" C# P
2 Y; f2 f4 w) m: E9 B ☆ 【Shift】
& A: z& K$ Q! J+ ^1 t hold down, up or left-drag the fill handle, the cell can be removed, or below (right) Move the cell (left)
】 【Tip: attention and do not press 【Shift】 reverse drag difference,

☆ move across the worksheet cell range of cells
move your mouse over the edge, hold down the Alt】 【drag the mouse to the target sheet to the target area after the label after the release of the mouse.
# {7 J2 u9 L/ [3 \
1 q6 o2 Z; S. o ☆
  x% \3 J7 s6 k9 U3 S cell replication target range of cells selected,juicy couture bags, move your mouse over the border range of cells, hold down the Ctrl】 【drag to the target region.
- T) W( E: h( _( L
6 E2 r! \' J# v' N1 o ☆ swap the order of cell
1 f  F4 F. J- N, y! m press 【Shift】, will drag the mouse over the edge of the cell range of cells to the target cell.



& G9 J2 [" R4 |( K9 H( ^* ]: J 14, shortcut keys, be sure to test himself, to strengthen the impression
& R' }% K( N! M8 x0 g

9 ^  `! F* E# N& ^
15, ■ Excel, the addition of an absolute reference】 【Fu \$ \Mixed cited some address changes.
" P5 h& ~! l' P4 @ relative references, absolute references, and mixed reference is used in the formula cell address or range of cells, when copying the formula when the next change of address. Here we illustrate the specific circumstances:
(1) the relative reference, copy the formula to follow when the address changes, such as:
% T. F6 D+ X, L% I6 C C1 cells have the formula: = A1 + B1 (1 +2 = 3)
0 `. I  D/ c1 @; ?6 H When the formula copied to cell C2 becomes: = A2 + B2 (3 +4 = 7)
+ y3 u( ]) p+ G& ]& q when copy the formula into cell D1: = B1 + C1 (2 +3 = 5)
2 `2 H2 h! N2 s

: x0 b$ C8 l1 h6 N (2) the absolute reference, copy the formula does not follow a change in address, such as:
C1 cells have the formula: = $ A $ 1 + $ B $ 1 (1 +2 = 3)
When the formula copied to the C2 cell remains: = $ A $ 1 + $ B $ 1 (1 +2 = 3)
when the formula copied to the D1 cell remains: = $ A $ 1 + $ B $ 1 ( 1 +2 = 3)

! j; G: q$ N* I  v7 Q( K4 |7 M
9 R( E/ ^; x) S; _9 j7 {  f (3) mixed reference, copy the formula to follow when part of the address changes, such as:
C1 cells have the formula: = $ A1 + B $ 1 (A column and a line in front of each with the absolute reference symbol $, replication quoted unit cell A1 and B1 where the A column where the row will not change 1)
( D) X/ D# {3 ]  K when the formula copied to cell C2 becomes: = $ A2 + B $ 1
; s1 Z" I. ^2 Y5 c! i: K when copy the formula into cell D1: = $ A1 + C $ 1
. W/ d& o3 }9 r1 i1 }
rows and columns in front, who earlier put on the \Whoever the same time drag. If you are put on the \

8 O  X4 t+ ]. v4 l% ~ input reference, press the F4 key to switch the absolute and relative references
4 |. p# ], D7 _
following diagram, A column * 1 line 2 line
: P9 {1 p/ T, A6 \" J# F- o: B5 i formula, copy the formula in the horizontal, only need to quote the first line B1-> E1, the column has been changed, but the same line (absolute reference), input B $ 1;

# i7 {/ Z1 Q( g  A& O4 O7 K in column B, copy down, the reference to the first column A, that is, to quote the whole A column value can not be changed, but each line in the A column in the change, enter the $ A2, B2 = B $ 1 * $ A2
  V/ h  w3 i/ v

3 W% R3 e$ P/ ~1 V' d


--- ---------------------------------------
This article is reproduced from: じ ☆ veve Jiao ?: EXCEL basic operations and skills in Solitaire
6 H7 U& K) Q! R reading room with QQ Email Subscribe じ ☆ veve Jiao?
* s! r9 S/ ~- w8 b0 |6 O1 z What is the reading room?