[B! Excel] h_sabakanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

h_sabakan id:h_sabakan

Excelã«é–¢ã™ã‚‹h_sabakanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{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}}

MS Officeã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã«æ–°ãŸãªè„†å¼±æ€§ã€ã‚¼ãƒãƒ‡ã‚¤æ”»æ’ƒãŒç™ºç”Ÿ
IEã§Excelã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’è¡¨ç¤ºã™ã‚‹ãŸã‚ã®ActiveXã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã«è„†å¼±æ€§ãŒå˜åœ¨ã™ã‚‹ã€‚ç´°å·¥ã‚’æ–½ã—ãŸOfficeæ–‡æ›¸ã‚’ç‰¹å®šã®çµ„ç¹”ã«é€ã‚Šã¤ã‘ã‚‹æ”»æ’ƒã‚‚ç™ºç”Ÿã—ã¦ã„ã‚‹ã€‚ ç±³Microsoftã®è£½å“ã«æ–°ãŸãªæœªãƒ‘ãƒƒãƒã®è„†å¼±æ€§ãŒç¢ºèªã•ã‚ŒãŸã€‚åŒç¤¾ã¯7æœˆ13æ—¥ä»˜ã§ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚¢ãƒ‰ãƒã‚¤ã‚¶ãƒªãƒ¼ã‚’å…¬é–‹ã—ã€ã“ã®è„†å¼±æ€§ã‚’çªã„ãŸæ”»æ’ƒãŒæ—¢ã«ç™ºç”Ÿã—ã¦ã„ã‚‹ã¨ã—ã¦ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«å¯¾ç–ã‚’å‘¼ã³æŽ›ã‘ã¦ã„ã‚‹ã€‚ Microsoftã‚„SANS Internet Storm Centerã«ã‚ˆã‚‹ã¨ã€è„†å¼±æ€§ã¯Office Web Componentsã®ActiveXã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã«å˜åœ¨ã™ã‚‹ã€‚ã“ã‚Œã¯Internet Explorerï¼ˆIEï¼‰ã§Excelã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’è¡¨ç¤ºã™ã‚‹ãŸã‚ã«ä½¿ã‚ã‚Œã‚‹ã‚‚ã®ã ã¨ã„ã†ã€‚ æ‚ªç”¨ã•ã‚ŒãŸå ´åˆã€æ”»æ’ƒè€…ãŒãƒãƒ¼ã‚«ãƒ«ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨åŒã˜æ¨©é™ã‚’å–å¾—ã§ãã€IEã‚’ä½¿ãˆã°ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒä½•ã‚‚æ“ä½œã—ãªãã¦ã‚‚ã€ãƒªãƒ¢ãƒ¼ãƒˆã‹ã‚‰ã‚³ãƒ¼ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ãŒå¯èƒ½
h_sabakan 2009/07/14
*Security

*Microsoft

Internet Explorer

Excel
ãƒªãƒ³ã‚¯
[Think IT] ç¬¬4å›žï¼šExcelã«ã‚ˆã‚‹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆä½œæˆã«åŠ¹ãTIPSï¼ (1/3)
ã€æ¥½ã€…ãƒ‡ãƒ–ãƒ‰ãƒƒã‚¯ã‚’æ›¸ã“ã†ï¼ã€‘ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆä½œæˆã®æŠ€ ç¬¬4å›žï¼šExcelã«ã‚ˆã‚‹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆä½œæˆã«åŠ¹ãTIPSï¼ è‘—è€…ï¼šã‚·ã‚¹ãƒ†ãƒ ã‚¤ãƒ³ãƒ†ã‚°ãƒ¬ãƒ¼ã‚¿ å®‰æ²» ç†ä¹‹ å…¬é–‹æ—¥ï¼š2008/02/26ï¼ˆç«ï¼‰ çŸ¥ã£ã¦ã‚‹ã¨å·®ãŒã¤ãExcelã®å°æŠ€ ã•ã¾ã–ã¾ãªé–‹ç™ºãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®ä½œæˆãƒ„ãƒ¼ãƒ«ã‚’é¸æŠžã™ã‚‹éš›ã®æ³¨æ„ç‚¹ã¨ã—ã¦ã€ä¸€éƒ¨ã¾ãŸã¯å…¨ç¨®é¡žãŒãŠå®¢æ§˜ã«ç´å“ã™ã‚‹æ–‡æ›¸ã¨ã—ã¦æŒ‡å®šã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã“ã¨ã«ç•™æ„ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ãã®ä¸Šã§ã€ä½•å¹´ã‚‚ä¿å®ˆå¥‘ç´„ãŒç¶šãå ´åˆãªã©ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®èƒŒæ™¯ã‚’æƒ³å®šã—ã€ä½¿ç”¨ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã‚„æ‹…å½“è€…ã®å¤‰æ›´ãªã©ã€å¾Œã€…ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹å·¥æ•°ã‚‚å«ã‚ã¦é–‹ç™ºãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆä½œæˆãƒ„ãƒ¼ãƒ«ã‚’ç–å®šã—ã¾ã™ã€‚ã“ã®ã‚ˆã†ãªæ¡ä»¶ã‚’è¸ã¾ãˆã‚‹ã¨ã€é–‹ç™ºãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯ãŠå®¢æ§˜ã‚‚å«ã‚ã¦èª°ã‚‚ãŒç¢ºèªï¼ç·¨é›†ã§ãã‚‹ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã§ã‚ã‚‹äº‹ãŒæœ›ã¾ã—ãã€ãªãŠã‹ã¤ã•ã¾ã–ã¾ãªãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¨é€£æºã§ãã€åŠ å·¥ã‚„é›†è¨ˆãŒå®¹æ˜“ã§ã‚ã‚‹ã“ã¨ãŒè‚è¦ãªç‚¹ã¨ãªã‚Šã¾ã™ã€‚ ãã®æ„å‘³ã§Excelã¯ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®é›†
h_sabakan 2009/05/01
Excel

tips
ãƒªãƒ³ã‚¯
Excelã«æœªä¿®æ£ã®è„†å¼±æ€§ã€æ‚ªç”¨ãƒ•ã‚¡ã‚¤ãƒ«ãŒæ—¥æœ¬ã§ç™ºè¦‹
Excelã®æœªä¿®æ£ã®è„†å¼±æ€§ã‚’çªã„ã¦ãƒˆãƒã‚¤ã®æœ¨é¦¬ã‚’ä»•è¾¼ã‚“ã ä¸æ£ãªExcelã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆãŒæ—¥æœ¬ã§è¦‹ã¤ã‹ã£ã¦ã„ã‚‹ã€‚ Office Excelã«æœªä¿®æ£ã®è„†å¼±æ€§ãŒè¦‹ã¤ã‹ã‚Šã€ç±³MicrosoftãŒ2æœˆ24æ—¥ä»˜ã§ã‚¢ãƒ‰ãƒã‚¤ã‚¶ãƒªãƒ¼ã‚’å…¬é–‹ã—ãŸã€‚ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ä¼æ¥ã®Symantecã«ã‚ˆã‚Œã°ã€ã“ã®è„†å¼±æ€§ã‚’çªã„ãŸæ‚ªè³ªãªã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆãŒæ—¥æœ¬ã§å‡ºå›žã£ã¦ã„ã‚‹ã€‚ Microsoftã«ã‚ˆã‚‹ã¨ã€è„†å¼±æ€§ã®å½±éŸ¿ã‚’å—ã‘ã‚‹ã®ã¯Office 2000ï¼2002ï¼2003ï¼2007ã¨ã€Macç‰ˆã®Office 2004ï¼2008ã€Open XML File Format Converter for Macã®å„è£½å“ã€‚ç´°å·¥ã‚’æ–½ã—ãŸExcelãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒé–‹ãã¨ã€ãƒªãƒ¢ãƒ¼ãƒˆã§ã‚³ãƒ¼ãƒ‰ã‚’å®Ÿè¡Œã•ã‚Œã‚‹æã‚ŒãŒã‚ã‚‹ã€‚ ç¾æ™‚ç‚¹ã§ã¯ã€Œé™å®šçš„ãªã‚¿ãƒ¼ã‚²ãƒƒãƒˆåž‹æ”»æ’ƒã€ãŒèµ·ãã¦ã„ã‚‹ã¨Microsoftã¯èª¬æ˜Žã€‚ç¾åœ¨ã€è„†å¼±æ€§è§£æ±ºã®ãŸã‚ã®ãƒ‘ãƒƒãƒã‚’é–‹ç™ºä¸ã§ã€è‡¨æ™‚ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼
h_sabakan 2009/02/25
*Security

*Microsoft

Excel
ãƒªãƒ³ã‚¯
ï¼ƒ002 Excelã§å¿«é©ãƒ‡ãƒ¼ã‚¿å‡¦ç†ï¼
ä»•äº‹ã®åŠ¹çŽ‡ã‚¢ãƒƒãƒ—ã‚’ãŠæ‰‹ä¼ã„ã™ã‚‹ã€ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆãªã©ã‚’ä¸€è¦§ã«ã¾ã¨ã‚ãŸãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ã‚·ãƒ¼ãƒˆã€‚ä»Šå›žã¯Excelæ“ä½œã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚’PDFã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ã‚·ãƒ¼ãƒˆç¬¬2å¼¾ã¯Excelã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã§ã™ã€‚ã‚»ãƒ«ã®ç§»å‹•ã‚„ãƒ‡ãƒ¼ã‚¿ã®æ›¸å¼è¨å®šãªã©ã€æ™®æ®µä½¿ã„ãã†ãªã‚‚ã®ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ã“ã‚Œã‚‰ã‚’è¦šãˆã¦ã•ãã•ãã¨ä»•äº‹ã‚’ã“ãªã—ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ ãã‚Œãžã‚Œã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã«ã¯ãƒã‚§ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã‚’ä»˜ã‘ã¦ãŠãã¾ã—ãŸã€‚ç¿’å¾—ã—ãŸã‚‚ã®ã‹ã‚‰ãƒã‚§ãƒƒã‚¯ã—ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ã“ã®ã‚·ãƒ¼ãƒˆã¯å°åˆ·ã—ã€è¦‹ãˆã‚‹ã¨ã“ã‚ã«è²¼ã£ã¦ãŠãã¾ã™ã€‚è‡ªåˆ†ãŒä½•ã‚’ç¿’å¾—ã—ã¦ã„ã¦ã€ä½•ã‚’ç¿’å¾—ã—ã¦ã„ãªã„ã‹ã‚’æŠŠæ¡ã—ã¤ã¤ã€å®Œå…¨ã«ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ã¾ã§ä½•åº¦ã‚‚è¦‹è¿”ã—ã¦ã¿ã‚‹ã¨ã‚ˆã„ã§ã™ã‚ˆã€‚
h_sabakan 2009/01/20
Life Hack

Excel
ãƒªãƒ³ã‚¯
TechNet Script Center
Summary: Using PowerShell to identify RPC ports in use by capturing content from PowerShell We'd like to introduce you today to one of our newest bloggers!Â It's a froopingly awesome friend of ours, Joel Vickery, PFE.Â (did I mention Dr. Scripto is a big fan of books written by Douglas Adams?....oops!) Take it away Joel! Thanks Doc!Â So ...
h_sabakan 2007/07/30
*Microsoft

TechNet
ãƒªãƒ³ã‚¯
3åˆ†LifeHackingï¼šå…¥åŠ›ã®æ‰‹é–“ã‚’çœãã€10ã®Excelã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆ - ITmedia Biz.ID:
Excelã«ã€æ¯Žæ—¥æ–‡å—ã‚„æ•°å—ã‚’å…¥åŠ›ã—ã¦ã„ã‚‹â”€â”€ãã‚“ãªãƒ“ã‚¸ãƒã‚¹ãƒ‘ãƒ¼ã‚½ãƒ³ã‚‚å¤šã„ã“ã¨ã ã‚ã†ã€‚å°‘ã—ã§ã‚‚å…¥åŠ›ã‚’æ—©ãã€ç°¡å˜ã«ã—ãŸã„ã€‚ãã‚“ãªã¨ãã¯ã€Excelã«å‚™ã‚ã£ã¦ã„ã‚‹ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚’ã†ã¾ãæ´»ç”¨ã—ãŸã„ã€‚ 1â”€â”€æ—¥ä»˜ã¨æ™‚åˆ» ï¼»Crtlï¼½ï¼‹ï¼»ï¼›ï¼½ã‚’æŠ¼ã™ã¨ã€ä»Šæ—¥ã®æ—¥ä»˜ãŒã€‚ï¼»Crtlï¼½ï¼‹ï¼»ï¼šï¼½ã‚’æŠ¼ã™ã¨ã€ç¾åœ¨ã®æ™‚åˆ»ãŒå…¥åŠ›ã•ã‚Œã‚‹ã€‚ æ¥å‹™è¨˜éŒ²ãªã©ã‚’ä»˜ã‘ã¦ã„ãéš›ã«ã¯ã€ã“ã‚Œã‚’ä½¿ãˆã°ç°¡å˜ã«æ—¥ä»˜ã‚„æ™‚åˆ»ã‚’å…¥åŠ›ã§ãã‚‹ã€‚ã€Œnowã€é–¢æ•°ã¨é•ã†ã®ã¯ã€å…¥åŠ›ã—ãŸæ™‚ç‚¹ã®æ—¥ä»˜ãƒ»æ™‚åˆ»ãŒå›ºå®šã•ã‚Œã‚‹ã“ã¨ã ã€‚ 2â”€â”€ç¹°ã‚Šè¿”ã—ä½œæ¥ ã›ã£ã‹ãã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã ã‹ã‚‰ã€åŒã˜ã‚ˆã†ãªä½œæ¥ã¯è‡ªå‹•çš„ã«ã‚„ã£ã¦ã»ã—ã„ã€‚è¤‡é›‘ãªä½œæ¥ã§ã€ä»Šå¾Œã‚‚ç¹°ã‚Šè¿”ã—ä½¿ã†ãªã‚‰ã€ãƒžã‚¯ãƒã‚’æ›¸ãã¨ã„ã†ã‚ˆã†ãªé¸æŠžã‚‚ã‚ã‚‹ã ã‚ã†ãŒã€ã¡ã‚‡ã£ã¨ã—ãŸå¤‰æ›´â”€â”€ä¾‹ãˆã°ã€ã‚»ãƒ«ã‚’1è¡ŒãŠãã«è‰²ã‚’ä»˜ã‘ãŸã„â”€â”€ãªã‚“ã¦ã¨ãã¯ã€ï¼»F4ï¼½ã‚ãƒ¼ã‚’ä½¿ã†ã€‚ æœ€åˆã®ã‚»ãƒ«ã«å¯¾ã—ã¦æ“ä½œã‚’è¡Œã„ã€åŒã˜æ“ä½œã‚’ã—ãŸã„ã‚»ãƒ«ã‚’é¸ã‚“ã§ï¼»F4
h_sabakan 2007/05/11
ã‚,æ¤ã‚Œã¯ä¾¿åˆ©ãªã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆé›†ã :).

Excel

tips
ãƒªãƒ³ã‚¯
1