office快捷键（办公室快捷键）.docVIP

office快捷键（办公室快捷键） Ctrl combination shortcut key Communication technology forum 2j/W:S2Z3b2h#o3M.Y3I key leading that | 7b4k$B.^4~; M.G.}Ctrl+Shift+ (to hide all hidden rows within the selected range. 8^ k$m, I, [Ctrl+Shift+) hides all hidden columns in the selected range. 4{%EQ1L6E*GCtrl+Shift+ applies the outline to the selected cell. K; M0\C+` H (_Ctrl+Shift_ removes the frame from the selected cell. /e#~ (M#z,]*N, b4{Ctrl+Shift+~) applies the regular digital format. 7h.w$i2g5g communication technology forum Ctrl+Shift+$application ln | leading with two decimal currency format (negative numbers in parentheses). ]] d%eT1}/\Ctrl+Shift+% applies the percentage format without decimal bits. /@9m4f9`7E$m a Ctrl+Shift+^ uses an index format with two decimal places. | forum leading communications technology (b*A%g:u) (` A.g*i-Z:V Ctrl+Shift+# applications have day, month, and year date formats. MSCBSC mobile communications forum,]3Q%u (Z*o) f Ctrl+Shift+@ applications have hours and minutes, and AM or PM in the time format. | leading communications technology forum *B h p%fe1m! Ctrl+Shift+! With two decimal places, thousands separator and minus (-) (negative for) the number format. | forum leading communications technology: M2P*j2{+@ C4K+r m/r (I Ctrl+Shift+* selects the current area surrounding the active cell (the data region enclosed by the blank rows and blank columns). 2o.g%B*P S | leading communications technology forum in the PivotTable, it will choose the pivottable. 7v:z:t, z%V, Z. ~5L x:p*Ctrl+Shift+: enter current time. M-w (l1~, kDl! Ctrl+Shift+ copy values from cells above active cells to cells or edit columns.. The 9D9y1M#@$S+z5K9j0JCtrl+Shift+ plus (+) shows the insert dialog box for inserting blank cells. MSCBSC mobile communications forum L0a (W6g:d4r4r6N0[8w+]) Y Ctrl+ minus (-) to delete the selected cells display the delete dialog box. 9B:{*i1A; D (`9v3nCtrl+); enter the current date. X8E*p7n0H-a.v5{B7\Ctrl+` toggle the display cell values and formula