CINXE.COM

<!DOCTYPE html> <html lang="ja" id="arve" xmlns:og="http://ogp.me/ns#" > <head> <meta charset="UTF-8"> <title>Excelの便利な使い方まとめ【NAVERまとめ】 | ひらめき箱</title>  <meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=1" />  <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <link rel="pingback" href="http://fta7.jp/blog/xmlrpc.php" />   <meta name="description" content="何これすごい便利！こういうのは、気づいたときにさらーっとよむと、「ああ、そうだ、こういう機能探してたー！」ってのが見つかってすごく良い。Excelの機能って、ぐぐるのが結構難しいので、「偶然の出会い」っていうのが結構重要なんだよね…！ Excelの使い方" /> <link rel="canonical" href="http://fta7.jp/excel" />  <link rel="alternate" type="application/rss+xml" title="ひらめき箱 » フィード" href="http://fta7.jp/feed" /> <link rel="alternate" type="application/rss+xml" title="ひらめき箱 » コメントフィード" href="http://fta7.jp/comments/feed" /> <link rel="alternate" type="application/rss+xml" title="ひらめき箱 » Excelの便利な使い方まとめ【NAVERまとめ】のコメントのフィード" href="http://fta7.jp/excel/feed" />  <script type="text/javascript" data-cfasync="false"> var disableStr = 'ga-disable-UA-28848621-1'; /* Function to detect opted out users */ function __gaTrackerIsOptedOut() { return document.cookie.indexOf(disableStr + '=true') > -1; } /* Disable tracking if the opt-out cookie exists. */ if ( __gaTrackerIsOptedOut() ) { window[disableStr] = true; } /* Opt-out function */ function __gaTrackerOptout() { document.cookie = disableStr + '=true; expires=Thu, 31 Dec 2099 23:59:59 UTC; path=/'; window[disableStr] = true; } (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','//www.google-analytics.com/analytics.js','__gaTracker'); __gaTracker('create', 'UA-28848621-1', 'auto'); __gaTracker('set', 'forceSSL', true); __gaTracker('send','pageview'); </script>  <script type="text/javascript"> window._wpemojiSettings = {"baseUrl":"https:\/\/s.w.org\/images\/core\/emoji\/72x72\/","ext":".png","source":{"concatemoji":"http:\/\/fta7.jp\/blog\/wp-includes\/js\/wp-emoji-release.min.js?ver=4.5.15"}}; !function(a,b,c){function d(a){var c,d,e,f=b.createElement("canvas"),g=f.getContext&&f.getContext("2d"),h=String.fromCharCode;if(!g||!g.fillText)return!1;switch(g.textBaseline="top",g.font="600 32px Arial",a){case"flag":return g.fillText(h(55356,56806,55356,56826),0,0),f.toDataURL().length>3e3;case"diversity":return g.fillText(h(55356,57221),0,0),c=g.getImageData(16,16,1,1).data,d=c[0]+","+c[1]+","+c[2]+","+c[3],g.fillText(h(55356,57221,55356,57343),0,0),c=g.getImageData(16,16,1,1).data,e=c[0]+","+c[1]+","+c[2]+","+c[3],d!==e;case"simple":return g.fillText(h(55357,56835),0,0),0!==g.getImageData(16,16,1,1).data[0];case"unicode8":return g.fillText(h(55356,57135),0,0),0!==g.getImageData(16,16,1,1).data[0]}return!1}function e(a){var c=b.createElement("script");c.src=a,c.type="text/javascript",b.getElementsByTagName("head")[0].appendChild(c)}var f,g,h,i;for(i=Array("simple","flag","unicode8","diversity"),c.supports={everything:!0,everythingExceptFlag:!0},h=0;h<i.length;h++)c.supports[i[h]]=d(i[h]),c.supports.everything=c.supports.everything&&c.supports[i[h]],"flag"!==i[h]&&(c.supports.everythingExceptFlag=c.supports.everythingExceptFlag&&c.supports[i[h]]);c.supports.everythingExceptFlag=c.supports.everythingExceptFlag&&!c.supports.flag,c.DOMReady=!1,c.readyCallback=function(){c.DOMReady=!0},c.supports.everything||(g=function(){c.readyCallback()},b.addEventListener?(b.addEventListener("DOMContentLoaded",g,!1),a.addEventListener("load",g,!1)):(a.attachEvent("onload",g),b.attachEvent("onreadystatechange",function(){"complete"===b.readyState&&c.readyCallback()})),f=c.source||{},f.concatemoji?e(f.concatemoji):f.wpemoji&&f.twemoji&&(e(f.twemoji),e(f.wpemoji)))}(window,document,window._wpemojiSettings); </script> <style type="text/css"> img.wp-smiley, img.emoji { display: inline !important; border: none !important; box-shadow: none !important; height: 1em !important; width: 1em !important; margin: 0 .07em !important; vertical-align: -0.1em !important; background: none !important; padding: 0 !important; } </style> <link rel='stylesheet' id='newpost-catch-css' href='http://fta7.jp/blog/wp-content/plugins/newpost-catch/style.css?ver=4.5.15' type='text/css' media='all' /> <link rel='stylesheet' id='contact-form-7-css' href='http://fta7.jp/blog/wp-content/plugins/contact-form-7/includes/css/styles.css?ver=4.5' type='text/css' media='all' /> <link rel='stylesheet' id='wp-polls-css' href='http://fta7.jp/blog/wp-content/plugins/wp-polls/polls-css.css?ver=2.73.7' type='text/css' media='all' /> <style id='wp-polls-inline-css' type='text/css'> .wp-polls .pollbar { margin: 1px; font-size: 6px; line-height: 8px; height: 8px; background-image: url('http://fta7.jp/blog/wp-content/plugins/wp-polls/images/default/pollbg.gif'); border: 1px solid #c8c8c8; } </style> <link rel='stylesheet' id='style.css-css' href='http://fta7.jp/blog/wp-content/themes/exray/style.css?ver=4.5.15' type='text/css' media='all' /> <link rel='stylesheet' id='wordpress-popular-posts-css' href='http://fta7.jp/blog/wp-content/plugins/wordpress-popular-posts/style/wpp.css?ver=3.3.4' type='text/css' media='all' /> <link rel='stylesheet' id='mts_simple_booking_front_css-css' href='http://fta7.jp/blog/wp-content/plugins/mts-simple-booking-c/css/mtssb-front.css?ver=4.5.15' type='text/css' media='all' /> <link rel='stylesheet' id='social-logos-css' href='http://fta7.jp/blog/wp-content/plugins/jetpack/_inc/social-logos/social-logos.min.css?ver=1' type='text/css' media='all' /> <link rel='stylesheet' id='jetpack_css-css' href='http://fta7.jp/blog/wp-content/plugins/jetpack/css/jetpack.css?ver=4.1.1' type='text/css' media='all' /> <script type='text/javascript' src='http://fta7.jp/blog/wp-includes/js/jquery/jquery.js?ver=1.12.4'></script> <script type='text/javascript' src='http://fta7.jp/blog/wp-includes/js/jquery/jquery-migrate.min.js?ver=1.4.1'></script> <script type='text/javascript'> /* <![CDATA[ */ var related_posts_js_options = {"post_heading":"h4"}; /* ]]> */ </script> <script type='text/javascript' src='http://fta7.jp/blog/wp-content/plugins/jetpack/modules/related-posts/related-posts.js?ver=20150408'></script> <link rel='https://api.w.org/' href='http://fta7.jp/wp-json/' /> <link rel="EditURI" type="application/rsd+xml" title="RSD" href="http://fta7.jp/blog/xmlrpc.php?rsd" /> <link rel="wlwmanifest" type="application/wlwmanifest+xml" href="http://fta7.jp/blog/wp-includes/wlwmanifest.xml" /> <meta name="generator" content="WordPress 4.5.15" /> <link rel='shortlink' href='http://wp.me/s1PGlL-excel' /> <link rel="alternate" type="application/json+oembed" href="http://fta7.jp/wp-json/oembed/1.0/embed?url=http%3A%2F%2Ffta7.jp%2Fexcel" /> <link rel="alternate" type="text/xml+oembed" href="http://fta7.jp/wp-json/oembed/1.0/embed?url=http%3A%2F%2Ffta7.jp%2Fexcel&format=xml" /> <link rel='dns-prefetch' href='//v0.wordpress.com'> <link rel='dns-prefetch' href='//jetpack.wordpress.com'> <link rel='dns-prefetch' href='//s0.wp.com'> <link rel='dns-prefetch' href='//s1.wp.com'> <link rel='dns-prefetch' href='//s2.wp.com'> <link rel='dns-prefetch' href='//public-api.wordpress.com'> <link rel='dns-prefetch' href='//0.gravatar.com'> <link rel='dns-prefetch' href='//1.gravatar.com'> <link rel='dns-prefetch' href='//2.gravatar.com'> <link rel='dns-prefetch' href='//i0.wp.com'> <link rel='dns-prefetch' href='//i1.wp.com'> <link rel='dns-prefetch' href='//i2.wp.com'> <style type="text/css"> /*Link*/ a, p a, h5 a { color: #0d72c7; } /*Top Navigation*/ .top-menu-container, .top-menu-container .top-menu-navigation ul>li ul li{ background: #f5f5f5; } .top-menu-container .top-menu-navigation ul>li ul{ border: 1px solid #dbdbdb; } .top-menu-container .top-menu-navigation ul>li ul li{ border-bottom: 1px solid #dbdbdb; } .top-menu-container .top-menu-navigation ul>li ul li a:hover{ background: #dbdbdb; } /* Create contrast color for link based on menu backround color */ .top-menu-container .top-menu-navigation ul > li a, .top-menu-container .top-menu-navigation ul > li a::before, .adaptive-top-nav li a{ color: #333333 ; } .header-container { background: #ffffff; } /*Main Navigation */ .main-menu-container, .main-menu-container .main-menu-navigation ul>li ul li{ background: #f5f5f5; } .main-menu-container .main-menu-navigation ul>li a:hover, .main-menu-container .current_page_item{ background: #dbdbdb; } .main-menu-container .main-menu-navigation ul>li ul{ border: 1px solid #dbdbdb; } .main-menu-container .main-menu-navigation ul>li ul li{ border-bottom: 1px solid #dbdbdb; } .main-menu-container .main-menu-navigation ul>li ul li a:hover{ background: #dbdbdb; } .main-menu-container .main-menu-navigation ul > li a, .adaptive-main-nav li a { color: #333333 ; } .wrap{ background: #ffffff ; } .footer-widget-area{ background: #f7f7f7; } .copyright-container{ background: #ededed; } </style> <style type="text/css"> /* カスタム CSS 機能へようこそ。使い方についてはこちらをご覧ください (英語ドキュメンテーション)。http://wp.me/PEmnE-Bt */ /* リスト　paddingの数値が行間 */ ul, ol, li { margin: 0; padding: 5px 5px 5px 0; } body { background: #fff; border: 1px solid #ddd; font: 16px/23px Quicksand, 游ゴシック体, 'Yu Gothic', YuGothic, 'ヒラギノ角ゴシック Pro', 'Hiragino Kaku Gothic Pro', メイリオ, Meiryo, Osaka, 'ＭＳＰゴシック', 'MS PGothic', sans-serif; } .content article .entry-content { line-height: 1.6em; } .midashi1 { position: relative; color: #111; font-size: 1.143em; font-weight: bold; margin: 0 0 1.5em; padding: .5em .5em .5em 1.7em; border-bottom: 3px solid #B92A2C; } .midashi1:before { content: ""; position: absolute; background: #d48789; top: 0; left: .4em; height: 12px; width: 12px; transform: rotate(45deg); -moz-transform: rotate(45deg); -webkit-transform: rotate(45deg); -o-transform: rotate(45deg); -ms-transform: rotate(45deg); } .midashi1:after { content: ""; position: absolute; background: #d26466; top: 1em; left: 0; height: 8px; width: 8px; transform: rotate(15deg); -moz-transform: rotate(15deg); -webkit-transform: rotate(15deg); -o-transform: rotate(15deg); -ms-transform: rotate(15deg); } .midashi2 { color: #B92A2C; font-size: 1.143em; font-weight: bold; } /* ===============消しちゃダメ============== */ /* kaereba/yomereba Customize Settings 1.0.0 ver */ /* Created by Cazuki Hoshina */ /* Copyright (c) @cazuki All rights Reserved. */ /* ======================================== */ .kaerebalink-box, .booklink-box { width: 100%; margin: 0 0 2rem; padding: 1rem; background: #ffffff; border: 1px solid; border-color: #eaeaea #dddddd #d0d0d0; -webkit-border-radius: 3px; -moz-border-radius: 3px; border-radius: 3px; box-sizing: border-box; } .kaerebalink-box:after, .booklink-box:after { content: ""; display: block; visibility: hidden; height: 0; clear: both; } .kaerebalink-image, .booklink-image { float: left; width: 128px; margin: 0; text-align: center; } .kaerebakink-image img, .booklink-image img { width: 128px; height: auto; } .kaerebalink-info, .booklink-info { margin: 0 0 0 140px; line-height: 1.6rem; } .kaerebalink-name, .booklink-name { font-size: 1.0625rem; font-weight: bold; margin: 0; } .kaerebalink-name a, .booklink-name a { color: #2b2b2b; } .kaerebalink-name a:hover, .booklink-name a:hover { text-decoration: underline; } .kaerebalink-powered-date, .booklink-powered-date { font-size: .75rem; font-weight: normal; } .kaerebalink-detail, .booklink-detail { font-size: .9375rem; margin: 0 0 .5em; } .kaerebalink-link1, .booklink-link2 { width: 100%; } .kaerebalink-link1 div, .booklink-link2 div { float: left; width: 49.5%; margin-bottom: 1%; font-size: .875rem; font-weight: bold; text-align: center; box-sizing: border-box; } .kaerebalink-link1 div:nth-child(even), .booklink-link2 div:nth-child(even) { margin-left: 1%; } .kaerebalink-link1 div a, .booklink-link2 div a { display: block; padding: 3px 0; text-decoration: none; } .shoplinkamazon a, .shoplinkrakuten a, .shoplinkyahoo a, .shoplinkyahooAuc a, .shoplinkseven a, .shoplinkbellemaison a, .shoplinkcecile a, .shoplinkkakakucom a, .shoplinkkindle a, .shoplinkbk1 a, .shoplinkehon a, .shoplinkkino a, .shoplinkjun a, .shoplinktoshokan a { display: block; text-decoration: none; } .shoplinkamazon a { color: #ffffff; background: #ff9900; } .shoplinkkindle a { color: #ffffff; background: #1882c9; } .shoplinkrakuten a { color: #ffffff; background: #bf0000; } .shoplinkyahoo a { color: #ffffff; background: #fc1d2f; } .shoplinkyahooAuc a { color: #252525; background: #ffdb00; } .shoplinkseven a { color: #ffffff; background: #225093; } .shoplinkbellemaison a { color: #ffffff; background: #83be00; } .shoplinkcecile a { color: #ffffff; background: #6b053d; } .shoplinkkakakucom a { color: #ffffff; background: #00138e; } .shoplinkbk1 a { color: #ffffff; background: #0484d2; } .shoplinkehon a { color: #ffffff; background: #00006a; } .shoplinkkino a { color: #ffffff; background: #003e9d; } .shoplinkjun a { color: #4b5854; background: #d8c9b7; } .shoplinktoshokan a { color: #ffffff; background: #29b6e9; } .booklink-footer { clear: both !important; } @media only screen and (min-width:460px) and (max-width:640px) { .kaerebalink-link1 div, .booklink-link2 div { float: none; width: 100%; } .kaerebalink-link1 div:nth-child(even), .booklink-link2 div:nth-child(even) { margin-left: 0; } } @media only screen and (max-width:459px) { .kaerebalink-image, .booklink-image { float: none; width: 100%; margin: 0; text-align: center; } .kaerebakink-image img, .booklink-image img { width: 180px; height: auto; } .kaerebalink-info, .booklink-info { margin: 0; } .kaerebalink-link1 div, .booklink-link2 div { float: none; width: 100%; } .kaerebalink-link1 div:nth-child(even), .booklink-link2 div:nth-child(even) { margin-left: 0; } } /* ===============カエレバここまで============== */ /******************************* * 左からの吹き出し ********************************/ .left_balloon { position: relative; background: #fff; border: 1px solid #777; margin: 10px; padding: 10px; border-radius: 15px; margin-right: 20%; clear: both; max-width: 500px; float: left; } .left_balloon:after, .left_balloon:before { right: 100%; top: 50%; border: solid transparent; content: " "; height: 0; width: 0; position: absolute; pointer-events: none; } .left_balloon:after { border-color: rgba(255,255,255,0); border-right-color: #fff; border-width: 7px; margin-top: -7px; } .left_balloon:before { border-color: rgba(0,0,0,0); border-right-color: #000; border-width: 8px; margin-top: -8px; } /******************************* * 右からの吹き出し ********************************/ .right_balloon { position: relative; background: #FBFBE2; border: 1px solid #777; margin: 10px; padding: 10px; border-radius: 15px; margin-left: 20%; clear: both; max-width: 500px; float: right; } .right_balloon:after, .right_balloon:before { left: 100%; top: 50%; border: solid transparent; content: " "; height: 0; width: 0; position: absolute; pointer-events: none; } .right_balloon:after { border-color: rgba(133,226,73,0); border-left-color: #FBFBE2; border-width: 7px; margin-top: -7px; } .right_balloon:before { border-color: rgba(119,119,119,0); border-left-color: #777; border-width: 8px; margin-top: -8px; } /******************************* * 割り込みを解除 ********************************/ .clear_balloon { clear: both; }/* =======吹き出しここまで============== */ /* =======吹き出しここまで============== */ /* =======吹き出しここまで============== */ /* =======吹き出しここまで============== */ /* =======吹き出しここまで============== */ /* =======記事紹介文字幅============== */ /* =======記事紹介文字幅============== */ /* =======記事紹介文字幅============== */ /* =======記事紹介文字幅============== */ /* =======記事紹介文字幅============== */ } .kizishokai { word-break: break-all; width: 280px; padding: 5px; margin: 0 0 10px; } /* =======記事紹介文字幅ここまで============== */ /* =======記事紹介文字幅ここまで============== */ /* =======記事紹介文字幅ここまで============== */ /* =======記事紹介文字幅ここまで============== */ /* =======記事紹介文字幅ここまで============== */ /* レスポンシブで画像を切り替える（CSS） */ /* レスポンシブで画像を切り替える（CSS） */ /* レスポンシブで画像を切り替える（CSS） */ /* レスポンシブで画像を切り替える（CSS） */ /* レスポンシブで画像を切り替える（CSS） */ @media screen and (max-width: 480px) { .img01 { height: 0; padding-top: 69.531%; /* 445px÷640px×100=69.531...% */ background: url(http://fta7.jp/blog/wp-content/uploads/2015/11/433e87942efb35f2e5a2f519805c13fb.png) no-repeat center; background-size: contain; } .img01 img { display: none; /* PC用画像を非表示にする */ } } /* レスポンシブで画像を切り替える（CSS）ここまで*/ /* レスポンシブで画像を切り替える（CSS）ここまで*/ /* レスポンシブで画像を切り替える（CSS）ここまで*/ /* レスポンシブで画像を切り替える（CSS）ここまで*/ /* レスポンシブで画像を切り替える（CSS）ここまで*/ span.wpcf7-list-item { display: block; } hr.style-one { border-top: 1.5px solid #666; margin: -15px 0 10px; } hr.style-three { border-style: dotted; margin: -15px 0 10px; } .u_red { border-bottom: 2px solid #ff3333; } .list1 { line-height: 2.5em; margin-top: .5em; margin-bottom: .5em; } .pink { font-size: 1.2em; background: linear-gradient(transparent 80%,rgb(255,170,170) 60%); } .red { font-size: 1.2em; color: #ff3333; } /* ::::: twilogcss ::::: */ ul { list-style: outside none none; } blockquote::before, blockquote::after, q::before, q::after { content: none; } a { margin: 0; padding: 0; font-size: 100%; vertical-align: baseline; background: transparent none repeat scroll 0 0; } table { border-collapse: collapse; border-spacing: 0; } input, select { vertical-align: middle; } img { vertical-align: bottom; } .box-info.box-icon::before, .box-attention.box-icon::before, .box-balloon span::before, .nav-prev a::before, .nav-prev span::before, .nav-user a::before, .nav-user span::before, .nav-next a::before, .nav-next span::before, .nav-year a::before, .nav-year span::before { position: absolute; display: block; content: ""; } #container, header ul, .breadcrumb, .box-sort, .box-sort div, .side-list li { } #container::before, header ul::before, .breadcrumb::before, .box-sort::before, .box-sort div::before, .side-list li::before, #container::after, header ul::after, .breadcrumb::after, .box-sort::after, .box-sort div::after, .side-list li::after { content: " "; display: table; } #container::after, header ul::after, .breadcrumb::after, .box-sort::after, .box-sort div::after, .side-list li::after { clear: both; } .ta-c { text-align: center !important; } .mt0 { margin-top: 0 !important; } .mt15 { margin-top: 15px !important; } .mb0 { margin-bottom: 0 !important; } .mb5 { margin-bottom: 5px !important; } .mb10 { margin-bottom: 10px !important; } .user-sprite, header input[type="text"], header input[type="submit"], #ti-twilog a, .breadcrumb li, .breadcrumb li:first-child a, #user-info h1 a strong, .user-info-place, .user-info-web, .user-info-comment, .box-stats .title a, .box-stats .title span, .box-info.box-icon::before, .box-attention.box-icon::before, .box-balloon span::before, .tl-retweet, .tl-del a, .tb-rep, .tb-rt, .tb-fav, .tb-rep:hover, .tb-rt:hover, .tb-fav:hover, .tb-rt.on, .tb-fav.on, .nav-prev a::before, .nav-prev span::before, .nav-user a::before, .nav-user span::before, .nav-next a::before, .nav-next span::before, .nav-year a::before, .nav-year span::before, .f-pagetop a, .title01, .bt-source, .bt-source:hover, .bt-source:active, .sidebox-update input[type="submit"], .sidebox-update input[type="submit"]:hover, .sidebox-update input[type="submit"]:active, .sidebox-update input[type="submit"]:disabled, .sidebox-stats a, .sidebox-stats span, .sidebox-feed a, .cal-nav .ic-arrow-l a, .cal-nav .ic-arrow-l span, .cal-nav .ic-arrow-r a, .cal-nav .ic-arrow-r span, .sidebox-search .submit01 { background: transparent url('user-sff629993c7.png') no-repeat scroll 0 0; } a { color: rgb(82,146,158); text-decoration: none; } a:hover, a:active { text-decoration: underline; } #container { width: 970px; margin: 0 auto; background: rgba(255,255,255,0.4) url('user-bg-container.png') repeat-y scroll 0 0; } #content { width: 640px; float: left; padding-bottom: 30px; background-color: rgb(255,255,255); } #sidebar { width: 330px; float: right; padding: 0 0 100px; text-align: center; } #ti-twilog a { position: absolute; top: -3px; left: -5px; display: block; height: 0; line-height: 1.5; overflow: hidden; width: 136px; padding-top: 62px; background-position: -600px -169px; transition: all .2s ease 0; } #ti-twilog a:hover { top: -1px; } .breadcrumb { margin: 6px 15px 0; } .breadcrumb li { float: left; font-size: 93%; padding: 10px 10px 10px 28px; color: rgb(68,68,68); background-position: 0 -91px; } .breadcrumb li:first-child { background: transparent none repeat scroll 0 0; padding-left: 10px; } .breadcrumb li:first-child a { display: block; height: 0; line-height: 1.5; overflow: hidden; width: 18px; padding-top: 16px; background-position: -436px -91px; } .breadcrumb li:first-child a:hover { opacity: .8; } .breadcrumb li:last-child { font-weight: bold; } .breadcrumb a, .breadcrumb a:hover { color: rgb(153,153,153); } #user-info { width: 610px; height: 305px; margin: 8px 0 13px 15px; position: relative; } #user-info h1 { font-size: 139%; margin: -30px 0 0 127px; text-shadow: 1px 1px 1px rgb(0,0,0); } #user-info h1 span { font-size: 83.3333%; margin-left: 8px; color: rgb(238,238,238) !important; font-weight: normal; font-family: "Hiragino Kaku Gothic Pro", Meiryo, sans-serif; } #user-info h1 a strong { background-position: 0 -326px; padding-left: 20px; } #user-info h1 a:hover { text-decoration: none; } #user-info h1 a:hover strong { text-decoration: underline; } #user-info a { color: rgb(255,255,255) !important; } #user-info-bg { position: absolute; top: 0; bottom: 0; background: rgb(252,244,231) url('bg.png') repeat scroll 0 0; width: 610px; height: 305px; } #user-info-content { width: 100%; background-color: rgba(0,0,0,0.45); position: absolute; left: 0; bottom: 0; border-bottom-left-radius: 4px; border-bottom-right-radius: 4px; color: rgb(238,238,238); padding: 45px 0 20px; } #user-info-shadow { width: 610px; height: 305px; position: absolute; top: 0; bottom: 0; border-radius: 4px; box-shadow: 0 0 5px 0 rgb(85,85,85) inset; } #user-info-icon { border: 5px solid rgb(255,255,255); border-radius: 5px; width: 73px; height: 73px; position: absolute; top: -40px; left: 30px; } .user-info-col { padding: 0 30px; } .user-info-place, .user-info-web, .user-info-comment { text-shadow: 1px 1px 1px rgb(0,0,0); display: inline-block; } .user-info-place { padding: 0 5px 8px 20px; background-position: 0 -169px; max-width: 450px; white-space: nowrap; overflow: hidden; text-overflow: ellipsis; } .user-info-web { padding: 0 0 8px 21px; background-position: 0 -231px; max-width: 450px; white-space: nowrap; overflow: hidden; text-overflow: ellipsis; } .user-info-comment { display: block; padding: 0 0 0 20px; word-wrap: break-word; word-break: break-all; background-position: 0 -406px; } .user-follow { margin: 20px 0 10px 30px; padding: 7px 0; font-size: 77%; color: rgb(153,153,153); } .user-follow a { font-size: 130%; padding-right: 5px; } .user-follow li { padding: 9px 15px 5px; margin-right: 3px; border-radius: 20px; display: inline; background: rgb(17,17,17) none repeat scroll 0 0; } .box-stats { border: 3px solid rgb(204,204,204); border-radius: 3px; margin: 10px 13px; padding: 2px; } .box-stats table { width: 100%; } .box-stats td { padding: 5px 10px; text-align: center; color: rgb(102,102,102); line-height: 1.5; } .box-stats .title { vertical-align: middle; font-family: "Tenor Sans", "Trebuchet MS", Arial, Helvetica, sans-serif; } .box-stats .title a, .box-stats .title span { background-position: -562px 0; padding-left: 44px; display: block; height: 33px; padding-top: 5px; font-size: 139%; } .box-stats .title.disabled span { opacity: .4; color: rgb(153,153,153); } .box-stats .stats { border-left: 2px dotted rgb(204,204,204); } .box-stats strong { color: rgb(51,51,51); } .box-stats span { font-size: 85%; } .box-sort { margin: 18px 15px; font-size: 12px; font-weight: bold; } .box-sort div { margin-bottom: 5px; } .box-sort p { color: rgb(51,51,51); float: left; margin: 0; padding: 3px 0; } .box-sort ul { float: left; } .box-sort li { float: left; margin: 0 0 0 5px; text-align: center; } .box-sort span { display: block; border: 1px solid rgb(51,51,51); background: rgb(51,51,51) none repeat scroll 0 0; color: rgb(255,255,255); border-radius: 3px; padding: 3px 10px; } .box-sort a { display: block; border-radius: 3px; border: 1px solid rgb(204,204,204); background: rgb(255,255,255) none repeat scroll 0 0; color: rgb(102,102,102); padding: 3px 10px; } .box-sort a:hover { border: 1px solid rgb(153,153,153); background: rgb(255,255,255) none repeat scroll 0 0; color: rgb(51,51,51); text-decoration: none; } .box-sort .w4em { width: 80px; } .box-info.box-icon::before { background-position: -640px -91px; width: 20px; height: 20px; top: 14px; left: 14px; } .box-attention.box-icon::before { background-position: -599px -91px; width: 23px; height: 18px; top: 14px; left: 13px; } .box-balloon a { display: block; text-align: center; padding: 10px 0; color: rgb(255,255,255); background: rgb(241,146,26) none repeat scroll 0 0; font-weight: bold; position: relative; } .box-balloon a:hover { opacity: .8; color: rgb(255,255,255); text-decoration: none; } .box-balloon a::before, .box-balloon a:hover::before { content: ""; position: absolute; width: 0; height: 0; top: 100%; left: 50%; border-style: solid; border-width: 7px 6px 0; border-color: rgb(241,146,26) rgb(255,255,255); } .box-balloon span { position: relative; } .box-balloon span::before { background-position: -423px -91px; width: 13px; height: 14px; top: 0; left: -18px; } .box-balloon a:hover span::before { transform: rotate(360deg); transition: all .5s ease 0; } .tl-tweets { padding: 13px 15px 0; } .tl-tweet { border-bottom: 1px dotted rgb(204,204,204); padding: 0 15px 12px 63px; margin-bottom: 12px; position: relative; } .tl-icon { position: absolute; top: 0; left: 5px; } .tl-icon img { border-radius: 5px; } .tl-icon a:hover { opacity: .8; } .tl-time { position: absolute; top: 0; right: 15px; } .tl-time a, .tl-posted a, .tl-retweet a { font-size: 13px; font-weight: normal; color: rgb(153,153,153) !important; } .tl-name a, .tl-name a:hover { text-decoration: none; } .tl-name a span, .tl-name a:hover span { padding-left: 5px; font-size: 13px; font-weight: normal; color: rgb(153,153,153) !important; } .tl-name { font-size: 108%; font-weight: bold; margin-bottom: 7px; } .tl-name strong { color: rgb(51,51,51); } .tl-name a:hover strong { text-decoration: underline; } .tl-text { font-size: 108%; color: rgb(68,68,68); line-height: 1.4; margin-bottom: 6px; word-wrap: break-word; word-break: break-all; } .tl-image img { margin: 0 10px 6px 0; } .tl-posted, .tl-retweet { color: rgb(153,153,153); font-size: 13px; } .tb-rep { display: block; height: 0; line-height: 1.5; overflow: hidden; width: 16px; padding-top: 16px; background-position: -502px -91px; position: absolute; bottom: 15px; right: 60px; } .tb-rt { display: block; height: 0; line-height: 1.5; overflow: hidden; width: 16px; padding-top: 16px; background-position: -470px -91px; position: absolute; bottom: 14px; right: 37px; } .tb-fav { display: block; height: 0; line-height: 1.5; overflow: hidden; width: 16px; padding-top: 16px; background-position: -518px -91px; position: absolute; bottom: 15px; right: 15px; } .tb-rep:hover { background-position: -550px -91px; } .tb-rt:hover { background-position: -486px -91px; } .tb-fav:hover { background-position: -534px -91px; } .nav-link { text-align: center; margin: 30px 0 0; font-size: 12px; } .nav-link li { display: inline; margin-right: 2px; } .nav-link a, .nav-link a:hover, .nav-link span { display: inline-block; border-radius: 4px; color: rgb(255,255,255); font-weight: bold; padding: 6px 15px; text-decoration: none; position: relative; } .nav-link span { background-color: rgb(238,238,238); } .nav-link a:hover { opacity: .8; } .nav-prev a, .nav-prev a:hover, .nav-prev span { padding-left: 32px; } .nav-prev a::before, .nav-prev span::before { background-position: -400px -91px; width: 8px; height: 12px; top: auto; left: 10px; margin-top: 1px; } .nav-user a, .nav-user a:hover, .nav-user span { padding-left: 37px; } .nav-user a::before, .nav-user span::before { background-position: -408px -91px; width: 15px; height: 14px; top: auto; left: 14px; } .nav-next a, .nav-next a:hover, .nav-next span { padding-right: 32px; } .nav-next a::before, .nav-next span::before { background-position: -816px -55px; width: 8px; height: 12px; top: auto; right: 10px; margin-top: 1px; } .nav-year a::before, .nav-year span::before { background-position: -622px -91px; width: 18px; height: 18px; top: auto; left: 15px; margin-top: -2px; } .sidebox { width: 300px; background: rgb(255,255,255) none repeat scroll 0 0; border: 1px solid rgb(238,238,238); border-radius: 4px; margin: 15px auto; text-align: left; } .side-pd { padding: 11px; } .side-title { font-size: 139%; font-weight: normal; font-family: "Tenor Sans", "Trebuchet MS", Arial, Helvetica, sans-serif; color: rgb(68,68,68); padding: 6px 11px; border-bottom: 1px solid rgb(238,238,238); } .side-list li { border-bottom: 1px solid rgb(238,238,238); padding: 7px 11px; word-wrap: break-word; word-break: break-all; } .side-list a, .side-list strong { float: left; width: 245px; position: relative; } .side-list a span, .side-list strong span { color: rgb(153,153,153); position: absolute; top: 0; right: 0; } .side-list a:hover, .side-list a:hover span { color: rgb(85,85,85); text-decoration: none; } .side-list.wide a, .side-list.wide strong { width: 275px; box-sizing: border-box; padding-right: 50px; } .side-list-icon, .side-list-noicon { float: left !important; width: 27px !important; height: 18px; border-radius: 2px; margin-right: 5px; } .side-list-icon:hover { opacity: .8; } .side-list-noicon { background-color: rgb(238,238,238); } .side-more { padding: 9px 11px; text-align: right; } .f-pagetop { position: relative; width: 970px; margin: 0 auto; } .f-pagetop a { z-index: 0; display: block; height: 0; line-height: 1.5; overflow: hidden; width: 53px; padding-top: 55px; background-position: -351px 0; position: absolute; top: -50px; right: 262px; transition: all .2s ease 0; } .f-pagetop a:hover { top: -54px; } .title01 { position: relative; margin-top: 20px; background-position: 0 -271px; height: 55px; line-height: 50px; color: rgb(140,190,26); font-size: 124%; padding: 0 40px; } .title01 span { color: rgb(153,153,153); font-size: 81.25%; border-left: 1px solid rgb(238,238,238); padding: 6px 0 4px 15px; margin-left: 13px; font-weight: bold; font-family: "Trebuchet MS", Arial, Helvetica, sans-serif; } .bt-source { display: block; height: 0; line-height: 1.5; overflow: hidden; width: 52px; padding-top: 30px; background-position: -740px -91px; position: absolute; top: 9px; right: 15px; } .bt-source:hover { background-position: -652px -129px; } .bt-source:active { background-position: -600px -129px; } .sidebox-update { padding: 15px 0; text-align: center; } .sidebox-update p { margin-top: 8px; font-family: "Trebuchet MS", Arial, Helvetica, sans-serif; font-weight: bold; color: rgb(51,51,51); } .sidebox-update span { font-weight: normal; color: rgb(153,153,153); padding-left: 8px; } .sidebox-update input[type="submit"] { width: 272px; height: 36px; border: 0 none; font-size: 13px; font-weight: bold; background-position: 0 -55px; text-shadow: 1px 1px 0 rgb(255,255,255); } .sidebox-update input[type="submit"]:hover { background-position: -272px -55px; cursor: pointer; } .sidebox-update input[type="submit"]:active { background-position: -544px -55px; } .sidebox-update input[type="submit"]:disabled { background-position: -544px -55px; cursor: default; } .sidebox-stats, .sidebox-feed { width: 142px; margin-top: 0; } .sidebox-stats a, .sidebox-stats span, .sidebox-feed a, .sidebox-feed span { margin: 20px auto 25px; } .sidebox-stats a:hover, .sidebox-feed a:hover { opacity: .8; } .sidebox-stats { float: left; margin-left: 15px; } .sidebox-stats a, .sidebox-stats span { display: block; height: 0; line-height: 1.5; overflow: hidden; width: 58px; padding-top: 50px; background-position: -404px 0; } .sidebox-stats.disabled .side-title { color: rgb(204,204,204) !important; } .sidebox-stats.disabled span { opacity: .3; } .sidebox-feed { float: right; margin-right: 15px; } .sidebox-feed a { display: block; height: 0; line-height: 1.5; overflow: hidden; width: 51px; padding-top: 50px; background-position: -300px 0; } .sidebox-cal { padding: 15px 0; position: relative; } .cal-title { font-size: 108%; font-weight: bold; color: rgb(51,51,51); text-align: center; } .cal-link { text-align: center; font-size: 108%; font-weight: bold; margin: 15px 0 3px; } #cal { width: 276px; margin: 20px 0 0 13px; text-align: center; } #cal th { font-size: 85%; color: rgb(153,153,153); padding-bottom: 5px; } #cal th:nth-child(6) { color: rgb(181,181,212); } #cal th:nth-child(7) { color: rgb(212,181,181); } #cal td { border-bottom: 3px solid rgb(255,255,255); border-right: 3px solid rgb(255,255,255); height: 30px; line-height: 30px; background: rgb(228,228,228) none repeat scroll 0 0; color: rgb(255,255,255); font-weight: bold; } #cal td:nth-child(6) { background: rgb(224,226,238) none repeat scroll 0 0; } #cal td:nth-child(6) a { background: rgb(168,170,204) none repeat scroll 0 0; } #cal td:nth-child(6) a:hover { background: rgb(133,135,183) none repeat scroll 0 0; } #cal td:nth-child(7) { background: rgb(238,224,224) none repeat scroll 0 0; } #cal td:nth-child(7) a { background: rgb(204,168,168) none repeat scroll 0 0; } #cal td:nth-child(7) a:hover { background: rgb(183,133,133) none repeat scroll 0 0; } #cal td.current:nth-child(6) { color: rgb(60,62,103); } #cal td.current:nth-child(7) { color: rgb(103,60,60); } #cal a { display: block; color: rgb(255,255,255); background: rgb(153,153,153) none repeat scroll 0 0; } #cal a:hover { background: rgb(102,102,102) none repeat scroll 0 0; text-decoration: none; } .cal-nav a, .cal-nav span { display: block; width: 28px; height: 28px; line-height: 28px; text-indent: 28px; overflow: hidden; border-radius: 28px; } .cal-nav a:hover { opacity: .8; } .cal-nav .ic-arrow-l a, .cal-nav .ic-arrow-l span { background-position: -684px -91px; position: absolute; top: 12px; left: 15px; } .cal-nav .ic-arrow-r a, .cal-nav .ic-arrow-r span { background-position: -712px -91px; position: absolute; top: 12px; right: 15px; } .cal-nav span { background-color: rgb(238,238,238) !important; } .sidebox-search { position: relative; } .sidebox-search form { position: relative; } .sidebox-search .input01 { border: 1px solid rgb(204,204,204); border-radius: 3px; padding: 7px 30px 7px 6px; font-size: 12px; width: 240px; box-shadow: 0 0 2px 2px rgb(238,238,238) inset; margin: 0; } .sidebox-search .input01:focus { border: 1px solid rgb(187,187,187); box-shadow: none; } .sidebox-search .submit01 { border: medium none; background-position: -582px -91px; width: 17px; height: 17px; position: absolute; top: 7px; right: 10px; text-indent: 50px; padding: 0; } .sidebox-search .submit01:hover { cursor: pointer; opacity: .8; } .sidebox-search :-moz-placeholder { color: rgb(221,221,221); } #search-opt { font-size: 13px; margin-top: 13px; } #ti-f-twilog a { display: block; height: 0; line-height: 1.5; overflow: hidden; width: 112px; padding-top: 40px; background: transparent url('user-ti-f-twilog.png') repeat scroll 0 0; margin: 12px 0 0 40px; } #ti-f-twilog a:hover { opacity: .8; } #ad-side-bottom { width: 300px; height: 250px; margin: 8px auto 120px; text-align: center; } .invisible { font-size: 0; } .main-list li::after { content: " "; display: table; } .main-list li::after { clear: both; } .sbt-box { display: none; line-height: 1; font-weight: normal; font-size: 13px; text-align: center; color: rgb(51,51,51); position: absolute; bottom: 46px; padding: 10px; right: 15px; width: 80px; border: 5px solid rgb(170,170,170); background-color: rgb(255,255,255); } .bt-common a { border: 1px solid rgb(204,204,204); display: block; margin: 0 auto; text-align: center; font-weight: bold; text-decoration: none; font-size: 100%; border-radius: 5px; background: rgb(237,237,237) -moz-linear-gradient(center top,rgb(237,237,237) 5%,rgb(223,223,223) 100%) repeat scroll 0 0; color: rgb(85,85,85); text-shadow: 1px 1px 0 rgb(255,255,255); box-shadow: 1px 1px 0 0 rgb(255,255,255) inset; } .bt-src a { line-height: 1; width: 50px; padding: 3px 0; margin-bottom: 5px; } .bt-common a:hover { background: rgb(223,223,223) -moz-linear-gradient(center top,rgb(223,223,223) 5%,rgb(237,237,237) 100%) repeat scroll 0 0; color: rgb(85,85,85); } #source-box { padding-top: 15px; text-align: center; display: none; background-color: white; position: absolute; width: 500px; height: 260px; border: 6px solid rgb(170,170,170); border-radius: 6px; } .side-list-icon, .nav-link a, .cal-nav a { background-color: rgb(155,225,245) !important; } .tl-del a, .tl-del a:hover, .tl-name a:hover strong { color: rgb(155,225,245) !important; } </style>   <script type="text/javascript"> var sampling_active = 0; var sampling_rate = 100; var do_request = false; if ( !sampling_active ) { do_request = true; } else { var num = Math.floor(Math.random() * sampling_rate) + 1; do_request = ( 1 === num ); } if ( do_request ) { /* Create XMLHttpRequest object and set variables */ var xhr = ( window.XMLHttpRequest ) ? new XMLHttpRequest() : new ActiveXObject( "Microsoft.XMLHTTP" ), url = 'http://fta7.jp/blog/wp-admin/admin-ajax.php', params = 'action=update_views_ajax&token=69df392e7f&wpp_id=567'; /* Set request method and target URL */ xhr.open( "POST", url, true ); /* Set request header */ xhr.setRequestHeader( "Content-type", "application/x-www-form-urlencoded" ); /* Hook into onreadystatechange */ xhr.onreadystatechange = function() { if ( 4 === xhr.readyState && 200 === xhr.status ) { if ( window.console && window.console.log ) { window.console.log( xhr.responseText ); } } }; /* Send request */ xhr.send( params ); } </script>  <link rel="icon" href="http://fta7.jp/blog/wp-content/uploads/2013/02/icon.png" type="image/png"/> <meta property="og:title" content="Excelの便利な使い方まとめ【NAVERまとめ】" /> <meta property="og:site_name" content="ひらめき箱" /> <meta property="og:type" content="article" /> <meta property="og:url" content="http://fta7.jp/excel" /> <meta property="og:image" content="http://i2.wp.com/fta7.jp/blog/wp-content/uploads/2013/01/icon.png?resize=150%2C150" />  <script> (function (d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js = d.createElement(s); js.id = id; js.src = "//connect.facebook.net/ja_JP/sdk.js#xfbml=1&version=v2.7"; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk')); </script> <style type="text/css"> .wp_social_bookmarking_light{ border: 0 !important; padding: 0 !important; margin: 0 !important; } .wp_social_bookmarking_light div{ float: left !important; border: 0 !important; padding: 0 !important; margin: 0 5px 0px 0 !important; height: 23px !important; text-indent: 0 !important; } .wp_social_bookmarking_light img{ border: 0 !important; padding: 0; margin: 0; vertical-align: top !important; } .wp_social_bookmarking_light_clear{ clear: both !important; } .wsbl_twitter{ width: 100px; } </style>  <style type="text/css" media="screen">body{position:relative}#dynamic-to-top{display:none;overflow:hidden;width:auto;z-index:90;position:fixed;bottom:20px;right:20px;top:auto;left:auto;font-family:sans-serif;font-size:1em;color:#fff;text-decoration:none;text-shadow:0 1px 0 #333;font-weight:bold;padding:9px 8px;border:3px solid #ececec;background:#c8ced8;-webkit-background-origin:border;-moz-background-origin:border;-icab-background-origin:border;-khtml-background-origin:border;-o-background-origin:border;background-origin:border;-webkit-background-clip:padding-box;-moz-background-clip:padding-box;-icab-background-clip:padding-box;-khtml-background-clip:padding-box;-o-background-clip:padding-box;background-clip:padding-box;-webkit-box-shadow:0 1px 3px rgba( 0, 0, 0, 0.4 );-ms-box-shadow:0 1px 3px rgba( 0, 0, 0, 0.4 );-moz-box-shadow:0 1px 3px rgba( 0, 0, 0, 0.4 );-o-box-shadow:0 1px 3px rgba( 0, 0, 0, 0.4 );-khtml-box-shadow:0 1px 3px rgba( 0, 0, 0, 0.4 );-icab-box-shadow:0 1px 3px rgba( 0, 0, 0, 0.4 );box-shadow:0 1px 3px rgba( 0, 0, 0, 0.4 );-webkit-border-radius:30px;-moz-border-radius:30px;-icab-border-radius:30px;-khtml-border-radius:30px;border-radius:30px}#dynamic-to-top:hover{background:#55aff2;background:#c8ced8 -webkit-gradient( linear, 0% 0%, 0% 100%, from( rgba( 255, 255, 255, .2 ) ), to( rgba( 0, 0, 0, 0 ) ) );background:#c8ced8 -webkit-linear-gradient( top, rgba( 255, 255, 255, .2 ), rgba( 0, 0, 0, 0 ) );background:#c8ced8 -khtml-linear-gradient( top, rgba( 255, 255, 255, .2 ), rgba( 0, 0, 0, 0 ) );background:#c8ced8 -moz-linear-gradient( top, rgba( 255, 255, 255, .2 ), rgba( 0, 0, 0, 0 ) );background:#c8ced8 -o-linear-gradient( top, rgba( 255, 255, 255, .2 ), rgba( 0, 0, 0, 0 ) );background:#c8ced8 -ms-linear-gradient( top, rgba( 255, 255, 255, .2 ), rgba( 0, 0, 0, 0 ) );background:#c8ced8 -icab-linear-gradient( top, rgba( 255, 255, 255, .2 ), rgba( 0, 0, 0, 0 ) );background:#c8ced8 linear-gradient( top, rgba( 255, 255, 255, .2 ), rgba( 0, 0, 0, 0 ) );cursor:pointer}#dynamic-to-top:active{background:#c8ced8;background:#c8ced8 -webkit-gradient( linear, 0% 0%, 0% 100%, from( rgba( 0, 0, 0, .3 ) ), to( rgba( 0, 0, 0, 0 ) ) );background:#c8ced8 -webkit-linear-gradient( top, rgba( 0, 0, 0, .1 ), rgba( 0, 0, 0, 0 ) );background:#c8ced8 -moz-linear-gradient( top, rgba( 0, 0, 0, .1 ), rgba( 0, 0, 0, 0 ) );background:#c8ced8 -khtml-linear-gradient( top, rgba( 0, 0, 0, .1 ), rgba( 0, 0, 0, 0 ) );background:#c8ced8 -o-linear-gradient( top, rgba( 0, 0, 0, .1 ), rgba( 0, 0, 0, 0 ) );background:#c8ced8 -ms-linear-gradient( top, rgba( 0, 0, 0, .1 ), rgba( 0, 0, 0, 0 ) );background:#c8ced8 -icab-linear-gradient( top, rgba( 0, 0, 0, .1 ), rgba( 0, 0, 0, 0 ) );background:#c8ced8 linear-gradient( top, rgba( 0, 0, 0, .1 ), rgba( 0, 0, 0, 0 ) )}#dynamic-to-top,#dynamic-to-top:active,#dynamic-to-top:focus,#dynamic-to-top:hover{outline:none}#dynamic-to-top span{display:block;overflow:hidden;width:14px;height:12px;background:url( http://fta7.jp/blog/wp-content/plugins/dynamic-to-top/css/images/up.png )no-repeat center center}</style>  <meta property="og:type" content="article" /> <meta property="og:title" content="Excelの便利な使い方まとめ【NAVERまとめ】" /> <meta property="og:url" content="http://fta7.jp/excel" /> <meta property="og:description" content="何これすごい便利！こういうのは、気づいたときにさらーっとよむと、「ああ、そうだ、こういう機能探してたー！」っ…" /> <meta property="article:published_time" content="2012-02-06T10:56:52+00:00" /> <meta property="article:modified_time" content="2018-07-21T21:15:47+00:00" /> <meta property="og:site_name" content="ひらめき箱" /> <meta property="og:image" content="http://capture.heartrails.com/320x320/cool?http://matome.naver.jp/odai/2132548396723837701" /> <meta property="og:locale" content="ja_JP" /> <meta name="twitter:card" content="summary" /> <link rel="stylesheet" id="custom-css-css" type="text/css" href="http://fta7.jp/?custom-css=1&csblog=1&cscache=6&csrev=170" /> <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> <script> (adsbygoogle = window.adsbygoogle || []).push({ google_ad_client: "ca-pub-8616468311309210", enable_page_level_ads: true }); </script> </head> <body class="single single-post postid-567 single-format-standard" >  <div id="page" class="wrap"> <div class="header-container"> <header class="top-header" id="top" role="banner"> <div class="top-menu-container"> <div class="container"> </div>  </div>  <div class="container" id="header-wrap"> <div class="row"> <div class="span6 logo-container"> <p class="logo"> <a href="http://fta7.jp"> <img src="http://fta7.jp/blog/wp-content/uploads/2015/12/header.png" alt="ひらめき箱 | @fta7がひらめきの素を集めます。" /> </a> </p> </div>  <div class="span6 clearfix" id="header-widget-container"> </div> </div>  </div>  <div class="main-menu-container"> <div class="container"> <nav class="main-menu-navigation clearfix" role="navigation"> <ul id="menu-header" class=""><li id="menu-item-1156" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-home menu-item-1156"><a href="http://fta7.jp/">HOME</a></li> <li id="menu-item-1616" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1616"><a href="http://fta7.jp/category/idea">ひらめき</a></li> <li id="menu-item-1617" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1617"><a href="http://fta7.jp/category/%e3%82%bb%e3%83%b3%e3%82%b9%e3%82%92%e7%a3%a8%e3%81%8f/recipe">レシピ・グルメ</a></li> <li id="menu-item-1618" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1618"><a href="http://fta7.jp/category/lifehack">ライフハック</a></li> <li id="menu-item-1621" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1621"><a href="http://fta7.jp/category/animal">ネコ・イヌ</a></li> <li id="menu-item-8211" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-8211"><a href="http://fta7.jp/category/%e7%be%8e%e5%ae%b9">美容</a></li> </ul> </nav> <a href="" class="small-button menus" id="adaptive-main-nav-btn">Menu</a> <div class="adaptive-main-nav"></div>  </div>  </div>  </header>  </div>   <div class="container" id="main-container"> <div class="row"> <div class="span9 article-container-adaptive" id="main"> <div class="content" role="main"> <article class="clearfix post-567 post type-post status-publish format-standard has-post-thumbnail hentry category-100" id="post-567" role="article"> <header> <h1 class="entry-title">Excelの便利な使い方まとめ【NAVERまとめ】</h1> <div class="entry-meta"> <p class="article-meta-extra"> <span class="icon left-meta-icon">P</span> <a href="http://fta7.jp/excel" title="7:56 PM" rel="bookmark"> <time datetime="2012-02-06T19:56:52+00:00" pubdate>2012-02-06</time> </a> , by <a href="http://fta7.jp/author/fta7net" title="F太の投稿" rel="author">F太</a> <ul class="categories"> <li><span class="icon categories">K</span></li> <a href="http://fta7.jp/category/%e8%89%af%e8%a8%98%e4%ba%8b%e7%b4%b9%e4%bb%8b" rel="category tag">良記事紹介</a> </ul> </p> </div>  </header> <div class="entry-content"> <div class='wp_social_bookmarking_light'> <div class="wsbl_facebook_like"><div id="fb-root"></div><div class="fb-like" data-href="http://fta7.jp/excel" data-layout="button_count" data-action="like" data-width="200" data-share="false" data-show_faces="false" ></div></div> <div class="wsbl_twitter"><a href="https://twitter.com/share" class="twitter-share-button" data-url="http://fta7.jp/excel" data-text="Excelの便利な使い方まとめ【NAVERまとめ】" data-dnt="true" data-lang="ja">Tweet</a></div> <div class="wsbl_hatena_button"><a href="//b.hatena.ne.jp/entry/http://fta7.jp/excel" class="hatena-bookmark-button" data-hatena-bookmark-title="Excelの便利な使い方まとめ【NAVERまとめ】" data-hatena-bookmark-layout="standard" title="このエントリーをはてなブックマークに追加"> <img src="//b.hatena.ne.jp/images/entry-button/button-only@2x.png" alt="このエントリーをはてなブックマークに追加" width="20" height="20" style="border: none;" /></a><script type="text/javascript" src="//b.hatena.ne.jp/js/bookmark_button.js" charset="utf-8" async="async"></script></div> </div> <br class='wp_social_bookmarking_light_clear' /> <p><script type="text/javascript"> </script><br /> <script type="text/javascript" src="//pagead2.googlesyndication.com/pagead/show_ads.js"> </script></p> <div style="font-size:x-large">何これすごい便利！</div> <p>こういうのは、気づいたときにさらーっとよむと、「ああ、そうだ、こういう機能探してたー！」ってのが見つかってすごく良い。Excelの機能って、ぐぐるのが結構難しいので、「偶然の出会い」っていうのが結構重要なんだよね…！</p> <p><a href="http://matome.naver.jp/odai/2132548396723837701" target=”_blank”>Excelの使い方<BR><img title="http://matome.naver.jp/odai/2132548396723837701" src="http://capture.heartrails.com/320x320/cool?http://matome.naver.jp/odai/2132548396723837701" alt="http://matome.naver.jp/odai/2132548396723837701" width="320" height="320" /></a></p> <p><script type="text/javascript"> </script><br /> <script type="text/javascript" src="//pagead2.googlesyndication.com/pagead/show_ads.js"> </script></p> <div class="sharedaddy sd-sharing-enabled"><div class="robots-nocontent sd-block sd-social sd-social-icon sd-sharing"><h3 class="sd-title">共有:</h3><div class="sd-content"><ul><li class="share-twitter"><a rel="nofollow" data-shared="sharing-twitter-567" class="share-twitter sd-button share-icon no-text" href="http://fta7.jp/excel?share=twitter" target="_blank" title="クリックして Twitter で共有"><span></span><span class="sharing-screen-reader-text">クリックして Twitter で共有 (新しいウィンドウで開きます)</span></a></li><li class="share-facebook"><a rel="nofollow" data-shared="sharing-facebook-567" class="share-facebook sd-button share-icon no-text" href="http://fta7.jp/excel?share=facebook" target="_blank" title="Facebook で共有するにはクリックしてください"><span></span><span class="sharing-screen-reader-text">Facebook で共有するにはクリックしてください (新しいウィンドウで開きます)</span></a></li><li class="share-google-plus-1"><a rel="nofollow" data-shared="sharing-google-567" class="share-google-plus-1 sd-button share-icon no-text" href="http://fta7.jp/excel?share=google-plus-1" target="_blank" title="クリックして Google+ で共有"><span></span><span class="sharing-screen-reader-text">クリックして Google+ で共有 (新しいウィンドウで開きます)</span></a></li><li class="share-end"></li></ul></div></div></div> <div id='jp-relatedposts' class='jp-relatedposts' > <h3 class="jp-relatedposts-headline"><em>関連</em></h3> </div> </div> <hr class="content-separator">   <div class="post-pagination">  </div> </article>  <div class="article-author clearfix"> <figure class="clearfix"> </figure> <div class="author-detail clearfix"> <h5>Posted by <a href="http://fta7.jp/author/fta7net" title="F太の投稿" rel="author">F太</a></h5> </div> </div>   <nav class="pagination clearfix" id="nav-below" role="navigation"> <p class="article-nav-prev"><a href="http://fta7.jp/wedding" rel="prev"><span class="meta-nav">←</span> 「欠席」の文字を芸術的に見えなくした結婚式招待状がすごい</a></p> <p class="article-nav-next"><a href="http://fta7.jp/mens_fashion" rel="next">女子には不人気かもしれないメンズファッションのNGパターン <span class="meta-nav">→</span></a></p> </nav>  <div class="comment-area" id="comments"> <p>Comments are closed</p> </div>  </div>  </div>  <div id="secondary" class="widget-area span3 main-sidebar" role="complementary"> <aside class="sidebar-widget"><form action="http://fta7.jp" id="search-form" method="get"> <input type="text" value="Search" name="s" id="s" onblur="if(this.value=='')this.value='search'" onfocus="if(this.value=='search') this.value=''" /> <input type="hidden" value="submit" /> </form></aside> <aside class="sidebar-widget"> <div class="textwidget"> <a href="https://twitter.com/fta7" onclick="__gaTracker('send', 'event', 'outbound-widget', 'https://twitter.com/fta7', '@fta7さんのツイート');" class="twitter-timeline" data-widget-id="719356507263905792">@fta7さんのツイート</a> <script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+"://platform.twitter.com/widgets.js";fjs.parentNode.insertBefore(js,fjs);}}(document,"script","twitter-wjs");</script> </div> </aside>  </div>  </div>  </div>   <div id="footer-container"> <footer class="bottom-footer" role="contentinfo"> <div class="footer-widget-area"> <div class="container"> <div class="row"> <div class="span3"> <aside class="footer-widget" role="complementary"><h4 class="widget-title" role="heading">本を出版しました</h4> <div class="textwidget"><div class="hatena-asin-detail clearfix"> <a href="http://www.amazon.co.jp/exec/obidos/asin/4804718125/amazon0d8e-22/" target="_blank" > <img src="http://ecx.images-amazon.com/images/I/51c4ASAzVQL._SL320_.jpg" alt="それを、「楽しいほう」に変えてみない？　明日ちょっと運がよくなる、思考のメモ" title="それを、「楽しいほう」に変えてみない？　明日ちょっと運がよくなる、思考のメモ" class="hatena-asin-detail-image" /> </a> <div class="hatena-asin-detail-info"> <p class="hatena-asin-detail-title"> <a href="http://www.amazon.co.jp/exec/obidos/asin/4804718125/amazon0d8e-22/" target="_blank" > それを、「楽しいほう」に変えてみない？<br>明日ちょっと運がよくなる、思考のメモ </a> </p> <div class="booklink-link2" style="margin-top:10px;"> <div class="shoplinkamazon" style="display:inline;margin-right:5px;background: url('') 0 0 no-repeat;padding: 2px 0 2px 18px;white-space: nowrap;"> <a href="http://www.amazon.co.jp/exec/obidos/asin/4804718125/amazon0d8e-22/" target="_blank" >Amazonで購入</a></div> </div> </div> <div class="booklink-footer" style="clear: left"> </div> </div></div> </aside> </div>  <div class="span3"> <aside class="footer-widget" role="complementary"><h4 class="widget-title" role="heading">カテゴリー</h4> <ul> <li class="cat-item cat-item-105"><a href="http://fta7.jp/category/%e7%af%80%e7%b4%84/diy" >DIY</a> (1) </li> <li class="cat-item cat-item-82"><a href="http://fta7.jp/category/mac-ios" >Mac.iOS</a> (1) </li> <li class="cat-item cat-item-49"><a href="http://fta7.jp/category/%e3%81%a8%e3%81%8d%e3%82%81%e3%81%8d%e6%88%90%e5%88%86" >ときめき成分</a> (130) </li> <li class="cat-item cat-item-5"><a href="http://fta7.jp/category/idea" >ひらめき</a> (63) </li> <li class="cat-item cat-item-101"><a href="http://fta7.jp/category/%e3%81%be%e3%81%a8%e3%82%81" >まとめ</a> (4) </li> <li class="cat-item cat-item-106"><a href="http://fta7.jp/category/%e3%82%a4%e3%83%99%e3%83%b3%e3%83%88" >イベント</a> (4) </li> <li class="cat-item cat-item-107"><a href="http://fta7.jp/category/%e3%82%a4%e3%83%99%e3%83%b3%e3%83%88%e5%91%8a%e7%9f%a5" >イベント告知</a> (9) </li> <li class="cat-item cat-item-50"><a href="http://fta7.jp/category/%e3%82%bb%e3%83%b3%e3%82%b9%e3%82%92%e7%a3%a8%e3%81%8f" >センスを磨く</a> (338) </li> <li class="cat-item cat-item-7"><a href="http://fta7.jp/category/%e3%82%bb%e3%83%b3%e3%82%b9%e3%82%92%e7%a3%a8%e3%81%8f/design" >デザイン・グラフィック・インテリア</a> (46) </li> <li class="cat-item cat-item-104"><a href="http://fta7.jp/category/%e7%be%8e%e5%ae%b9/%e3%83%88%e3%83%ac%e3%83%81%e3%83%8e%e3%82%a4%e3%83%b3%e3%83%bb%e3%83%8f%e3%82%a4%e3%83%89%e3%83%ad%e3%82%ad%e3%83%8e%e3%83%b3" >トレチノイン・ハイドロキノン</a> (4) </li> <li class="cat-item cat-item-8"><a href="http://fta7.jp/category/animal" >ネコ・イヌ</a> (189) </li> <li class="cat-item cat-item-10"><a href="http://fta7.jp/category/lifehack" >ライフハック</a> (109) </li> <li class="cat-item cat-item-12"><a href="http://fta7.jp/category/%e3%82%bb%e3%83%b3%e3%82%b9%e3%82%92%e7%a3%a8%e3%81%8f/recipe" >レシピ・グルメ</a> (42) </li> <li class="cat-item cat-item-51"><a href="http://fta7.jp/category/%e5%bf%83%e7%90%86%e5%ad%a6" >心理学</a> (70) </li> <li class="cat-item cat-item-81"><a href="http://fta7.jp/category/%e6%94%bf%e6%b2%bb%e7%b5%8c%e6%b8%88" >政治経済</a> (3) </li> <li class="cat-item cat-item-1"><a href="http://fta7.jp/category/%e6%9c%aa%e5%88%86%e9%a1%9e" >未分類</a> (475) </li> <li class="cat-item cat-item-48"><a href="http://fta7.jp/category/%e7%99%92%e3%81%97%e5%8a%b9%e6%9e%9c" >癒し効果</a> (84) </li> <li class="cat-item cat-item-102"><a href="http://fta7.jp/category/%e7%af%80%e7%b4%84" >節約</a> (6) </li> <li class="cat-item cat-item-103"><a href="http://fta7.jp/category/%e7%be%8e%e5%ae%b9" >美容</a> (4) </li> <li class="cat-item cat-item-100"><a href="http://fta7.jp/category/%e8%89%af%e8%a8%98%e4%ba%8b%e7%b4%b9%e4%bb%8b" >良記事紹介</a> (238) </li> <li class="cat-item cat-item-83"><a href="http://fta7.jp/category/%e8%aa%9e%e5%ad%a6" >語学</a> (1) </li> </ul> </aside> </div>  <div class="span3"> <aside class="footer-widget" role="complementary"><h4 class="widget-title" role="heading">　最近の投稿</h4><ul id="npcatch"> <li><a href="http://fta7.jp/0913radio" title="9/13 16:00くらいからお悩み相談ラジオやります"><img src="http://i1.wp.com/fta7.jp/blog/wp-content/uploads/2017/09/SS-2017-09-13-15.18.04.png?resize=150%2C150" width="75" height="75" alt="9/13 16:00くらいからお悩み相談ラジオやります" title="9/13 16:00くらいからお悩み相談ラジオやります"/><span class="title">9/13 16:00くらいからお悩み相談ラジオやります</span></a></li> <li><a href="http://fta7.jp/%e4%bc%91%e3%82%82%e3%81%86%e3%80%82" title="「休息の上位互換を探す」というアンテナを立てておくと、役にたつことがある。"><img src="http://i2.wp.com/fta7.jp/blog/wp-content/uploads/2013/01/icon.png?resize=150%2C150" width="75" height="75" alt="「休息の上位互換を探す」というアンテナを立てておくと、役にたつことがある。" title="「休息の上位互換を探す」というアンテナを立てておくと、役にたつことがある。"/><span class="title">「休息の上位互換を探す」というアンテナを立てておくと、役にたつことがある。</span></a></li> <li><a href="http://fta7.jp/cocorodo" title="【AD】アイソレーションタンクで「感覚遮断状態」を体験してみた結果、明晰夢を見た話"><img src="http://i0.wp.com/fta7.jp/blog/wp-content/uploads/2017/07/IMG_7250.jpg?resize=150%2C150" width="75" height="75" alt="【AD】アイソレーションタンクで「感覚遮断状態」を体験してみた結果、明晰夢を見た話" title="【AD】アイソレーションタンクで「感覚遮断状態」を体験してみた結果、明晰夢を見た話"/><span class="title">【AD】アイソレーションタンクで「感覚遮断状態」を体験してみた結果、明晰夢を見た話</span></a></li> <li><a href="http://fta7.jp/mcdonalds-2" title="【PR】ジューシーなビーフをフレッシュにor甘辛くorチーズと共に！楽しめる、マックの『グラン』3種が登場！"><img src="http://i0.wp.com/fta7.jp/blog/wp-content/uploads/2017/04/FullSizeRender-5.jpg?resize=150%2C150" width="75" height="75" alt="【PR】ジューシーなビーフをフレッシュにor甘辛くorチーズと共に！楽しめる、マックの『グラン』3種が登場！" title="【PR】ジューシーなビーフをフレッシュにor甘辛くorチーズと共に！楽しめる、マックの『グラン』3種が登場！"/><span class="title">【PR】ジューシーなビーフをフレッシュにor甘辛くorチーズと共に！楽しめる、マックの『グラン』3種が登場！</span></a></li> <li><a href="http://fta7.jp/hikarilab170319" title="人前で話すのが苦手な方へ〜専門的知見に基づいた役立つコミュニケーション方法を臨床心理士とF太さんがお教えします〜"><img src="http://i2.wp.com/fta7.jp/blog/wp-content/uploads/2013/01/icon.png?resize=150%2C150" width="75" height="75" alt="人前で話すのが苦手な方へ〜専門的知見に基づいた役立つコミュニケーション方法を臨床心理士とF太さんがお教えします〜" title="人前で話すのが苦手な方へ〜専門的知見に基づいた役立つコミュニケーション方法を臨床心理士とF太さんがお教えします〜"/><span class="title">人前で話すのが苦手な方へ〜専門的知見に基づいた役立つコミュニケーション方法を臨床心理士とF太さんがお教えします〜</span></a></li> <li><a href="http://fta7.jp/finc" title="【フォロワーさん限定招待コード有】人工知能を使った健康管理アプリFiNC"><img src="http://i0.wp.com/fta7.jp/blog/wp-content/uploads/2017/02/IMG_5904.jpg?resize=150%2C150" width="75" height="75" alt="【フォロワーさん限定招待コード有】人工知能を使った健康管理アプリFiNC" title="【フォロワーさん限定招待コード有】人工知能を使った健康管理アプリFiNC"/><span class="title">【フォロワーさん限定招待コード有】人工知能を使った健康管理アプリFiNC</span></a></li> <li><a href="http://fta7.jp/lifeengine-2" title="「一人コツコツ努力を重ねるのが好き」な人と仲間になりたい"><img src="http://i2.wp.com/fta7.jp/blog/wp-content/uploads/2017/02/bnr_top_main1-500x375.png?resize=150%2C150" width="75" height="75" alt="「一人コツコツ努力を重ねるのが好き」な人と仲間になりたい" title="「一人コツコツ努力を重ねるのが好き」な人と仲間になりたい"/><span class="title">「一人コツコツ努力を重ねるのが好き」な人と仲間になりたい</span></a></li> <li><a href="http://fta7.jp/mcdonalds-3" title="【PR】マックの新しいコーヒーがもはやハンドドリップの域だった"><img src="http://i0.wp.com/fta7.jp/blog/wp-content/uploads/2017/01/IMG_5848.jpg?resize=150%2C150" width="75" height="75" alt="【PR】マックの新しいコーヒーがもはやハンドドリップの域だった" title="【PR】マックの新しいコーヒーがもはやハンドドリップの域だった"/><span class="title">【PR】マックの新しいコーヒーがもはやハンドドリップの域だった</span></a></li> </ul> </aside> </div>   <div class="span3"> <aside class="footer-widget" role="complementary"> <h4 class="widget-title" role="heading">人気の投稿</h4> <ul class="wpp-list"> <li><a href="http://fta7.jp/koubou" title="賃貸でお菓子工房。一日だけのカフェ店長。スモールステップで自分の小さな夢を実現する方法" target="_self"><img src="http://fta7.jp/blog/wp-content/uploads/wordpress-popular-posts/8994-featured-75x75.jpg" width="75" height="75" title="賃貸でお菓子工房。一日だけのカフェ店長。スモールステップで自分の小さな夢を実現する方法" alt="賃貸でお菓子工房。一日だけのカフェ店長。スモールステップで自分の小さな夢を実現する方法" class="wpp-thumbnail wpp_cached_thumb wpp_featured" /></a> <a href="http://fta7.jp/koubou" title="賃貸でお菓子工房。一日だけのカフェ店長。スモールステップで自分の小さな夢を実現する方法" class="wpp-post-title" target="_self">賃貸でお菓子工房。一日だけのカフェ店長。スモールステップで自分の小さな夢を実現する方法</a> <span class="post-stats"><span class="wpp-views">145ビュー</span></span> </li> <li><a href="http://fta7.jp/mendou" title="「めんどくさい」と思うことを、わるいことと思わない方が良い。" target="_self"><img src="http://fta7.jp/blog/wp-content/uploads/wordpress-popular-posts/4388-featured-75x75.png" width="75" height="75" title="「めんどくさい」と思うことを、わるいことと思わない方が良い。" alt="「めんどくさい」と思うことを、わるいことと思わない方が良い。" class="wpp-thumbnail wpp_cached_thumb wpp_featured" /></a> <a href="http://fta7.jp/mendou" title="「めんどくさい」と思うことを、わるいことと思わない方が良い。" class="wpp-post-title" target="_self">「めんどくさい」と思うことを、わるいことと思わない方が良い。</a> <span class="post-stats"><span class="wpp-views">137ビュー</span></span> </li> <li><a href="http://fta7.jp/tenpurako" title="自炊ルーキー必見、実は万能、天ぷら粉を使ったカリッとレシピ7選" target="_self"><img src="http://fta7.jp/blog/wp-content/uploads/wordpress-popular-posts/7370-featured-75x75.jpg" width="75" height="75" title="自炊ルーキー必見、実は万能、天ぷら粉を使ったカリッとレシピ7選" alt="自炊ルーキー必見、実は万能、天ぷら粉を使ったカリッとレシピ7選" class="wpp-thumbnail wpp_cached_thumb wpp_featured" /></a> <a href="http://fta7.jp/tenpurako" title="自炊ルーキー必見、実は万能、天ぷら粉を使ったカリッとレシピ7選" class="wpp-post-title" target="_self">自炊ルーキー必見、実は万能、天ぷら粉を使ったカリッとレシピ7選</a> <span class="post-stats"><span class="wpp-views">130ビュー</span></span> </li> <li><a href="http://fta7.jp/sloth" title="「めんどくさい」を克服して、行動するための10個の戦略" target="_self"><img src="http://fta7.jp/blog/wp-content/uploads/wordpress-popular-posts/5511-featured-75x75.png" width="75" height="75" title="「めんどくさい」を克服して、行動するための10個の戦略" alt="「めんどくさい」を克服して、行動するための10個の戦略" class="wpp-thumbnail wpp_cached_thumb wpp_featured" /></a> <a href="http://fta7.jp/sloth" title="「めんどくさい」を克服して、行動するための10個の戦略" class="wpp-post-title" target="_self">「めんどくさい」を克服して、行動するための10個の戦略</a> <span class="post-stats"><span class="wpp-views">124ビュー</span></span> </li> <li><a href="http://fta7.jp/pan" title="パン別、焼きたてみたいにサクサクふんわりになるパンの温め方まとめ" target="_self"><img src="http://fta7.jp/blog/wp-content/uploads/wordpress-popular-posts/7725-featured-75x75.jpg" width="75" height="75" title="パン別、焼きたてみたいにサクサクふんわりになるパンの温め方まとめ" alt="パン別、焼きたてみたいにサクサクふんわりになるパンの温め方まとめ" class="wpp-thumbnail wpp_cached_thumb wpp_featured" /></a> <a href="http://fta7.jp/pan" title="パン別、焼きたてみたいにサクサクふんわりになるパンの温め方まとめ" class="wpp-post-title" target="_self">パン別、焼きたてみたいにサクサクふんわりになるパンの温め方まとめ</a> <span class="post-stats"><span class="wpp-views">118ビュー</span></span> </li> <li><a href="http://fta7.jp/kangaenai3" title="行動的になるコツは「考えないこと」第3話" target="_self"><img src="http://fta7.jp/blog/wp-content/uploads/wordpress-popular-posts/6131-featured-75x75.jpg" width="75" height="75" title="行動的になるコツは「考えないこと」第3話" alt="行動的になるコツは「考えないこと」第3話" class="wpp-thumbnail wpp_cached_thumb wpp_featured" /></a> <a href="http://fta7.jp/kangaenai3" title="行動的になるコツは「考えないこと」第3話" class="wpp-post-title" target="_self">行動的になるコツは「考えないこと」第3話</a> <span class="post-stats"><span class="wpp-views">113ビュー</span></span> </li> <li><a href="http://fta7.jp/cocorodo" title="【AD】アイソレーションタンクで「感覚遮断状態」を体験してみた結果、明晰夢を見た話" target="_self"><img src="http://fta7.jp/blog/wp-content/uploads/wordpress-popular-posts/9359-featured-75x75.jpg" width="75" height="75" title="【AD】アイソレーションタンクで「感覚遮断状態」を体験してみた結果、明晰夢を見た話" alt="【AD】アイソレーションタンクで「感覚遮断状態」を体験してみた結果、明晰夢を見た話" class="wpp-thumbnail wpp_cached_thumb wpp_featured" /></a> <a href="http://fta7.jp/cocorodo" title="【AD】アイソレーションタンクで「感覚遮断状態」を体験してみた結果、明晰夢を見た話" class="wpp-post-title" target="_self">【AD】アイソレーションタンクで「感覚遮断状態」を体験してみた結果、明晰夢を見た話</a> <span class="post-stats"><span class="wpp-views">112ビュー</span></span> </li> </ul> </aside> </div>   </div>  </div>  </div>  <div class="copyright-container clearfix"> <div class="container"> <p>© 2018 <a href="http://fta7.jp">ひらめき箱</a></p> </div>  </div>  </footer>  </div>  </div>  <div style="display:none"> </div>  <script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+'://platform.twitter.com/widgets.js';fjs.parentNode.insertBefore(js,fjs);}}(document, 'script', 'twitter-wjs');</script>  <script type="text/javascript"> window.WPCOM_sharing_counts = {"http:\/\/fta7.jp\/excel":567}; </script> <script type="text/javascript"> var windowOpen; jQuery(document).on( 'ready post-load', function(){ jQuery( 'a.share-twitter' ).on( 'click', function() { if ( 'undefined' !== typeof windowOpen ){ // If there's another sharing window open, close it. windowOpen.close(); } windowOpen = window.open( jQuery(this).attr( 'href' ), 'wpcomtwitter', 'menubar=1,resizable=1,width=600,height=350' ); return false; }); }); </script> <script type="text/javascript"> var windowOpen; jQuery(document).on( 'ready post-load', function(){ jQuery( 'a.share-facebook' ).on( 'click', function() { if ( 'undefined' !== typeof windowOpen ){ // If there's another sharing window open, close it. windowOpen.close(); } windowOpen = window.open( jQuery(this).attr( 'href' ), 'wpcomfacebook', 'menubar=1,resizable=1,width=600,height=400' ); return false; }); }); </script> <script type="text/javascript"> var windowOpen; jQuery(document).on( 'ready post-load', function(){ jQuery( 'a.share-google-plus-1' ).on( 'click', function() { if ( 'undefined' !== typeof windowOpen ){ // If there's another sharing window open, close it. windowOpen.close(); } windowOpen = window.open( jQuery(this).attr( 'href' ), 'wpcomgoogle-plus-1', 'menubar=1,resizable=1,width=480,height=550' ); return false; }); }); </script> <script type='text/javascript' src='http://fta7.jp/blog/wp-includes/js/comment-reply.min.js?ver=4.5.15'></script> <script type='text/javascript' src='http://fta7.jp/blog/wp-content/plugins/jetpack/modules/photon/photon.js?ver=20130122'></script> <script type='text/javascript' src='http://fta7.jp/blog/wp-content/plugins/contact-form-7/includes/js/jquery.form.min.js?ver=3.51.0-2014.06.20'></script> <script type='text/javascript'> /* <![CDATA[ */ var _wpcf7 = {"loaderUrl":"http:\/\/fta7.jp\/blog\/wp-content\/plugins\/contact-form-7\/images\/ajax-loader.gif","recaptcha":{"messages":{"empty":"\u3042\u306a\u305f\u304c\u30ed\u30dc\u30c3\u30c8\u3067\u306f\u306a\u3044\u3053\u3068\u3092\u8a3c\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002"}},"sending":"\u9001\u4fe1\u4e2d ...","cached":"1"}; /* ]]> */ </script> <script type='text/javascript' src='http://fta7.jp/blog/wp-content/plugins/contact-form-7/includes/js/scripts.js?ver=4.5'></script> <script type='text/javascript'> /* <![CDATA[ */ var pollsL10n = {"ajax_url":"http:\/\/fta7.jp\/blog\/wp-admin\/admin-ajax.php","text_wait":"Your last request is still being processed. Please wait a while ...","text_valid":"Please choose a valid poll answer.","text_multiple":"Maximum number of choices allowed: ","show_loading":"1","show_fading":"1"}; /* ]]> */ </script> <script type='text/javascript' src='http://fta7.jp/blog/wp-content/plugins/wp-polls/polls-js.js?ver=2.73.7'></script> <script type='text/javascript' src='http://s0.wp.com/wp-content/js/devicepx-jetpack.js?ver=201829'></script> <script type='text/javascript' src='http://fta7.jp/blog/wp-content/themes/exray/js/scripts.js?ver=4.5.15'></script> <script type='text/javascript' src='http://fta7.jp/blog/wp-content/plugins/dynamic-to-top/js/libs/jquery.easing.js?ver=1.3'></script> <script type='text/javascript'> /* <![CDATA[ */ var mv_dynamic_to_top = {"text":"To Top","version":"0","min":"500","speed":"700","easing":"easeInExpo","margin":"20"}; /* ]]> */ </script> <script type='text/javascript' src='http://fta7.jp/blog/wp-content/plugins/dynamic-to-top/js/dynamic.to.top.min.js?ver=3.5'></script> <script type='text/javascript' src='http://fta7.jp/blog/wp-includes/js/wp-embed.min.js?ver=4.5.15'></script> <script type='text/javascript'> /* <![CDATA[ */ var sharing_js_options = {"lang":"en","counts":"1"}; /* ]]> */ </script> <script type='text/javascript' src='http://fta7.jp/blog/wp-content/plugins/jetpack/modules/sharedaddy/sharing.js?ver=4.1.1'></script> <script type='text/javascript' src='http://stats.wp.com/e-201829.js' async defer></script> <script type='text/javascript'> _stq = window._stq || []; _stq.push([ 'view', {v:'ext',j:'1:4.1.1',blog:'27093861',post:'567',tz:'9',srv:'fta7.jp'} ]); _stq.push([ 'clickTrackerInit', '27093861', '567' ]); </script>  </body> </html>