[B! excel] NOKTã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

NOKT id:NOKT

excelã«é–¢ã™ã‚‹NOKTã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

åˆå¿ƒè€…ã§ã‚‚å›³è§£ã§åˆ†ã‹ã‚‹ï¼ VBEã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã¨VBAãƒ—ãƒã‚°ãƒ©ãƒ ã®åŸºç¤Žæ–‡æ³•
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°åˆå¿ƒè€…ã‚’å¯¾è±¡ã«Excelãƒžã‚¯ãƒï¼VBAã‚’ä½¿ã£ãŸæ¥å‹™è‡ªå‹•åŒ–ãƒ—ãƒã‚°ãƒ©ãƒ ã®ä½œã‚Šæ–¹ã‚’ä¸€ã‹ã‚‰è§£èª¬ã™ã‚‹æœ¬é€£è¼‰ã€ŒExcelãƒžã‚¯ãƒï¼VBAã§å§‹ã‚ã‚‹æ¥å‹™è‡ªå‹•åŒ–ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å…¥é–€ã€ã€‚å‰å›žã®ã€ŒExcelã§ãƒ—ãƒã‚°ãƒ©ãƒ ä½œæˆã‚’å§‹ã‚ã‚‹ãƒ¡ãƒªãƒƒãƒˆã¨ãƒžã‚¯ãƒã®åŸºæœ¬ã€ã§ã¯ã€ãã‚‚ãã‚‚ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã¨ã¯ä½•ã‹ã€Visual Basicã¨VBAã¨ãƒžã‚¯ãƒã®é•ã„ã€ãƒžã‚¯ãƒã®ä½œã‚Šæ–¹ã€ä¿å˜ï¼å‰Šé™¤ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£è¨å®šãªã©ã«ã¤ã„ã¦è§£èª¬ã—ãŸã€‚ ä»Šå›žã¯Excel VBAãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®åŸºæœ¬çš„ãªç”¨èªžè§£èª¬ã‚’ãƒ¡ã‚¤ãƒ³ã«ã€VBEï¼ˆVisual Basic Editorã€VBã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ï¼‰ã®ç”»é¢æ§‹æˆã‚„ä½¿ã„æ–¹ã‚‚è§£èª¬ã™ã‚‹ã€‚ãƒ—ãƒãƒ‘ãƒ†ã‚£ã€ãƒ¡ã‚½ãƒƒãƒ‰ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãªã©å°‚é–€ç”¨èªžãŒå‡ºã¦ãã‚‹ãŒã€ã§ãã‚‹ã ã‘åˆ†ã‹ã‚Šã‚„ã™ãè§£èª¬ã—ãŸã„ã¨æ€ã†ã€‚ã©ã†ã‹ã€å«Œã«ãªã‚‰ãšã«ç€ã„ã¦ãã¦ã»ã—ã„ã€‚ ã“ã‚Œã‚‰ã®ç”¨èªžã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’ã™ã‚‹ä¸Šã§ã¯å¿…ãšå‡ºã¦ãã‚‹ã‚‚ã®ã§ã‚ã‚Šã€æ„å‘³ã‚’çŸ¥ã‚‰ãšã—ã¦ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã™ã‚‹ã“ã¨
NOKT 2014/03/30
excel

vba

programming

office

ä»•äº‹
ãƒªãƒ³ã‚¯
http://xls.usagifrask.com/
NOKT 2009/06/12
2ch

ã“ã‚Œã¯ã™ã”ã„

excel

webservice
ãƒªãƒ³ã‚¯
2009å¹´ï¼ˆå¹³æˆ21å¹´ï¼‰ç‰ˆã‚¨ã‚¯ã‚»ãƒ«ã‚·ãƒ³ãƒ—ãƒ«å®¶è¨ˆç°¿ï¼ˆã„ã¤ã‚‚ã®ãã‚Šã‚“ã¨ã†ã•ãŽï¼‰
æ¯Žå¹´æ’ä¾‹ã®å®¶è¨ˆç°¿ç”¨ã‚¨ã‚¯ã‚»ãƒ«2009å¹´ç‰ˆãŒã§ãã¾ã—ãŸã€‚ ä»Šå¹´ã‚‚æ‰‹æ›¸ãã‚¿ã‚¤ãƒ—ã¨æ¼”ç®—ã‚¿ã‚¤ãƒ—ã®ï¼’ç¨®é¡žã‚’é…å¸ƒã—ã¾ã™ã€‚ ã‚¨ã‚¯ã‚»ãƒ«ç”¨ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãªã®ã§ã€æ–°è¦ã«æ“ä½œã‚’ãŠã¼ãˆã‚‹å¿…è¦ã‚‚ãªãã€ è‡ªåˆ†ä»•æ§˜ã«ç´°ã‹ã„æ”¹é€ ãƒ»ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã‚’æ–½ã™ã“ã¨ã‚‚ã§ãã¾ã™â™ª æ—¥ã€…è¨˜å¸³ã™ã‚‹ã ã‘ã§ã“ã€œã‚“ãªã‚°ãƒ©ãƒ•ãŒè‡ªå‹•ã§æã‘ã¡ã‚ƒã†æ©Ÿèƒ½ä»˜ãï¼ï¼ˆæ¼”ç®—ã‚¿ã‚¤ãƒ—ã®ã¿ï¼‰ ä¸€æ˜¨å¹´ã‹ã‚‰ã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ä½¿ç”¨æ¬„ã‚‚ã¤ãã¾ã—ãŸã€‚ æ¼”ç®—ã‚¿ã‚¤ãƒ—ã®å ´åˆã¯ã€ã“ã“ã«è¨˜å¸³ã™ã‚‹ã ã‘ã§ç·è¨ˆã«åæ˜ ã•ã‚Œã¾ã™ã€‚ æ‰‹æ›¸ãã‚¿ã‚¤ãƒ—ã®å ´åˆã¯ã€å¿…è¦æžšæ•°ã‚’é©å®œãƒ—ãƒªãƒ³ãƒˆã‚¢ã‚¦ãƒˆã—ã¦ãŠä½¿ã„ãã ã•ã„ ï¼ˆã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰æ¬„ã®ä½¿ã„æ–¹ï¼‰ã€‚ å°åˆ·ã—ã¦ãŠä½¿ã„ã«ãªã‚‹æ–¹ã¯æ‰‹æ›¸ãã‚¿ã‚¤ãƒ—ã€ãƒ‘ã‚½ã‚³ãƒ³ä¸Šã§è¨˜å…¥ã—ãŸã„æ–¹ã¯æ¼”ç®—ã‚¿ã‚¤ãƒ—ã€ ãŠå¥½ã¿ã®ã‚¿ã‚¤ãƒ—ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ãŠä½¿ã„ãã ã•ã„ ï¼ˆãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰æ–¹æ³•ï¼‰ã€‚ å®¶è¨ˆç°¿ã®ç‰¹å¾´ ã“ã®å®¶è¨ˆç°¿ã®æœ€å¤§ã®ç‰¹å¾´ã¯ã€ ä¸€æœˆã«ã¤ãã€A4ã®ç´™ä¸€æžšã—ã‹ä½¿ã‚ãªã„ã“ã¨ã§ã™ã€‚ ãã‚Œä»¥å¤–ã«ã•ã—ãŸã‚‹ç‰¹å¾´ã¯ã‚ã‚Šã¾ã›
NOKT 2009/04/02
excel

å®¶è¨ˆç°¿
ãƒªãƒ³ã‚¯
å…¥åŠ›è¦å‰‡ã®ä½¿ã„æ–¹ï¼šExcelåŸºæœ¬è¬›åº§
å…¥åŠ›è¦å‰‡ã®è¨å®šæ–¹æ³•ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€Topã¸ ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã§ã®ã‚¨ã‚¯ã‚»ãƒ«ã¸ã®å…¥åŠ›ã¯è‰¯ãé–“é•ã†ã‚‚ã®ã§ã™ã€‚ (ã‚¨ã‚¯ã‚»ãƒ«ã§ã¯ã‚»ãƒ«ã‚’é¸æŠžã—ãŸçŠ¶æ…‹ã§ã‚ãƒ¼ã‚’æŠ¼ã™ã¨ä¸Šæ›¸ã§å…¥åŠ›ã•ã‚Œã¾ã™) å…¥åŠ›ã•ã‚Œã‚‹å€¤ãŒã‚ã‚‰ã‹ã˜ã‚æ±ºã¾ã£ã¦ã„ã‚‹å ´åˆã«ã¯ã€ç•°ãªã‚‹å€¤ãŒå…¥åŠ›ã•ã‚Œãªã„ã‚ˆã†ã«å…¥åŠ›å€¤ã‚’åˆ¶é™ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã€æ³¨æ„ã€‘å…¥åŠ›è¦å‰‡ã‚’è¨å®šã—ã¦ã‚‚ä»¥ä¸‹ã®æ–¹æ³•ã§ç„¡åŠ¹ãªå€¤ã‚’å…¥åŠ›ã§ãã¦ã—ã¾ã„ã¾ã™ã€‚ (ç„¡åŠ¹ãªå€¤ã‚’èª¿ã¹ã‚‹æ–¹æ³•) ä»–ã®ã‚»ãƒ«ã®å€¤ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦å½¢å¼ã‚’é¸æŠžã—ã¦è²¼ã‚Šä»˜ã‘ã§ã€Œå€¤ã€ã‚’è²¼ä»˜ã‘ã‚‹ã€‚ ãªãŠã€å˜ã«ã‚³ãƒ”ãƒ¼â†’è²¼ä»˜ã‘ã ã¨ã‚³ãƒ”ãƒ¼å…ƒã¨åŒã˜è¨å®šã«ãªã‚Šã€å…¥åŠ›è¦å‰‡ã‚‚æ¶ˆãˆã¦ã—ã¾ã„ã¾ã™ã€‚ è¨ˆç®—å¼ã‚’å…¥åŠ›ã™ã‚‹ã€‚ æœ€åˆã«å…¥åŠ›ã—ãŸè¨ˆç®—çµæžœãŒå…¥åŠ›è¦å‰‡ã«åˆè‡´ã—ãªã„æ™‚ã¯æ£å¸¸ã«æ©Ÿèƒ½ãŒåƒããŒã€ä»¥é™ã«åˆè‡´ã—ãªã„å€¤ã¨ãªã£ã¦ã‚‚æ©Ÿèƒ½ã¯åƒã‹ãšä¸æ£ãªå€¤ãŒå…¥åŠ›ã•ã‚Œã¦ã—ã¾ã†ã€‚ ãƒžã‚¯ãƒ(VBA)ã§å€¤ã‚’å…¥åŠ›ã™ã‚‹ã€‚ ã€è¨å®šä¾‹ã€‘æœˆæ•°ã®å…¥åŠ›æ¬„ã«1æœˆã‹ã‚‰12æœˆã®ã€Œ1ï½ž12ã®æ•´æ•°å€¤ã€ã—ã‹å…¥åŠ›ã§ããª
NOKT 2009/03/03
excel

ä»•äº‹

å…¥åŠ›è¦å‰‡
ãƒªãƒ³ã‚¯
Excel:å…¥åŠ›è¦å‰‡ã®è¨å®š
NOKT 2009/03/03
excel

å…¥åŠ›æ”¯æ´
ãƒªãƒ³ã‚¯
æ°—è±¡æƒ…å ±ã®å–å¾—ã¨è¨˜éŒ²â€•â€•VBScriptã§Excelã‚’æ“ä½œã™ã‚‹
ä»Šå›žã®ä¸»å½¹ã¯VBScriptã§ã™ã€‚ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆçµŒç”±ã§ç©ºæ¸¯ã®æ°—è±¡æƒ…å ±ã‚’å–ã‚Šè¾¼ã¿ï¼Œå–ã‚Šè¾¼ã‚“ã ãƒ‡ãƒ¼ã‚¿ã®ä¸ã‹ã‚‰æ°—æ¸©ã¨æ°—åœ§ã‚’Excelã‚·ãƒ¼ãƒˆã«æ›¸ãå‡ºã—ã¾ã™ã€‚Excelã®èµ·å‹•ï¼Œã‚»ãƒ«ã¸ã®æ›¸ãå‡ºã—ï¼Œçµ‚äº†ã‚‚VBScriptã«ã‚„ã‚‰ã›ã¾ã™ã€‚VBScriptã®ä¸ã«æ›¸ã‹ã‚ŒãŸExcel/VBAã®ã‚³ãƒ¼ãƒ‰ãŒå®Ÿè¡Œã•ã‚Œã¦ã„ãæ§˜ã‚’ã”è¦§ãã ã•ã„ã€‚VBScriptæã‚‹ã¹ã—ã§ã™ã€‚ ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã«ã‚ã‚Šãã†ã§ãªã„ã‚‚ã®ã¨ã—ã¦æ°—è±¡é–¢ä¿‚ã®ãƒ‡ãƒ¼ã‚¿ãŒã‚ã‚Šã¾ã™ã€‚å¤©æ°—äºˆå ±ã¯ã‚ã£ã¦ã‚‚ï¼Œç¾åœ¨ã®æ°—æ¸©ã‚„æ°—åœ§ã®ãƒ‡ãƒ¼ã‚¿ã ã‘ã‚’æä¾›ã—ã¦ã„ã‚‹ã¨ã“ã‚ã¯æ„å¤–ã«è¦‹ã¤ã‹ã‚Šã¾ã›ã‚“ã€‚ä»Šå›žã¯ï¼Œç±³æµ·æ´‹å¤§æ°—å±€ï¼ˆNOAAï¼šNational Oceanic ï¼† Atmospheric Administrationï¼‰ãŒæä¾›ã—ã¦ã„ã‚‹æ°—è±¡æƒ…å ±ã‚’å–ã‚Šä¸Šã’ã¾ã™ã€‚NOAAã¯ä¸–ç•Œä¸ã®ç©ºæ¸¯ã®æ°—è±¡ãƒ‡ãƒ¼ã‚¿ã‚’ï¼Œã€ŒMETARã€ï¼ˆMeteorological Aviaion Reportï¼Œå®šæ™‚èˆªç©ºæ°—è±¡å®Ÿæ³é€šå ±å¼
NOKT 2009/02/03
excel

vbscript

programming
ãƒªãƒ³ã‚¯
moug ã¸
COUNTIFã§è¨ˆç®—ç¯„å›²ã‚’åˆ¥ã‚·ãƒ¼ãƒˆã‹ã‚‰ä»»æ„ã«æŒ‡å®š æŠ•ç¨¿è€…: æ¡ƒå¤ªéƒŽï¼—Â Â 24/11/29 09:47:31 æœ€æ–°æŠ•ç¨¿è€…: æ¡ƒå¤ªéƒŽï¼—Â Â 24/11/30 08:23:09Â Â Â æŠ•ç¨¿è¨˜äº‹æ•°: 4 ä»¶Excel ï¼ˆä¸€èˆ¬æ©Ÿèƒ½ï¼‰ è§£æ±ºæ¸ˆãƒ†ãƒ¼ãƒ–ãƒ«ã§å¯å¤‰ã™ã‚‹é›†è¨ˆè¡Œã«æ¡ä»¶ä»˜ãæ›¸å¼ã‚’è¨å®šã—ãŸã„ æŠ•ç¨¿è€…: HibiscusÂ Â 24/11/27 00:28:13 æœ€æ–°æŠ•ç¨¿è€…: HibiscusÂ Â 24/11/30 01:38:35Â Â Â æŠ•ç¨¿è¨˜äº‹æ•°: 9 ä»¶Excel ï¼ˆä¸€èˆ¬æ©Ÿèƒ½ï¼‰ è§£æ±ºæ¸ˆvb.net me.refresh æŠ•ç¨¿è€…: baggio1824Â Â 24/11/29 22:49:05 æœ€æ–°æŠ•ç¨¿è€…: baggio1824Â Â 24/11/29 22:49:05Â Â Â æŠ•ç¨¿è¨˜äº‹æ•°: 1 ä»¶ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚° å›žç” å—ä»˜ä¸VLOOKUPã§è¡Œç•ªå·ã‚’æŒ‡å®šã—ãŸå€¤ã‚’æ±‚ã‚ãŸã„ã§ã™ã€‚ æŠ•ç¨¿è€…: æ¡ƒå¤ªéƒŽï¼—Â Â 24/11/29 14:
NOKT 2009/02/03
vba

excel

access
ãƒªãƒ³ã‚¯
ãƒ‰ãƒ©ãƒƒã‚°ï¼†ãƒ‰ãƒãƒƒãƒ—ã•ã‚ŒãŸãƒ•ã‚¡ã‚¤ãƒ«åã‚’å–å¾— - shikaku's blog
Set objArgs = WScript.Arguments if objArgs.Count <> 1 then WScript.Echo "ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ‰ãƒ©ãƒƒã‚¯ã—ã¦ãã ã•ã„ã€‚ä¸€å€‹ã ã‘ã ã‚ˆ" WScript.Quit end if dim sInputFilename sInputFilename = objArgs(0) WScript.Echo sInputFilename
NOKT 2009/02/02
excel

vba
ãƒªãƒ³ã‚¯
Excel VBAã‚’ä½¿ã„å§‹ã‚ãŸäººã‹ã‚‰
ã“ã¡ã‚‰ã¯ç‹¬è‡ªãƒ‰ãƒ¡ã‚¤ãƒ³ã‹ã‚‰ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã€ãƒ•ãƒ¬ãƒƒãƒ„æŽ¥ç¶šå°‚ç”¨ä¼šå“¡ã¾ã§ãƒˆãƒ¼ã‚¿ãƒ«ã‚µãƒãƒ¼ãƒˆã®ãƒ—ãƒãƒã‚¤ãƒ€ãƒ¼ã€BiG-NETã§ã™ã€‚ ã„ã¤ã‚‚å¼Šç¤¾ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒšãƒ¼ã‚¸ã«ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã—ã¦é ‚ãã¾ã—ã¦ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ http://www.big.or.jp/~seto/vbaref/contents.htm 404 Not Found (ãƒ•ã‚¡ã‚¤ãƒ«ãŒè¦‹ã¤ã‹ã‚Šã¾ã›ã‚“) ç”³ã—è¨³ã”ã–ã„ã¾ã›ã‚“ãŒã€ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹è¦æ±‚ã•ã‚Œã¾ã—ãŸä¸Šè¨˜ãƒšãƒ¼ã‚¸ã¯ã€ç¾åœ¨ã‚¢ã‚¯ã‚»ã‚¹ãŒå‡ºæ¥ã¾ã›ã‚“ã€‚ å¼Šç¤¾ã§ã¯ã€ãªãœã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„ã®ã‹ã¨è¨€ã†ç¬¬ä¸‰è€…ã‹ã‚‰ã®ãŠå•ã„åˆã‚ã›ã«ã¯ãŠç”ãˆã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã›ã‚“ã€‚ ã‚‚ã—ã“ã®ãƒšãƒ¼ã‚¸ã®é–¢ä¿‚è€…ã‚’ã”å˜çŸ¥ã§ã—ãŸã‚‰ã€é€£çµ¡ã‚’å–ã£ã¦ã¿ã‚‹ã“ã¨ã‚’ãŠè–¦ã‚è‡´ã—ã¾ã™ã€‚ ä½•å’ã”å®¹èµ¦ä¸‹ã•ã„ã€‚
NOKT 2009/02/02
excel

vba

programming
ãƒªãƒ³ã‚¯
ãƒã‚§ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã®ä½œã‚Šæ–¹ã€Excelãƒ»ã‚¨ã‚¯ã‚»ãƒ«ã€‘
è§£èª¬è¨˜äº‹å†…ã®ç”»åƒã¯Excel 2013ã®ã‚‚ã®ã§ã™ãŒã€æ“ä½œæ–¹æ³•ã¯ä¸‹è¨˜ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§åŒã˜ã§ã™ã€‚ Excel 2013, 2010, 2007 Excelã§ãƒã‚§ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã‚’ä½œã‚‹ã®ã¯ã¨ã£ã¦ã‚‚ç°¡å˜ã§ã™ã€‚ ã§ã‚‚ã€æ“ä½œã®å‰ã«1ã¤ã ã‘æº–å‚™ãŒã‚ã£ã¦ã€ãã‚Œã¯ï¼»é–‹ç™ºï¼½ã‚¿ãƒ–ã‚’è¡¨ç¤ºã—ã¦ãŠãã“ã¨ã€‚ ï¼»é–‹ç™ºï¼½ã‚¿ãƒ–ã ã‘è¡¨ç¤ºã•ã›ãŸã‚‰ã€æ—©é€Ÿä½œæ¥ã«å…¥ã‚Šã¾ã™ï¼ ï¼»é–‹ç™ºï¼½ã‚¿ãƒ–ã€ï¼»ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ï¼½ã‚°ãƒ«ãƒ¼ãƒ—ã®ï¼»æŒ¿å…¥ï¼½ãƒœã‚¿ãƒ³ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã€ ï¼»ãƒ•ã‚©ãƒ¼ãƒ ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ï¼½ã®ï¼»ãƒã‚§ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ï¼ˆãƒ•ã‚©ãƒ¼ãƒ ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ï¼‰ï¼½ãƒœã‚¿ãƒ³ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆä¸Šã§ã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨ãƒ»ãƒ»ãƒ» ã‚ã£ã¨ã„ã†é–“ã«ãƒã‚§ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ãŒã§ãã¾ã—ãŸï¼ ä½•ã ã‹æ‹åæŠœã‘ã™ã‚‹ãã‚‰ã„ç°¡å˜ã§ã™ï¼ˆç¬‘ï¼‰ã€‚ ãƒã‚§ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã®è„‡ã«ã‚ã‚‹æ–‡å—ã¯è‡ªç”±ã«å¤‰æ›´ã§ãã¾ã™ã—ã€ã‚‚ã¡ã‚ã‚“æ¶ˆã—ã¦ã—ã¾ã£ã¦ã‚‚æ§‹ã„ã¾ã›ã‚“ã€‚ ã¾ãŸã€å…¥åŠ›ã—ãŸæ–‡å—ã®ä¸€éƒ¨ãŒæ¬ ã‘ã¦è¦‹ãˆã‚‹ã‚ˆã†ã ã£ãŸã‚‰ã€ã‚µã‚¤ã‚ºå¤‰æ›´ãƒãƒ³ãƒ‰ãƒ«ã«ãƒžã‚¦ã‚¹ãƒã‚¤ãƒ³ã‚¿ã‚’åˆ
NOKT 2008/11/19
excel

ä»•äº‹
ãƒªãƒ³ã‚¯
EXCELã§ã‚»ãƒ«ã«äº¤äº’ã«è‰²ã‚’ã¤ã‘ã‚‹ã«ã¯ï¼Ÿ - ï¼‘ã€äº¤äº’ã«å¡—ã‚Šã¤ã¶ã™ç¯„å›²ã‚’æŒ‡å®šã™ã‚‹ï¼’ã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰ã€Œæ›¸å¼ã€â†’ã€Œæ¡ä»¶ä»˜ãæ›¸å¼ã®è¨å®šã€ã‚’é¸æŠž... - Yahoo!çŸ¥æµè¢‹
ï¼‘ã€äº¤äº’ã«å¡—ã‚Šã¤ã¶ã™ç¯„å›²ã‚’æŒ‡å®šã™ã‚‹ ï¼’ã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰ã€Œæ›¸å¼ã€â†’ã€Œæ¡ä»¶ä»˜ãæ›¸å¼ã®è¨å®šã€ã‚’é¸æŠž ï¼“ã€æœ€åˆã®ãƒ—ãƒ«ãƒ€ã‚¦ãƒ³ã‚’ã€Œæ•°å¼ãŒã€ã«å¤‰æ›´ ï¼”ã€æ¬¡ã®ãƒœãƒƒã‚¯ã‚¹ã«ã€Œ =MOD(ROW(),2)=0 ã€ã¨å…¥åŠ› ï¼•ã€ï¼»æ›¸å¼ï¼½ãƒœã‚¿ãƒ³ã‚’æŠ¼ã—ã¦èƒŒæ™¯ã®è‰²ã‚’é¸æŠž ï¼–ã€ï¼»ï¼¯ï¼«ï¼½ã‚’æŠ¼ã—ã¦å®Ÿè¡Œ
NOKT 2008/11/19
excel

ä»•äº‹

yahoo!çŸ¥æµè¢‹
ãƒªãƒ³ã‚¯
ã¡ã‚‡ã£ã¨è¦šãˆã¦ãŠãã¨ä¾¿åˆ©ãªExcelã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆ5ã¤ | P O P * P O P
Excelã‚’ã‚ˆãåˆ©ç”¨ã™ã‚‹æ–¹ã¯è¦šãˆã¦ãŠãã¨ä¾¿åˆ©ãªã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã®ã”ç´¹ä»‹ã€‚ã¡ã‚‡ã£ã¨çŸ¥ã£ã¦ã„ã‚‹ã ã‘ã§æ ¼æ®µã«ä½œæ¥ã‚¹ãƒ”ãƒ¼ãƒ‰ãŒé€Ÿããªã‚‹ã“ã¨ã‚‚ã€‚TechJiveã‹ã‚‰ã®æƒ…å ±ã§ã™ã€‚ Â» Excel Keystrokes ï¼ˆvia TechJiveï¼‰ ã€ŒCtrl+Spaceã€ :ãã®åˆ—å…¨ä½“ã‚’é¸æŠžã€‚ ã€ŒShift+Spaceã€ :ãã®è¡Œå…¨ä½“ã‚’é¸æŠžã€‚ ã€ŒCtrl+çŸ¢å°ã‚ãƒ¼ã€ :ãƒ‡ãƒ¼ã‚¿ãŒå…¥åŠ›ã•ã‚Œã¦ã„ã‚‹ç¯„å›²ã®å…ˆé è¡Œï¼ˆâ†‘ ï¼‰ã€æœ«å°¾è¡Œï¼ˆâ†“ï¼‰ã€å³ç«¯åˆ—ï¼ˆâ†’ï¼‰ã€å·¦ç«¯åˆ—ï¼ˆâ†ï¼‰ã«ç§»å‹•ã€‚ ã€ŒCtrl+Page Up/Page Downã€ :ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆé–“ã®ç§»å‹•ã€‚ ã€ŒCtrl+Homeã€ :ãã®ã‚·ãƒ¼ãƒˆã®A1ã®ã‚»ãƒ«ã¸ç§»å‹•ï¼ˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦æž ã‚’å›ºå®šã—ã¦ã„ã‚‹å ´åˆã¯ã€ãã®ä¸‹ã®ã‚»ãƒ«ï¼‰ã€‚ ã¡ãªã¿ã«å€‹äººçš„ã«ã‚ˆãä½¿ã†ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã§ã—ã‚‡ã†ã‹ã€‚ ã€ŒCtrl+1ã€ :ã‚»ãƒ«ã®æ›¸å¼è¨å®šã‚’é¸æŠžã€‚ ã€ŒShift+Enterã€ :ä¸Šã®è¡Œ/å·¦ã®åˆ—ã«ç§»å‹•ï¼ˆ
NOKT 2008/09/30
ãŠå½¹ç«‹ã¡

ã“ã‚Œã¯ä¾¿åˆ©

excel

ä»•äº‹

ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆ
ãƒªãƒ³ã‚¯
1