<!-- WP QUADS Content Ad Plugin v. 2.0.99 -->
<div class="quads-location quads-ad3" id="quads-ad3" style="float:none;margin:50px 0 50px 0;text-align:center;">

</div>

<div class="wp-block-st-blocks-my-box st-mybox has-title st-title-border" style="background-color:#fff;border-width:3px;border-color:#8ed1fc;margin-top:100px;margin-bottom:100px"><p class="st-mybox-title" style="color:#8ed1fc;font-weight:bold;border-bottom-color:#8ed1fc;background-color:#fff"><i aria-hidden="true" class="fa fa-user st-css-no"></i>ã“ã‚“ãªæ–¹ã«ãŠã™ã™ã‚</p><div class="st-in-mybox">
<ul class="is-style-st-circle wp-block-list"><li>実験レãƒãƒ¼ãƒˆã‚’ç´ æ—©ã終ã‚らã›ãŸã„æ–¹</li><li>エクセルæ“作ãŒè‹¦æ‰‹ãªæ–¹</li><li>実験ã®ãƒ‡ãƒ¼ã‚¿æ•´ç†ã‚’エクセルã§è¡Œã†æ–¹</li></ul>
</div></div>



<p>ã“ã‚“ãªãŠæ‚©ã¿ã‚’解決ã—ã¾ã™ã€‚</p>



<div class="wp-block-st-blocks-my-box st-mybox has-title st-title-border" style="background-color:#fff;border-width:3px;border-color:#7bdcb5;margin-top:100px;margin-bottom:100px"><p class="st-mybox-title" style="color:#7bdcb5;font-weight:bold;border-bottom-color:#7bdcb5;background-color:#fff"><i aria-hidden="true" class="fa fa-file-text-o st-css-no"></i>本記事ã®å†…容</p><div class="st-in-mybox">
<ul class="is-style-st-circle wp-block-list"><li>エクセルã®ä¾¿åˆ©ãªæ©Ÿèƒ½ã‚’使ã†ãƒ¡ãƒªãƒƒãƒˆ</li><li>実験レãƒãƒ¼ãƒˆã§ä½¿ãˆã‚‹ã‚¨ã‚¯ã‚»ãƒ«ã®ä¾¿åˆ©ãªæ©Ÿèƒ½ä¸€è¦§</li></ul>
</div></div>



<p>å¦ç”Ÿå®Ÿé¨“ã«ãŠã„ã¦ï¼Œãƒ‡ãƒ¼ã‚¿ã®æ•´ç†ã¯æ¬ ã‹ã›ã¾ã›ã‚“。</p>



<p>データã®æ•´ç†ã«ã¯ï¼Œã‚¨ã‚¯ã‚»ãƒ«ãªã©ã®è¡¨è¨ˆç®—ソフトを用ã„ã‚‹æ–¹ãŒå¤šã„ã¨æ€ã„ã¾ã™ãŒï¼Œæ•´ç†ã«æ™‚é–“ãŒã‹ã‹ã£ã¦ã—ã¾ã£ã¦ï¼Œã§ãã‚‹ã ã‘時çŸã§è¡Œã„ãŸã„ã¨ã„ã†æ–¹ãŒãŠã‚‰ã‚Œã‚‹ã¨æ€ã„ã¾ã™ã€‚</p>



<p>本記事ã¯ãã‚“ãªæ™‚çŸåŠ¹æžœã¨ã‚¹ãƒˆãƒ¬ã‚¹ãƒ•ãƒªãƒ¼ã‚’ç‹™ã£ãŸã‚¨ã‚¯ã‚»ãƒ«ã®ä¾¿åˆ©æ©Ÿèƒ½5é¸ã‚’紹介ã—ã¾ã™ã€‚</p>



<h2 class="wp-block-heading">エクセルã®ä¾¿åˆ©ãªæ©Ÿèƒ½ã‚’使ã†ãƒ¡ãƒªãƒƒãƒˆ</h2>



<p>ã¾ãšï¼Œå…·ä½“çš„ãªã‚¨ã‚¯ã‚»ãƒ«ã®ä¾¿åˆ©æ©Ÿèƒ½ã‚’ã”紹介ã™ã‚‹å‰ã«ï¼Œä¾¿åˆ©æ©Ÿèƒ½ã‚’ç¿’å¾—ã™ã‚‹ã¨ã©ã‚“ãªãƒ¡ãƒªãƒƒãƒˆãŒã‚‹ã®ã‹ç¢ºèªã—ã¦ã„ãã¾ã—ょã†ã€‚</p>



<ul class="is-style-st-no-border wp-block-list"><li>レãƒãƒ¼ãƒˆã®ãƒ‡ãƒ¼ã‚¿æ•´ç†ãŒé€Ÿããªã‚‹</li><li>ストレスãŒæ¸›ã‚‹</li></ul>



<h3 class="wp-block-heading">レãƒãƒ¼ãƒˆã®ãƒ‡ãƒ¼ã‚¿æ•´ç†ãŒé€Ÿããªã‚‹</h3>



<p>言ã‚ãšã‚‚ãŒãªã§ã™ãŒï¼Œã‚¨ã‚¯ã‚»ãƒ«ã®ä¾¿åˆ©æ©Ÿèƒ½ã‚’使ã„ã“ãªã™ã“ã¨ã§ï¼Œãƒ‡ãƒ¼ã‚¿æ•´ç†ãŒé€Ÿããªã‚Šã¾ã™ã€‚</p>



<p>ã“ã“ã§ã„ã†ï¼Œãƒ‡ãƒ¼ã‚¿æ•´ç†ã¨ã¯ï¼Œè¡¨ã®ä½œæˆï¼Œã‚°ãƒ©ãƒ•ã®ä½œæˆã¯ã‚‚ã¡ã‚ã‚“ã®ã“ã¨ï¼Œã‚¨ã‚¯ã‚»ãƒ«ã‚’用ã„ãŸè¨ˆç®—ã®ã“ã¨ã§ã™ã€‚</p>



<p>実験ã§å¾—られãŸç”Ÿãƒ‡ãƒ¼ã‚¿ã‚’エクセルã«å…¥åŠ›ã—ã¦ï¼Œã‚²ãƒƒãƒˆã—ãŸã„実験çµæžœã‚„考察çµæžœã‚’å–å¾—ã™ã‚‹ãŸã‚ã«å¿…è¦ãªè¨ˆç®—ã‚’ã—ã¦ï¼Œè¡¨ã‚„グラフã«ã¾ã¨ã‚ã‚‹ã¨ã„ã£ãŸä¸€é€£ã®æµã‚Œã¯ã»ã¼ã‚¨ã‚¯ã‚»ãƒ«ã§å®Œçµã—ã¾ã™ã€‚</p>



<p>逆ã«è¨€ãˆã°ï¼Œã‚¨ã‚¯ã‚»ãƒ«ã§ã®ãƒ‡ãƒ¼ã‚¿æ•´ç†ãŒçµ‚ã‚ã£ã¦ã—ã¾ãˆã°ï¼Œãƒ¬ãƒãƒ¼ãƒˆã®50％程度ã¯çµ‚ã‚ã£ãŸã¨è¨€ã£ã¦ã‚‚éŽè¨€ã§ã¯ãªã„ã§ã—ょã†ã€‚</p>



<p>ã§ã™ã‹ã‚‰ï¼Œã“ã®ãƒ‡ãƒ¼ã‚¿æ•´ç†ã«æ™‚é–“ãŒã‹ã‹ã‚Œã°ï¼Œãƒ¬ãƒãƒ¼ãƒˆã‚’終ã‚らã›ã‚‹æ™‚é–“ã‚‚ãã‚Œã ã‘ã‹ã‹ã£ã¦ã—ã¾ã„ã¾ã™ã€‚</p>



<p>便利機能を覚ãˆã¦ã„ãŸã ãã ã‘ã§ï¼Œã¯ã‚‹ã‹ãªæ™‚çŸãŒæœŸå¾…ã§ãã¾ã™ã€‚</p>



<h3 class="wp-block-heading">ストレスãŒæ¸›ã‚‹</h3>



<p>ã‚‚ã†ã²ã¨ã¤ã®ãƒ¡ãƒªãƒƒãƒˆã¨ã—ã¦ã¯ï¼Œã‚¹ãƒˆãƒ¬ã‚¹ãŒæ¸›ã‚‹ã¨ã„ã†ã“ã¨ã ã¨æ€ã„ã¾ã™ã€‚</p>



<p>データ整ç†ã‚’è¡Œã£ã¦ã„ã‚‹ã¨ãã«ï¼Œã€Œã“ã®æ“作もã£ã¨æ¥½ã«ã§ããªã„ã®ã‹ï¼Ÿã€ã¨æ€ã£ãŸçµŒé¨“ãŒã‚る方も多ã„ã¨æ€ã„ã¾ã™ã€‚</p>



<p>ãã‚ŒãŒï¼Œè§£æ±ºã§ããŸæ™‚ã«ã¯ï¼Œä»Šã¾ã§æœŸé–“ã‚’ã‹ã‘ã¦ã‚„ã£ã¦ããŸæ“作ãŒã°ã‹ã°ã‹ã—ããªã‚‹ã¨åŒæ™‚ã«ï¼Œä¸€ç™ºã§ãã®æ“作を行ãˆãŸã‚Šã§ãã‚‹ã®ã§çµæ§‹æ°—分ãŒè‰¯ããªã‚Šã¾ã™ã€‚</p>



<p>ãã‚Œã§ã¯ï¼Œå‰ç½®ãã¯ã“ã®è¾ºã«ã—ã¦ã•ã£ããレãƒãƒ¼ãƒˆã«ä½¿ãˆã‚‹ã‚¨ã‚¯ã‚»ãƒ«ã®ä¾¿åˆ©æ©Ÿèƒ½ã‚’ã”紹介ã—ã¦ã„ãã¾ã™ï¼</p>



<h2 class="wp-block-heading">実験レãƒãƒ¼ãƒˆã§ä½¿ãˆã‚‹ã‚¨ã‚¯ã‚»ãƒ«ã®ä¾¿åˆ©æ©Ÿèƒ½</h2>



<ul class="is-style-st-no-border wp-block-list"><li>テンプレート</li><li>ショートカット</li><li>関数</li><li>オートフィル</li><li>貼り付ã‘オプション</li><li>セルã®å…¥ã‚Œæ›¿ãˆ</li></ul>



<p>ã²ã¨ã¤ãšã¤è¦‹ã¦ã„ãã¾ã—ょã†ã€‚</p>



<h3 class="wp-block-heading">テンプレート</h3>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image1-2.png" alt="" class="wp-image-1415"/></figure>



<p>テンプレート機能ã¯ï¼Œä¸€åº¦è¨å®šã—ãŸã‚ªãƒªã‚¸ãƒŠãƒ«ã®æ›¸å¼è¨å®šãªã©ã‚’ä¿å˜ã—，呼ã³å‡ºã›ã‚‹æ©Ÿèƒ½ã§ã™ã€‚</p>



<p>グラフã«ã¤ã„ã¦ã¯ï¼Œã‚¨ã‚¯ã‚»ãƒ«ã®åˆæœŸè¨å®šã§ã¯ãƒ¬ãƒãƒ¼ãƒˆã«ä¸é©åˆ‡ãªæ›¸å¼ã«ãªã£ã¦ã„ã‚‹ã®ã§å¤‰æ›´ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚</p>



<p>ã—ã‹ã—，一ã‹ã‚‰ä½•åº¦ã‚‚ç›´ã—ã¦ã„ãã®ã¯éžå¸¸ã«æ™‚é–“ãŒã‹ã‹ã£ã¦ã—ã¾ã„ã¾ã™ã€‚</p>



<p>ãã‚“ãªã¨ãã«æ´»èºã™ã‚‹ã®ãŒï¼Œãƒ†ãƒ³ãƒ—レートã§ã™ã€‚</p>



<p>ã“ã¡ã‚‰ã¯ï¼Œä»¥å‰ã«ã‚‚紹介ã—ã¾ã—ãŸä»¥ä¸‹ã®è¨˜äº‹ã§è©³ã—ã説明ã—ã¦ã„ã¾ã™ã€‚</p>



			<div class="kanren st-cardbox">
								<dl class="clearfix">
					<dt class="st-card-img"><a href="https://saborepo.com/glaph-making/1265/amp/">
															<img width="100" height="100" src="https://saborepo.com/wp-content/uploads/2021/07/1265-1-100x100.png" class="attachment-100x100 size-100x100 wp-post-image" alt="" srcset="https://saborepo.com/wp-content/uploads/2021/07/1265-1-100x100.png 100w, https://saborepo.com/wp-content/uploads/2021/07/1265-1-150x150.png 150w" sizes="(max-width: 100px) 100vw, 100px" />													</a></dt>
					<dd>
													<h5 class="st-cardbox-t"><a href="https://saborepo.com/glaph-making/1265/amp/">エクセルを用ã„ãŸå¦ç”Ÿå®Ÿé¨“ã®ã‚°ãƒ©ãƒ•ã®æ›¸ã方～効率ã®è‰¯ã„書ã方～</a></h5>
						
						
													<p class="cardbox-more"><a href="https://saborepo.com/glaph-making/1265/amp/">続ãを見る</a></p>
											</dd>
				</dl>
			</div>
			



<h3 class="wp-block-heading">ショートカット</h3>



<p>ショートカットã¯ï¼Œãƒžã‚¦ã‚¹ã§è¡Œã£ã¦ã„ãŸæ“作をã‚ーボード上ã§è¡Œãˆã‚‹æ©Ÿèƒ½ã§ã™ã€‚</p>



<p>マウスã«æ‰‹ã‚’触れã¦ã„る時間ãŒå¤šã„ã»ã©ï¼Œæ™‚çŸã‹ã‚‰ã¯ç¨‹é ããªã‚Šã¾ã™ã€‚</p>



<p>ãœã²ãƒžã‚¹ã‚¿ãƒ¼ã—ã¦ãã ã•ã„。</p>



<p>時çŸã«ã¤ãªãŒã‚‹ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚ーã®ä¸€è¦§ã‚’以下ã®è¨˜äº‹ã«è¼‰ã›ã¦ã„ã¾ã™ã®ã§å‚考ã«ã—ã¦ãã ã•ã„。</p>



			<div class="kanren st-cardbox">
								<dl class="clearfix">
					<dt class="st-card-img"><a href="https://saborepo.com/shortcut-key/1357/amp/">
															<img width="100" height="100" src="https://saborepo.com/wp-content/uploads/2021/07/1357-1-100x100.png" class="attachment-100x100 size-100x100 wp-post-image" alt="" srcset="https://saborepo.com/wp-content/uploads/2021/07/1357-1-100x100.png 100w, https://saborepo.com/wp-content/uploads/2021/07/1357-1-150x150.png 150w" sizes="(max-width: 100px) 100vw, 100px" />													</a></dt>
					<dd>
													<h5 class="st-cardbox-t"><a href="https://saborepo.com/shortcut-key/1357/amp/">レãƒãƒ¼ãƒˆä½œæˆæ™‚ã«å½¹ç«‹ã¤ä¾¿åˆ©ãªã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚ー一覧</a></h5>
						
						
													<p class="cardbox-more"><a href="https://saborepo.com/shortcut-key/1357/amp/">続ãを見る</a></p>
											</dd>
				</dl>
			</div>
			



<h3 class="wp-block-heading">関数</h3>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image2-2-1024x66.png" alt="" class="wp-image-1426"/></figure>



<p>実験データを整ç†ã™ã‚‹ä¸Šã§æ¬ ã‹ã›ãªã„ã®ãŒï¼Œé–¢æ•°ã®å˜åœ¨ã§ã™ã€‚</p>



<p>データã®å¹³å‡å€¤ï¼Œæœ€å¤§å€¤ï¼Œæœ€å°å€¤ï¼Œæ¨™æº–åå·®ãªã©ã¯é–¢æ•°ã‚’用ã„ã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚</p>



<p>以下ã«ï¼Œå®Ÿé¨“レãƒãƒ¼ãƒˆã§ã‚ˆã用ã„る関数をã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚</p>



<ul class="is-style-st-check wp-block-list"><li>åˆè¨ˆ sum(データ範囲)</li><li>å¹³å‡ average(データ範囲)</li><li>å››æ¨äº”å…¥ round(数値,æ¡æ•°)</li><li>標準åå·® stdev(データ範囲)</li></ul>



<p>詳細ã¯ï¼Œåˆ¥è¨˜äº‹ã§è§£èª¬ã™ã‚‹äºˆå®šã§ã™ã€‚</p>



<h3 class="wp-block-heading">オートフィル</h3>



<p>ã“ã®è¨˜äº‹ã§ä¸€ç•ªç´¹ä»‹ã—ãŸã‹ã£ãŸå†…容ãŒã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«æ©Ÿèƒ½ã§ã™ã€‚</p>



<p>ã¾ãšåˆã‚ã«ï¼Œã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«æ©Ÿèƒ½ã£ã¦ãªã‚“や？ã£ã¦æ–¹ã¯ï¼Œä»Šã™ã覚ãˆã¾ã—ょã†ã€‚</p>



<p>éžå¸¸ã«ï¼Œæã—ã¦ã„ã¾ã™ã€‚</p>



<p>ç§è‡ªèº«ï¼Œåˆã‚ã¦çŸ¥ã£ãŸæ™‚ã¯æ„Ÿå‹•ã—ã¾ã—ãŸã€‚</p>



<p>オートフィル機能ã¨ã¯ï¼Œ<strong>コンピューターãŒï¼Œäººé–“ãŒæ„図ã—ã¦ã„ã‚‹ã“ã¨ï¼ˆã™ã§ã«ã‚»ãƒ«ã«å…¥åŠ›ã—ã¦ã‚ã‚‹æƒ…å ±ï¼‰ã‚’ãã¿å–ã£ã¦å…¥åŠ›ã‚’補助ã—ã¦ãれる機能</strong>ã§ã™ã€‚</p>
<!-- WP QUADS Content Ad Plugin v. 2.0.99 -->
<div class="quads-location quads-ad2" id="quads-ad2" style="float:none;margin:50px 0 50px 0;text-align:center;">

</div>




<p>オート（auto：自動ã§ï¼‰ãƒ•ã‚£ãƒ«ï¼ˆfill：埋ã‚る）機能ã§ã™ã。</p>



<p>オートフィル機能をデータ整ç†ã§ä½¿ã†ã¨ãã¯ï¼Œä¸»ã«ä»¥ä¸‹ã®2ã¤ã®æ©Ÿèƒ½ã‚’使ã„ã¾ã™ã€‚</p>



<ul class="is-style-st-check wp-block-list"><li>予測入力</li><li>æ•°å¼ã®è‡ªå‹•å…¥åŠ›</li></ul>



<h4 class="wp-block-heading">予測入力</h4>



<p>ã“ã‚Œã¯ï¼Œã‚»ãƒ«ã«ã€Œ1ã€ã€Œ2ã€ã¨å…¥åŠ›ã™ã‚‹ã¨ï¼Œè‡ªå‹•ã§ï¼Œã€Œ3ã€ã€Œ4ã€ï¼Œã€Œãƒ»ãƒ»ãƒ»ã€ã¨å…¥åŠ›ã—ã¦ãれる機能ã§ã™ã€‚</p>



<p>ã§ã¯å®Ÿè·µã—ã¦ã¿ã¾ã—ょã†ã€‚</p>



<p>ã¾ãšã¯ï¼Œé€£ç¶šã§ï¼Œ1,2,3,,,,,9,10ã¨å…¥åŠ›ã—ã¦ã¿ã¾ã—ょã†ã€‚</p>



<p>ã¾ãšï¼Œ1,2ã¨ã ã‘セルã«å…¥åŠ›ã—ã¾ã™ã€‚å³ä¸‹ã®ãƒãƒ§ãƒœã‚’C13ã¾ã§ãƒ‰ãƒ©ãƒƒã‚°ã—ã¦ã¿ã¾ã—ょã†ã€‚</p>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image3-2.png" alt="" class="wp-image-1428"/></figure>



<p>ã™ã‚‹ã¨ï¼Œã‚³ãƒ³ãƒ”ューターãŒè‡ªå‹•ã§ï¼Œ10ã¾ã§å…¥åŠ›ã—ã¦ãã‚Œã¾ã™ã€‚</p>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image4-2.png" alt="" class="wp-image-1429"/></figure>



<p>次ã«ï¼Œ5を連続ã§å…¥åŠ›ã—ã¦ã¿ã¾ã—ょã†ã€‚コピーã§ã‚‚連続入力ã§ãã¾ã™ãŒï¼Œã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«æ©Ÿèƒ½ã®æ–¹ãŒé€Ÿã„ã§ã™ã€‚åŒæ§˜ã«ï¼Œã‚„ã£ã¦ã¿ã‚‹ã¨ï¼Œ</p>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image5-2.png" alt="" class="wp-image-1430"/></figure>



<p>ã“ã®ã‚ˆã†ã«ï¼Œ5ãŒé€£ç¶šã§å…¥åŠ›ã•ã‚Œã¾ã™ã€‚</p>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image6-2.png" alt="" class="wp-image-1431"/></figure>



<p>オートフィル機能ã¯ï¼Œã‚る一定ã®ç¹°ã‚Šè¿”ã—も入力ã—ã¦ãã‚Œã¾ã™ã€‚1,10,1,10ã®ã‚ˆã†ã«ç¹°ã‚Šè¿”ã—入力ã•ã›ã¦ã¿ã¾ã—ょã†ã€‚ã¾ãšï¼Œã‚»ãƒ«ã«1,10ã¨å…¥åŠ›ã—ã¦ï¼Œã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã—ã¦ã¿ã¦ãã ã•ã„。</p>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image7-2-1024x564.png" alt="" class="wp-image-1432"/></figure>



<p>ã™ã‚‹ã¨ä»Šåº¦ã¯ï¼ŒæœŸå¾…通りã«ã¯ã„ã‹ãªã‹ã£ãŸã§ã™ã。ã“ã‚Œã¯ï¼Œã‚³ãƒ³ãƒ”ューターãŒãƒ‡ãƒ¼ã‚¿ã‚’「連続データã€ã¨ã—ã¦èªè˜ã—，1,10,19,,,,ã¨äº¤å·®9ã®ç‰å·®æ•°åˆ—ã¨ã—ã¦èªè˜ã—ã¦ã„ã‚‹ãŸã‚ã§ã™ã€‚図ã®ã‚ˆã†ã«ï¼Œå³ä¸‹ã®ãƒžãƒ¼ã‚¯ã‚’クリックã™ã‚‹ã¨ï¼Œ</p>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image8-2-1024x577.png" alt="" class="wp-image-1433"/></figure>



<p>オプションãŒå‡ºç¾ã—ã¾ã™ã€‚実ã¯ï¼Œã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«æ©Ÿèƒ½ã«ã¯è¤‡æ•°ã®æ©Ÿèƒ½ãŒã‚り，åˆæœŸè¨å®šã§ã¯ï¼Œã€Œé€£ç¶šãƒ‡ãƒ¼ã‚¿ã€ã«ãªã£ã¦ã„ã¾ã™ã€‚今回ã¯ï¼Œ1ã¨10ã®ç¹°ã‚Šè¿”ã—ã«ã—ãŸã„ã®ã§ï¼Œä¸€ç•ªä¸Šã®ã€Œã‚»ãƒ«ã®ã‚³ãƒ”ーã€ã‚’é¸æŠžã—ã¾ã—ょã†ã€‚</p>



<div class="wp-block-image"><figure class="aligncenter size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image9-2.png" alt="" class="wp-image-1434"/></figure></div>



<p>ã“ã‚Œã§ï¼Œç„¡äº‹1ã¨10ã®ç¹°ã‚Šè¿”ã—ãŒã§ãã¾ã—ãŸã€‚</p>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image10-2-1024x547.png" alt="" class="wp-image-1416"/></figure>



<h4 class="wp-block-heading">æ•°å¼ã®è‡ªå‹•å…¥åŠ›</h4>



<p>オートフィル機能ã§ã‚ˆã使ã†ã‚‚ã†ã²ã¨ã¤ã®æ©Ÿèƒ½ã«ï¼Œæ•°å¼ã®è‡ªå‹•å…¥åŠ›ãŒã‚ã‚Šã¾ã™ã€‚</p>



<p>ã“ã‚Œã¯ï¼Œæ—¢ã«å…¥åŠ›ã—ãŸæ•°å¼ã‚’自動ã§å…¥åŠ›ã—ã¦ãれる機能ã§ã™ã€‚</p>



<p>ã“れも，実際ã«ã‚„ã£ã¦ã¿ã¾ã—ょã†ã€‚E列ã«C列ã¨D列ã®æ•°å€¤ã®å’Œã‚’入力ã—ã¦ã„ãã¾ã™ã€‚</p>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image11-2.png" alt="" class="wp-image-1417"/></figure>



<p>ã¾ãšï¼ŒE4ã«ã€Œ=C4+D4ã€ã¨å…¥åŠ›ã—ã¦Enterを押ã—ã¾ã™ã€‚</p>



<div class="wp-block-image"><figure class="aligncenter size-full"><img src="https://saborepo.com/wp-content/uploads/2021/07/image-12.png" alt="" class="wp-image-1440"/></figure></div>



<p>ã“ã“ã‹ã‚‰ã¯ã„ã¤ã‚‚ã©ãŠã‚Šã§ï¼Œå³ä¸‹ã®ãƒãƒ§ãƒœã‚’E13ã¾ã§ãƒ‰ãƒ©ãƒƒã‚°ã—ã¾ã™ã€‚</p>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image13-2.png" alt="" class="wp-image-1419"/></figure>



<p>ã™ã‚‹ã¨ï¼Œã“ã®ã‚ˆã†ã«è‡ªå‹•çš„ã«æ•°å¼ã‚’èªã¿å–り，入力ã—ã¦ãã‚Œã¾ã™ã€‚</p>



<div class="wp-block-image"><figure class="aligncenter size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image14-2.png" alt="" class="wp-image-1420"/></figure></div>



<p>ã—ã‹ã—，ã“ã®æ•°å¼ã‚’コピーã™ã‚‹æ–¹ã§ã¯ï¼Œã‚‚ã†ã²ã¨ã¤é€Ÿã„方法ãŒã‚ã‚‹ã®ã§ã”紹介ã—ã¾ã™ã€‚E4ã«æ•°å¼ã‚’入力ã™ã‚‹ã¾ã§ã¯åŒã˜ã§ã™ã€‚実ã¯ï¼Œå³ä¸‹ã®ãƒãƒ§ãƒœã‚’ダブルクリックã™ã‚‹ã ã‘ã§ï¼Œå€¤ãŒå…¥åŠ›ã•ã‚Œã¦ã„るセルã¾ã§è‡ªå‹•çš„ã«è¨ˆç®—ã—ã¦ãれるã®ã§ã™ã€‚</p>



<div class="wp-block-image"><figure class="aligncenter size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image15-1.png" alt="" class="wp-image-1421"/></figure></div>



<p>ã“ã‚Œã¯ï¼Œãƒ‡ãƒ¼ã‚¿ãŒæ•°å個，百個ã¾ã§ãªã‚‰ã¾ã ã—も，数åƒå€‹ã¨ã‹ã«ãªã£ã¦ãã‚‹ã¨ã“ã®ãƒ€ãƒ–ルクリックã®å¨åŠ›ãŒç™ºæ®ã•ã‚Œã¾ã™ã€‚ã“ã‚Œã¯ãœã²è¦šãˆã¦ã„ãŸã ããŸã„便利機能ã§ã™ã€‚</p>



<div class="wp-block-image"><figure class="aligncenter size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image16-1.png" alt="" class="wp-image-1422"/></figure></div>



<h3 class="wp-block-heading">貼り付ã‘オプション</h3>



<div class="wp-block-image"><figure class="aligncenter size-full"><img src="https://saborepo.com/wp-content/uploads/2021/07/image-13.png" alt="" class="wp-image-1442"/></figure></div>



<p>ã“ã‚Œã¯ï¼Œã‚¨ã‚¯ã‚»ãƒ«ï¼Œãƒ¯ãƒ¼ãƒ‰ï¼Œãƒ‘ワãƒã©ã‚Œã«ã‚‚言ãˆã‚‹ã“ã¨ã§ã™ãŒï¼Œã‚³ãƒ”ーã—ãŸã‚‚ã®ã‚’張りã¤ã‘ã‚‹ã¨ãã«è²¼ã‚Šä»˜ã‘オプションãŒä½¿ãˆã¾ã™ã€‚</p>



<p>貼り付ã‘オプションã¯ï¼Œè²¼ã‚Šä»˜ã‘ã‚‹éš›ã«ã€Œã©ã‚“ãªæƒ…å ±ã‚’è²¼ã‚Šä»˜ã‘ã‚‹ã‹ã€ã¨ã„ã†ã“ã¨ã‚’é¸ã¹ã‚‹æ©Ÿèƒ½ã§ã™ã€‚</p>



<p>貼り付ã‘å…ˆã®çŠ¶æ³ã«åˆã‚ã›ã¦é©åˆ‡ãªã‚ªãƒ—ションをé¸ã¶ã“ã¨ã§ï¼Œæ™‚çŸã«ã¤ãªã’ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚</p>



<p>貼り付ã‘オプションã«ã¤ã„ã¦ã¯ï¼Œåˆ¥è¨˜äº‹ã§è©³ã—ã解説ã™ã‚‹äºˆå®šã§ã™ã€‚</p>



<h3 class="wp-block-heading">セルã®å…¥ã‚Œæ›¿ãˆ</h3>



<p>「コピーã—ãŸã‚‚ã®ã‚’é–“é•ã£ã¦ï¼Œåˆ¥ã®ã‚»ãƒ«ã«è²¼ã‚Šä»˜ã‘ã¦ã—ã¾ã£ãŸã€ã¨ã‹ï¼Œã€Œã“ã®ã‚»ãƒ«ã®å†…容ã¨ã“ã®ã‚»ãƒ«ã®å†…容を入れ替ãˆãŸã„ã€ã¨ã„ã†ã¨ãã«ä½¿ã„ã¾ã™ã€‚</p>



<p>具体例を見ãŸæ–¹ãŒé€Ÿã„ã®ã§ï¼Œè¦‹ã¦ã„ãã¾ã—ょã†ã€‚</p>



<p>E列ã¨F列を入れ替ãˆã¦ã¿ã¾ã—ょã†ã€‚</p>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image17-1.png" alt="" class="wp-image-1423"/></figure>



<p>ã¾ãšï¼ŒE3ã‹ã‚‰E13を範囲é¸æŠžã—ã¾ã™ã€‚ãã—ã¦ï¼Œå¤–æž ã®ä¸Šã«ã‚«ãƒ¼ã‚½ãƒ«ã‚’ã‚‚ã£ã¦ã„ãã¨ï¼Œã‚«ãƒ¼ã‚½ãƒ«ã®ãƒžãƒ¼ã‚¯ãŒç§»å‹•ãƒžãƒ¼ã‚¯ã«å¤‰ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚</p>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image18-1.png" alt="" class="wp-image-1424"/></figure>



<p>ãã“ã§ï¼Œç§»å‹•ãƒžãƒ¼ã‚¯ã®çŠ¶æ…‹ã«ãªã£ãŸã‚«ãƒ¼ã‚½ãƒ«ã‚’ドラッグã—ãŸã¾ã¾ï¼ŒShiftã‚ーを押ã™ã¨ï¼Œè¨˜å·ãŒå‡ºã¦ãã¾ã™ã€‚F列ã¨G列ã«æ¥ãŸæ™‚ã«ï¼Œã‚«ãƒ¼ã‚½ãƒ«ã‚’離ã—ã¦ï¼ˆãƒ‰ãƒãƒƒãƒ—ã—ã¦ï¼‰ãã ã•ã„。</p>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image19-1.png" alt="" class="wp-image-1425"/></figure>



<p>ã“ã‚Œã§ï¼Œå…¥ã‚Œæ›¿ãˆãŒå®Œäº†ã—ã¾ã—ãŸï¼ã“ã®ä¾‹ã§ã¯ï¼Œã¨ãªã‚ŠåŒå£«ã®ç¯„囲を入れ替ãˆã¾ã—ãŸãŒï¼Œé›¢ã‚Œã¦ã„ã‚‹å ´åˆã§ã‚‚åŒã˜ã‚ˆã†ãªã“ã¨ãŒã§ãã¾ã™ã€‚ã¾ãŸï¼Œã“ã®ä¾‹ã§ã¯ï¼Œæ¨ªã«ç§»å‹•ã—ã¾ã—ãŸãŒï¼ŒãŸã¦ã«ç§»å‹•ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚</p>



<figure class="wp-block-image size-large"><img src="https://saborepo.com/wp-content/uploads/2021/07/image20-1.png" alt="" class="wp-image-1427"/></figure>



<h2 class="wp-block-heading">ã¾ã¨ã‚</h2>



<p>本記事ã§ã¯ï¼Œ</p>



<ul class="is-style-st-no-border wp-block-list"><li>テンプレート</li><li>ショートカット</li><li>関数</li><li>オートフィル</li><li>貼り付ã‘オプション</li><li>セルã®å…¥ã‚Œæ›¿ãˆ</li></ul>



<p>ã¨ã„ã†ã‚¨ã‚¯ã‚»ãƒ«ã®æ™‚çŸæ©Ÿèƒ½ã‚’説明ã—ã¦ãã¾ã—ãŸã€‚</p>



<p>特ã«ï¼Œã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«æ©Ÿèƒ½ã¯ï¼ŒçŸ¥ã£ã¦ã„る人ã¨çŸ¥ã‚‰ãªã„人ã§å¤§ããªå·®ãŒã¤ã„ã¦ã—ã¾ã†ã¨ã“ã‚ã§ã™ã‹ã‚‰ï¼Œãœã²ã¨ã‚‚使ã„ã“ãªã—ã¦ã»ã—ã„ã¨ã“ã‚ã§ã™ã€‚
<!-- WP QUADS Content Ad Plugin v. 2.0.99 -->
<div class="quads-location quads-ad1" id="quads-ad1" style="float:none;margin:50px 0 50px 0;text-align:center;">

</div>


実験レポートに使えるエクセルの便利機能5選！
よく読まれている記事