• No results found

Excel Shortcuts

N/A
N/A
Info
Download
Protected

Academic year: 2021

Share "Excel Shortcuts"

Copied!
5
0
0

Loading.... (view fulltext now)

Download now ( 5 Page )

Full text

(1)

C

Coommmmaannd d NNaammee KKeey y SSttrrookkee S

Smmaarrt t DDeeppeennddeennttss CCttrrl l SShhiifft t }} S

Smmaarrt t PPrreecceeddeennttss CCttrrl l SShhiifft t {{ Cl

Cleear ar EvEvererytythihing ng WWitithhin in SeSelelectctioionn AlAlt et eaaaa D

Deelleette e SeelleeccttiioS onn AAllt t eedd E

Eddiit t RReeddo o ((RReevveerrsse e UUnnddoo)) CCttrrl l y y / / AAllt t eer  r   E

Eddiit t UUnnddoo CCttrrl l z z / / AAllt t eeuu R

Reeppeeaat t LLaasst t CCoommmmaanndd F4 F4 / / CCttrrl l y y / / AAllt t EEnntteer  r   C

Cooppy y DDoowwn n ((EExxcceell)) CCttrrl l dd C

Cooppy y RRiigghht t ((EExxcceell)) CCttrrl l r  r   P

Paasstte e SSppeecciiaal l - - FFoorrmmaattss AAllt t eesst t EEnntteer  r   P

Paasstte e SSppeecciiaal l - - FFoorrmmuullaass AAllt t eessf f EEnntteer  r   P

Paasstte e SSppeecciiaal l - - VVaalluueess AAllt t eessv v EEnntteer  r   S

Smmaarrt t CCooppy y DDoowwnn CCttrrl l SShhiifft t DD S

Smmaarrt t CCooppy y RRiigghhtt CCttrrl l SShhiifft t R  R   C

Cooppyy CCttrrllcc//AAlltteecc C

Cuutt CCttrrllxx//AAlltteett IInnsseerrt t ((CCooppiieedd) ) CCeellllss AAllt t iiee

P

Paassttee CCttrrl l v v / / AAllt t eepp F

Fiille e CClloossee AAllt t ffcc F

Fiille e NNeeww CCttrrl l n n / / AAllt t ffnn F

Fiille e OOppeenn CCttrrl l o o / / AAllt t ffo o / / CCttrrl l FF1122 F

Fiille e SSaavvee CCttrrl l s s / / AAllt t ffss F

Fiille e SSaavve e AAss F1F12 2 / / AAllt t ffaa C

Ceelll l FFoorrmmaattttiinng g DDiiaalloog g BBooxx CCttrrl l 1 1 / / AAllt t ooee C

Ceenntteer r TTooggggllee CCttrrl l SShhiifft t CC B Boolldd CCttrrllbb IIttaalliiccss CCttrrllii U Unnddeerrlliinnee CCttrrl l uu U

Unnddeerrlliinne e TTooggggllee CCttrrl l SShhiifft t UU C

Cuurrrreennccy y TTooggggllee CCttrrl l SShhiifft t $$ D

Daatte e TTooggggllee CCttrrl l tt D

Deeccrreeaasse e DDeecciimmaall CCttrrl l k  k   IInnccrreeaasse e DDeecciimmaall CCttrrl l jj M

Muullttiipplle e TTooggggllee CCttrrl l SShhiifft t ** P

Peerrcceennt t TTooggggllee CCttrrl l SShhiifft t %% C

Coolluummn n AAuuttooffiitt AAllt t ooccaa A

Abbssoolluuttee//RReellaattiivve Re Reeffeerreennccee FF44 E

Enntteerr//EExxiit t CCeelll l FFoorrmmuulla a BBaarr FF22 F

Fiinniissh h EEnnttrryy EEnntteer  r   F

Fiinniissh h EEnnttrry y aannd d MMoovve e LLeefftt SShhiifft t TTaabb F

Fiinniissh h EEnnttrry y aannd d MMoovve e RRiigghhtt TTaabb IInsnseert rt FuFuncnctition on (F(Fununcctition on WiWizazardrd)) ShShifift Ft F33 S

Suum m FFoorrmmuullaa AAllt t == IInnsseerrt t CCoolluummnn AAllt t iicc IInnsseerrt t RRooww AAllt t iir  r   A

Addd d BBooookkmmaarrkk CCttrrl l AAllt t bb C

Clleeaar r BBooookkmmaarrkkss CCttrrl l AAllt t xx G

(2)

Move Down Down Arrow

Move Left Left Arrow

Move Right Right Arrow

MoveUp UpArrow

Next Bookmark Ctrl Alt n

Next Workbook Ctrl Tab / Ctrl F6 Next Worksheet Ctrl Page Down

Page Down Page Down

PageUp PageUp

Previous Bookmark Ctrl Alt p

Previous Workbook Ctrl Shift Tab / Ctrl Shift F6 Previous Worksheet Ctrl Page Up

Quick Move Down Ctrl Down Arrow Quick Move Left Ctrl Left Arrow Quick Move Right Ctrl Right Arrow Quick Move Up Ctrl Up Arrow Activate/Deactivate Menu Bar F10 / Alt

Help F1

Insert Name (Define) Alt ind / Ctrl F3 File Clear Print Area Alt ftc

File Page Setup Alt fu

File Print Ctrl p / Alt fp File Print Preview Alt fv

File Set Print Area Alt fts Insert Page Break Alt ib

Highlight Down Shift Down Arrow Highlight Left Shift Left Arrow Highlight Right Shift Right Arrow Highlight Up Shift Up Arrow

Quick Highlight Down Ctrl Shift Down Arrow Quick Highlight Left Ctrl Shift Left Arrow Quick Highlight Right Ctrl Shift Right Arrow Quick Highlight Up Ctrl Shift Up Arrow Select Column Ctrl Spacebar   Select Row Shift Spacebar   Window Freeze/Unfreeze Alt wf  

Window Split Alt ws

Next Application Alt Tab Previous Application Alt Shift Tab Windows Start Menu Ctrl Esc

Find Ctrl f / Alt ef / Shift F5 Replace Ctrl h / Alt ee

Smart Fill Dates Ctrl Alt d Smart Fill Numbers Ctrl Alt f   Smart Formula Column Spacing Ctrl Alt l Smart Formula Row Spacing Ctrl Alt r   Smart Formula Transpose Ctrl Alt t Apply DM Paintbrush Style Ctrl Alt v Capture DM Paintbrush Style Ctrl Alt c AutoColor Sheet Ctrl Alt 1 Blue Black Color Toggle Ctrl ;

(3)

General Number Toggle Ctrl Shift !

Column Width Alt ocw

Row Height Alt ort

Calculate Formulas F9

Smart Hide Ctrl Alt h Show Right Click Menu Shift F10 Tools Options Alt to

View Zoom Alt vz

Close Application Alt F4

Close Window Ctrl F4 / Ctrl w Display Cell Formulas (Toggle) Ctrl `

Edit Links Alt ek  

Highlight Direct Cell Dependents Ctrl ] Highlight Direct Cell Precedents Ctrl [ Highlight Indirect Cell Dependents Ctrl } Highlight Indirect Cell Precedents Ctrl { Show Dependent Arrows Alt tud Show Precedent Arrows Alt tut Edit Delete Sheet Alt el Copy Formula From Cell Above Ctrl ' Copy Value From Cell Above Ctrl Shift " Copy/Move Sheet Alt em Apply Sheet Style Ctrl Alt 2 Cell Color Toggle Ctrl Shift K   Edit Clear Formats Alt eaf   Horizontal Alignment Toggle Ctrl Shift H Indent Toggle Ctrl Shift I Vertical Alignment Toggle Ctrl Shift V Border Outline Ctrl Shift & Border Toggle Ctrl Shift B Remove Borders Ctrl Shift _   Decrease Font Size Ctrl Shift G Increase Font Size Ctrl Shift F Purple Red Green Color Toggle Ctrl '

Binary Number Toggle Ctrl Shift Y Auto Column Width Ctrl Alt 6 Auto Row Height Ctrl Alt 5 Column Width Toggle Ctrl Alt 4 Row Height Toggle Ctrl Alt 3 Check for Errors Ctrl e Delete Remainder of Entry Ctrl Delete Fill Selection With Entry Ctrl Enter  

Leader Dots Ctrl .

New Line in Cell Entry Alt Enter  

Sum Bar Ctrl Shift S

Group Rows/Columns Alt Shift Right Arrow

Hide Columns Ctrl 0

HideRows Ctrl 9

Ungroup Rows/Columns Alt Shift Left Arrow Unhide Columns Ctrl Shift 0

(4)

Insert Worksheet Alt iw / Shift F11 Delete Column Ctrl Alt 0

Delete Row Ctrl Alt 9 Insert Column Ctrl Alt 8 Insert Row Ctrl Alt 7 Move Down Within Selection Enter   Move Left Within Selection Tab Move Right Within Selection Shift Tab Move To Bottom Right Cell Ctrl End Move To Cell A1 Ctrl Home Move To Column A Home Move To Last Used Column End, Enter   Move Up Within Selection Shift Enter   Next Worksheet Loop Ctrl Page Down

Page Left Alt Page Up

Page Right Alt Page Down Previous Worksheet Loop Ctrl Page Up Edit Clear Comments Alt eam Help (Context Sensitive) Shift F1

Insert Comment Alt im / Shift F2 Insert Current Date Ctrl ;

Insert Current Time Ctrl Shift :

Next Toolbar Ctrl Tab

Previous Toolbar Shift F10

RunMacro AltF8

Spelling Check F7

Select All (Entire Worksheet) Ctrl a / Ctrl Shift Spacebar  Set/Clear Selection Anchor F8

Split Window Toggle F6

View Normal Alt vn

View Page Breaks Alt vp Maximize Window Ctrl F10 Minimize Window Ctrl F9 Restore Window Size Ctrl F5 Training Window Size Ctrl o

Row Autofit Alt ora

Insert Defined Name in Formula F3

Insert Hyperlink Ctrl k / Alt ii Decrease Zoom Ctrl Alt -Increase Zoom Ctrl Alt = Border None Ctrl Shift _   Border Outline Ctrl Shift &

Strikethrough Ctrl 5

Column Standard Width Alt ocs Insert Function Arguments Ctrl Shift A Insert Chart Sheet F11

Move Clockwise Within Selection Ctrl .

Next Region Within Selection Ctrl Alt Right Arrow Previous Region Within Selection Ctrl Alt Left Arrow Show/Hide Standard Toolbar Ctrl 7

(5)

Extend Selection Page Down Shift Page Down Extend Selection Page Left Shift Alt Page Up Extend Selection Page Right Shift Alt Page Down Extend Selection Page Up Shift Page Up

Only Select Active Cell Shift Backspace Select Region Around Active Cell Ctrl Shift *

Select To Bottom Right Cell Ctrl Shift End / End, Shift Home Select To Cell A1 Ctrl Shift Home

Select To Column A Shift Home Select To Last Used Column End, Shift Enter   Maximize Window Ctrl Shift O

References

Download now ( PDF - 5 Page - 264.07 KB )

Related documents

On the kinetic and allosteric regulatory properties of the ADP-glucose pyrophosphorylase from Rhodococcus jostii: An approach to evaluate glycogen metabolism in oleaginous bacteria

The key regulatory step in bacterial glycogen metabolism occurs at the level of ADP-Glc synthesis, in the reaction catalyzed by allosteric ADP-Glc pyrophosphorylase (EC

Networking Notes in Hindi

-Provides the same functionality as the physical, the data link and network layers in the OSI model. -Mapping between IP addresses and network

Pharmacy

Thanks for using the Free Pharmacy Assistant Practice quiz

AFRICAN DEVELOPMENT BANK GROUP PROJECT: RICE PROJECT OF SAINT-LOUIS AGRICULTURAL COMPANY COUNTRY: SENEGAL

At the environmental level, the project will result in: better water and land management and improved management of irrigation potential in the project area;

Findings, Conclusions, and Recommendations

Conclusion: While The Ohio State University has a large inventory of pool (general assignment) and departmentally-scheduled classrooms and classroom stations, the University

Determinants of equity return correlations: a case study of the Amman Stock Exchange

Among a handful of studies that have looked at the factors associated with return correlations, Chiang and Chen (2016) and Kim and Sun (2016) discovered that the conditional

pediatric must know

- usually appears after fever lysed - initially appears on the lower extremities - not a common finding among dengue patients - “an island of white in an ocean of red”.

Edukasi Table Top Terhadap Pengetahuan Mitigasi Gempa Bumi Siswa Remaja SMA Negeri 3 Kotamobagu

Sejalan dengan (Arimastuti 2011) bahwa prioritas pelaksanaan pengurangan risiko bencana alam maka upaya dan rencana aksi yang dilakukan meliputi: Meletakkan pengurangan