Excelããã¬ã¿ãªã¢ãŒãããèŠããå°å³ã«å€çšããã·ã§ãŒãã«ããïŒWindowså«ãïŒ
æ¥äžçªãå¹ããŠè±ç²ã«ããããæ¯æ¥ã§ãã
Â
ãããã3幎ç®ã«ãªãææãªã®ã§ãèªåã®çµéšããŸãšããŠããæå³ããããŠãå°å³ã«å®åã§å€çšããŠããã·ã§ãŒãã«ããïŒExcelãWindowså«ãïŒããŸãšããŠãããããªãšæããŸãã
Â
èªåã¯æ®æ®µãšã¯ã»ã«ããã¡ããã¡ããããããšãã¡ã€ã³ã®æ¥åãè¡ã£ãŠããŸããããŠã¹ã¯æ¥µå䜿ããªãšããæåã®ããŒã ã§æ¥ã æ¥åã«ããã£ãŠããã®ã§ã»ãšãã©ã®æäœã¯ããŒããŒãã§è¡ã£ãŠããŸããããŠã¹ã䜿ããªãããã«ãããšæ±ºãããšãããŸãŸã§ããŠã¹ã§ãã£ãŠãæäœãããŒããŒãã§è¡ãå Žåã¯ã©ãããã°ãããã ïŒãšèããŠã¯ã°ã°ããæ £ãããŸã§ãã®æäœãç¹°ãè¿ãã£ãŠã®ã§é©å¿ããŠããŸããã
Â
ä»ãŸã§ç€Ÿå€ç ä¿®è¬åž«ã®åœ¢ã§å€éšã§ãšã¯ã»ã«ç ä¿®ãäœåºŠãæ
åœãããŠããã ããéã«ããçããé¢æ°ãæ©èœé¢ã®ç¥èã¯ããçšåºŠããããŠãã€ã€ããèå¿ã®ãšã¯ã»ã«ãPCã®æäœé¢ã§ãªããªãæããããªé床ã§åŠçã§ããŠããªããªãšæããããšãå€ãã£ãã§ãã
Â
ç¹ã«æ°åç ä¿®ãšãã§è²ã ãšé¢æ°ãã·ã§ãŒãã«ãããæãã£ããããŸãããèšãã»ã©å®åã§äœ¿ãããªãšãããã®ãå€ãã£ãããå®éã«ããå®åã«å ¥ã£ããšãã«ãããããªæäœæãã£ãŠãªããã£ãŠãã€ã ã£ãããèªåã®å Žåå€çºããã®ã§ããšããããããããã¹ã¿ãŒããŠããã°åšå²ãã3æ©ããããªãŒãã§ããã®ã§ã¯ã£ãŠãã€ããŸãšããŠãããããšæããŸãã
ãã ããããã¯ããŠã¹ïŒãšãããã¿ãããããïŒã®æ¹ãéããïŒã£ãŠããæäœã«ã€ãã¯ããŠã¹ã§ãã£ãŠãŸãããã®èŸºãã¯äžæã«åãæ¿ããŠãããŸããããÂ
Â
----------------------------------------------
Windowsç·š
-
ãšã¯ã¹ãããŒã©ãŒåã
WindowsïŒEïŒãšã¯ã¹ãããŒã©ãŒè¡šç€º
ã- äžåžããå ±æãã©ã«ãã®ã¢ãã¬ã¹ãããã£ãããšã«ããã³ããã§ããŸã
ShiftïŒTabïŒãã©ã«ãäžèŠ§ãã¢ã¯ãã£ããâ/â ã§ç§»å
TabïŒè©³çŽ°ãã¡ã€ã«äžèŠ§ãã¢ã¯ãã£ã
AltïŒâïŒäžéå±€äžã«ç§»å
AltïŒâïŒçŽåã®ãã©ã«ãã«æ»ã
AltïŒDïŒã¢ãã¬ã¹ããŒãã¢ã¯ãã£ã
CtrlïŒNïŒãšã¯ã¹ãããŒã©ãŒè€è£œ
CtrlïŒShiftïŒNïŒæ°ãããã©ã«ãäœæ
ã- AltâHâN ã§ãè¡ããŸããè¥å¹²éããã®ãšããã¡ã€ã«ãä¿åããå ãéžã¶ãšãã®ç»é¢ïŒF12ïŒã§ã¯ CtrlïŒShiftïŒN ãã䜿ããªãã®ã§æ³šæã§ãÂ
-
ãã¹ã¯ãããåã
WindowsïŒDïŒãã¹ã¯ããã衚瀺
WindowsïŒPïŒã¢ãã¿ãŒèšå®ã- ãã¥ã¢ã«ã¢ãã¿ãŒã«æ¥ç¶ããéã«ãè€è£œãã«ããããæ¡åŒµãã«ãããããèšå®ã§ããŸã
ãã¹ã¯ãããã§å³ã¯ãªãã¯âãã£ã¹ãã¬ã€èšå®ïŒãã¥ã¢ã«ã¢ãã¿ãŒã®äœçœ®é¢ä¿ãèšå®
ã- ãæ¡åŒµãã«ããããšã«ãç»é¢å士ãã©ãããäœçœ®é¢ä¿ã§çœ®ãããããã«èšå®ã§ããŸã
WindowsïŒSïŒãã¡ã€ã«/ãã©ã«ãæ€çŽ¢
WindowsïŒç¢å°ïŒã¢ã¯ãã£ããŠã£ã³ããŠã移å
ã- ãã¥ã¢ã«ã¢ãã¿ãŒã«ããããŸç»é¢ã移åããããšãã«å€çšããŸã
AltïŒTabïŒAlt ã¯æŒãã£ã±ãªãïŒïŒããã¯ã°ã©ãŠã³ãã«ãããŠã£ã³ããŠäžèŠ§è¡šç€º
ã- ããä»ã®ç»é¢ãåºããšãã«ã¿ã¹ã¯ããŒïŒWindowsç»é¢ã®äžã®ããŒïŒã«ããã¢ã€ã³ã³ã«ããŠã¹ãæã£ãŠè¡ã£ãŠã¢ã¯ãã£ãã«ããããŠã£ã³ããŠãæ¢ã人ãããŸãããAltïŒTab ã®æ¹ãç®åœãŠã®ç»é¢ãæ¢ããããããšãå€ãã®ã§ãªã¹ã¹ã¡ã§ãã
 ----------------------------------------------
Excelç·š
-
ã³ã¹ã¡èª¿æŽåã
CtrlïŒïŒïŒéžæããŠããè¡ãé衚瀺
CtrlïŒïŒïŒéžæããŠããåãé衚瀺
ã- äžèš2ã€ã¯ãã·ãŒãäžã§å¿ èŠãªé å以éãé衚瀺ã«ããéã«äœ¿ããŸããããŸã«ãããã£ãã³ã¹ã¡èª¿æŽãè¡ããã«1048576è¡ããããŸã§ç©ºçœè¡ãç¶ããŠããã·ãŒããèŠãããšããæ¹ããããšæããŸããããããããããšèŠçŽ é移åïŒCtrlïŒç¢å°ïŒãã¯ãœæ ããªãã®ã§å¿ ãé衚瀺ã«ããŠãããŸãããïŒããŒã ã«ãã£ãŠã¯æçµè¡ã«ãxããšããEndããšãã眮ããŠããæåããããšæããŸãããæå³ãšããŠã¯åããªã®ã§ã©ã¡ãã§ã倧äžå€«ã§ãïŒ
ÂCtrlïŒïŒïŒã»ã«ã®æžåŒèšå®
ã- 衚瀺圢åŒïŒæ°å€ãæ¥ä»ãããŒã»ã³ããŒãžè¡šç€ºãªã©ãéžã¹ãïŒãé 眮ïŒæ°åãé·ãããŠã######ããšãã§è¡šç€ºãããŠããŸããªãããã«çž®å°ããŠè¡šç€ºãããïŒAltïŒKïŒãšãïŒã眫ç·ãå¡ãã€ã¶ãèšå®ãã§ããŸããã¿ãéã®ç§»å㯠CtrlïŒTabãCtrlïŒShiftïŒTabïŒãããã¯CtrlïŒPgUp/PgDnïŒã§è¡ããŸãã
AltïŒShiftïŒïŒâ/âïŒïŒè¡/å ã®ã°ã«ãŒãå
ã- ã¡ã€ã³ã®äœæ¥é åã®äžã§ãããŠæå³çã«è¡ãåãé衚瀺ã«ãããå ŽåãCtrlïŒïŒ/ïŒ ã ãšããã«é衚瀺é åããããã©ãããèŠèªããããšãé£ããä»æ§ã«ãªã£ãŠããŸãïŒ366è¡ç®ã367è¡ç®ãšæ¥ãŠããããªã369è¡ç®ã«é£ãã§ããŠãç®èŠã§ç¢ºèªãã«ããïŒãããã§äžèšã®ã°ã«ãŒãåã§æããããã§ãããã°è¡çªå·/åçªå·ã®å€åŽã«ãïŒ/ïŒãã®ããã¯ã¹ã衚瀺ãããã®ã§ãé衚瀺ã«ããŠããŠãããã«é衚瀺ã®é åããããã ãªãšç°¡åã«èŠèªããããšãã§ããŸãããŠãŒã¶ãŒç®ç·ã«ç«ã£ã䜿ãåããããéã«å°å³ã«äœ¿ããŸãã -
é¢æ°/æ°åŒåã
INDEXïŒMATCH
ã- åºæ¬äžã®åºæ¬ãªãã§ãããæ°åç ä¿®ã§ã»ãšãã©ã®äººãèŠããã§å«ãã«ãªããŸãããã ã»ãšãã©ã®ããŒã¿ã¯ã¬ã³ãžã³ã°æ¥åã§å¿ ããšèšã£ãŠããã»ã©äœ¿ããŸãããæ £ããã°ãããªã«é£ããããšã¯ããŠããªããšåããã®ã§å埩ããã®ã¿ã§ãã
Â
SUMIFãCOUNTIF
ã- åäžã
Â
ã°ã©ãã«ãããããŒã¿é åããã©ãã°ããç¶æ 㧠AltïŒF1ïŒã°ã©ããå°ãµã€ãºã§æ¿å ¥
ã- F11 ã§ãã°ã©ãæ¿å ¥ã§ããŸãããã·ãŒãã§ã®æ¿å ¥ã«ãªãã®ã§ãã«ãExcelããã«ãããŒã¿ã«ãªããšåºåãŸã§ã«æéããããã±ãŒã¹ããããŸããAltïŒF1 ãªãåºæ¬çã«ã©ã°ãªãã§åºåããŠãããã®ã§ãã¹ããŒãã£ãŒã«ããŒã¿ã®åœ¢ç¶ã»ãã¬ã³ãã確èªãããå Žåã«ãã䜿ããŸãã
CtrlïŒG â AltïŒSïŒéžæãªãã·ã§ã³
ã- ããé åã®äžã§ãã©ãããã¿æã¡ã§ã©ããæ°åŒãªã®ããããšèŠãŠå€æãä»ããªãå ŽåãCtrlïŒG â AltïŒS ã®ããšã« O (å®æ°) ãéžã¹ã°ãé åã®äžã§ãã¿æã¡ã«ãªã£ãŠããã»ã«ã ããã¢ã¯ãã£ãã«ããããšãã§ããŸãããã®ç¶æ 㧠Delete ããã°æ°åŒã»ã«ã ããæ®ããããªããŠããæäœã®éã«ãã䜿ããŸãã
ã- ãŸãã¯ãããåã®ãªãã§ãèŠçŽ â ãã°ããç©ºçœ â èŠçŽ â ãã°ããç©ºçœ â èŠçŽ â .... ããšãªã£ãŠããŠãèŠçŽ ã®éšåã ãã»ã«ãã©ãŒããããå€ãããå Žåãã1ã€ç®ã®èŠçŽ ã®ãã©ãŒããããå€ããŠã³ããŒããŠæ¬¡ã®èŠçŽ ã«ããŒã¹ãããŠã次ã®ã«ãããŒã¹ãããŠã次ã®ã«ããããããšãããšé¢åãªã®ã§ããCtrlïŒSpace ã§åéžæ â CtrlïŒG â AltïŒS â O ãã§èŠçŽ ã ããã¹ãŠã¢ã¯ãã£ãã«ãªãããã®ç¶æ ã§ãã©ãŒãããå€æŽã1床ã ãè¡ãã°ãã¹ãŠã®èŠçŽ ãåããã©ãŒãããã«å€æŽã«ãªããŸãã -
æäœåã
CtrlïŒPgUp/PgDnïŒã·ãŒã移å
CtrlïŒShiftïŒPgUp/PgDnïŒã·ãŒããè€æ°éžæCtrlïŒç¢å°ïŒä»ããã»ã«ãèŠçŽ ããïŒãªãïŒãªãèŠçŽ ããïŒãªãïŒã®é åã®çµãããŸã§ãžã£ã³ã
CtrlïŒShiftïŒç¢å°ïŒèŠçŽ ã®çµãããŸã§ãã©ãã°ã- ã»ã«é移åã¯åºæ¬çã«ããã§è¡ããŸããããŠã¹ã¯æäœéã«ãšã©ããŸãã
PgUp/PgDnïŒã·ãŒãã®äžäžæ¹åã«ã¹ã¯ããŒã«
AltïŒPgUp/PgDnïŒã·ãŒãã®å·Šå³æ¹åã«ã¹ã¯ããŒã«
ã- 1ã€ç®ã¯ç¥ã£ãŠãã人ãå€ãã§ãã2ã€ç®ã®å·Šå³æ¹åã¯ã¡ãããšäœ¿ããŠã人å°ãªãã€ã¡ãŒãžã§ãã
Â
CtrlïŒAltïŒVïŒåœ¢åŒãéžæããŠè²Œãä»ã
ã- CtrlïŒV ã¯å€§åŠçã§ã䜿ããŸããã圢åŒéžæããŠè²Œãä»ãã¯å°å³ã«å®åã§å€çšããŸãããæ°åŒã®ã¿ãã³ãããããã ãã§ã眫ç·ããã©ãŒãããã¯ã³ããããããªããã£ãŠãšãã«ã¯ãCtrlïŒAltïŒVâFâEnter ã§ãéã«ãã©ãŒãããã ãã»ãããšãã«ã¯Â CtrlïŒAltïŒVâTâEnterãåå¹ ã ãã³ããŒããããšãã«ã¯CtrlïŒAltïŒVâWâEnterããããã¯ãã䜿ããŸãã
Â
CtrlïŒSpaceïŒåéžæ
ShiftïŒSpaceïŒè¡éžæ
ã- ãããå°å³ã«å€çšããŸããã¡ãªã¿ã«æ¥æ¬èªå ¥åã ãš ShiftïŒSpace ãå¹ããªãããšãããã®ã§ããã解決æ³ãããã®ã§äžèšãµã€ãçåèã«ããŠã¿ãŠãã ããã
Microsoft IMEã®è©³çŽ°èšå®ïŒœ
https://forest.watch.impress.co.jp/docs/serial/exceltips/1151466.html
Â
è¡/å ãã³ããŒããç¶æ 㧠CtrlïŒShiftïŒ(ïŒ)ïŒè¡/å ãæ¿å ¥
ã- ãããå³ã¯ãªãã¯ããŠæ¿å ¥ã ãšé ããŠæ ãã®ã§èŠãããšéå®ããŸãã
Â
ç»é¢äžéšã®ã·ãŒãæ¬ã®å·Šç«¯ã«ãããââ·ãã§å³ã¯ãªãã¯ïŒã·ãŒãäžèŠ§è¡šç€º
ã- 人ã«ãã£ãŠã¯ãã¯ããçµã人ãããŸãããæäœéãã®å³ã¯ãªãã¯åŠçã§é ãé¢ããã·ãŒãéã®ç§»åã¯å¯Ÿå¿ã§ããŸãã
----------------------------------------------
Â
ãŸãã¯ç¥èãšããŠèããŠããã£ãŠãããšã¯å®è·µã§ã¬ã³ã¬ã³å€çšããŠããã°ããã«æ £ãããšæããŸãã