tag:blogger.com,1999:blog-63551135684628845112024-03-26T16:11:52.942+09:00ima:BLOGFreeway,modo,Mac,iPhone.... 日々の貴重な情報を日記、備忘録として残しています。imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.comBlogger325125tag:blogger.com,1999:blog-6355113568462884511.post-85585621269492037832024-03-26T16:11:00.000+09:002024-03-26T16:11:15.308+09:00Outlook メールのフィルタリング<p> </p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhVoRQmxpRgEixKkzcKxV3oN6p1kzCEioDaYRH2DabB2C_ArVjQIS43Ib0t4EDjBg5hmQKZiX8RnjESBYxOLVHjJAmfwNMl8B2Y1dU8IaLSHABKRlEG6AsoGo1_iMLABJpKmaO00Bt3xNRbI2md0KgpSIrl-jmfszYxCQGjgNsxYZHOCEgh3p4Zn8rUm4V3" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="217" data-original-width="1896" height="74" src="https://blogger.googleusercontent.com/img/a/AVvXsEhVoRQmxpRgEixKkzcKxV3oN6p1kzCEioDaYRH2DabB2C_ArVjQIS43Ib0t4EDjBg5hmQKZiX8RnjESBYxOLVHjJAmfwNMl8B2Y1dU8IaLSHABKRlEG6AsoGo1_iMLABJpKmaO00Bt3xNRbI2md0KgpSIrl-jmfszYxCQGjgNsxYZHOCEgh3p4Zn8rUm4V3=w640-h74" width="640" /></a></div><br /><p></p>imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-71052409459142895802024-01-16T10:53:00.009+09:002024-02-05T18:31:33.881+09:00PDFファイルを翻訳<p>1.アクロバットから、Wordで書き出し。</p><p>2.Microsoft Office Wordで、翻訳するPDFファイルを開きます。</p><p>3.「校閲」から「翻訳」をクリックし、「範囲の翻訳」を選択すると、「翻訳ツール」が開きます。</p><p>4. 翻訳したい範囲を選択すると、翻訳ツールに訳された文章が表示されます</p>imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-35132074539334166932023-11-22T11:02:00.001+09:002023-11-22T11:02:04.632+09:00modo メニューバーが表示されない<p> </p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjcqUeq3SfNg8Enlm0BUy8bFWL20TBc3avydKZGE-zy6VrebatqC7lIHTqghxFEEVPGwsX8XCgSbz-kErjT5Be-W3K_poFiVYHhPdxlz2_SMN4-lo5yNXjnOwc5R_R8jJj-g_61EP5pFTifHhXWY21KLAB_sfFntg4Un5pGwobVxm0ksbFIL1Yn72v0RJPP" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="108" data-original-width="695" src="https://blogger.googleusercontent.com/img/a/AVvXsEjcqUeq3SfNg8Enlm0BUy8bFWL20TBc3avydKZGE-zy6VrebatqC7lIHTqghxFEEVPGwsX8XCgSbz-kErjT5Be-W3K_poFiVYHhPdxlz2_SMN4-lo5yNXjnOwc5R_R8jJj-g_61EP5pFTifHhXWY21KLAB_sfFntg4Un5pGwobVxm0ksbFIL1Yn72v0RJPP=s16000" /></a></div><br /><p></p>imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-71548927409452190722023-11-21T10:48:00.005+09:002023-11-21T10:48:52.876+09:00Exel 一番右の値を返す<p> =INDEX(E3:O3,MATCH(MAX(E3:O3)+1,E3:O3,1))</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEi5lwb5BamdJp-izJnNHJ2C75OuZTVj3NQTwCgQwUIwPwTXMzoqOidfL2sCzTUrFvZB57hXx0OVwd8lvckt0D9vaR5MBbsgxZmQWJUl8g_Ijz3ZkdzayIqlJVSTprkVhHAwSPBahN15cw7lT5D70ddhVzRYd4FVB3il4fWvzPoU_5cCOW1-48bQWnqMVZAO" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="301" data-original-width="759" height="254" src="https://blogger.googleusercontent.com/img/a/AVvXsEi5lwb5BamdJp-izJnNHJ2C75OuZTVj3NQTwCgQwUIwPwTXMzoqOidfL2sCzTUrFvZB57hXx0OVwd8lvckt0D9vaR5MBbsgxZmQWJUl8g_Ijz3ZkdzayIqlJVSTprkVhHAwSPBahN15cw7lT5D70ddhVzRYd4FVB3il4fWvzPoU_5cCOW1-48bQWnqMVZAO=w640-h254" width="640" /></a></div><br /><br /><p></p>imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-80996717064571735642023-11-19T21:23:00.002+09:002023-11-19T21:23:37.850+09:00Mac OS 新旧2つをインストールimahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-89715155655247940392023-10-12T11:31:00.006+09:002023-10-12T13:22:43.831+09:00Exel 数値に単位を付ける<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6-eKMBDP9SH1hx33720iCfzlrKbCDj0MQKj4aFXalKG_guc7aV-d6lBv3K6DyNmOUP8xc8DC1tsSVhBWs5TldCVS_Rbe-1di0ynmgzTUlkQFqfUYG7yewMO139iERbhnUdybqL5r9k3yA72_CY3Xjk0ityPrTDrcEA_RZHHlbYPIJ76ZPhIPFoTeOCJiN/s216/2023-10-12_11h22_54.png" style="display: block; padding: 1em 0px; text-align: left;"><img alt="" border="0" data-original-height="216" data-original-width="136" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6-eKMBDP9SH1hx33720iCfzlrKbCDj0MQKj4aFXalKG_guc7aV-d6lBv3K6DyNmOUP8xc8DC1tsSVhBWs5TldCVS_Rbe-1di0ynmgzTUlkQFqfUYG7yewMO139iERbhnUdybqL5r9k3yA72_CY3Xjk0ityPrTDrcEA_RZHHlbYPIJ76ZPhIPFoTeOCJiN/w126-h200/2023-10-12_11h22_54.png" width="126" /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6-eKMBDP9SH1hx33720iCfzlrKbCDj0MQKj4aFXalKG_guc7aV-d6lBv3K6DyNmOUP8xc8DC1tsSVhBWs5TldCVS_Rbe-1di0ynmgzTUlkQFqfUYG7yewMO139iERbhnUdybqL5r9k3yA72_CY3Xjk0ityPrTDrcEA_RZHHlbYPIJ76ZPhIPFoTeOCJiN/s216/2023-10-12_11h22_54.png" style="display: block; padding: 1em 0px; text-align: center;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6-eKMBDP9SH1hx33720iCfzlrKbCDj0MQKj4aFXalKG_guc7aV-d6lBv3K6DyNmOUP8xc8DC1tsSVhBWs5TldCVS_Rbe-1di0ynmgzTUlkQFqfUYG7yewMO139iERbhnUdybqL5r9k3yA72_CY3Xjk0ityPrTDrcEA_RZHHlbYPIJ76ZPhIPFoTeOCJiN/s216/2023-10-12_11h22_54.png" style="display: block; padding: 1em 0px;"><br /></a><span style="color: black;"><div style="text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6-eKMBDP9SH1hx33720iCfzlrKbCDj0MQKj4aFXalKG_guc7aV-d6lBv3K6DyNmOUP8xc8DC1tsSVhBWs5TldCVS_Rbe-1di0ynmgzTUlkQFqfUYG7yewMO139iERbhnUdybqL5r9k3yA72_CY3Xjk0ityPrTDrcEA_RZHHlbYPIJ76ZPhIPFoTeOCJiN/s216/2023-10-12_11h22_54.png" style="display: inline; padding: 1em 0px;"><span style="color: black;">セルの書式設定>ユーザー定義で</span></a></div><div style="text-align: left;"><div>#,###"坪"</div><div>"("#,###"㎡)"</div><div>を入力</div></div><div style="text-align: left;"><br /></div></span><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6-eKMBDP9SH1hx33720iCfzlrKbCDj0MQKj4aFXalKG_guc7aV-d6lBv3K6DyNmOUP8xc8DC1tsSVhBWs5TldCVS_Rbe-1di0ynmgzTUlkQFqfUYG7yewMO139iERbhnUdybqL5r9k3yA72_CY3Xjk0ityPrTDrcEA_RZHHlbYPIJ76ZPhIPFoTeOCJiN/s216/2023-10-12_11h22_54.png" style="display: block; padding: 1em 0px; text-align: left;"><br /></a></div>imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-15972773460280558732022-02-24T23:42:00.003+09:002022-05-16T13:53:24.469+09:00Outlookメール テキスト⇒HTMLへの変換<p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6He6MBgORxm_k0Colg-3CuJpSc4CtNkDf3cPEJ78LIB2LvGGwIyItKx0E4J0xMANQ14gQ04YK3XxOK8zrT8wky1IMsXd2X3u9BYkvM7tzU01qpP8wPQHvb1QZ8GxpcVu8_xh6DnRsbGhoZx4H6gX-nLnQ2JRtP1RxM6Ozocz8Wtr7qYYv88A5NVa4TQ/s2637/2022-05-16_13h45_51.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1534" data-original-width="2637" height="372" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6He6MBgORxm_k0Colg-3CuJpSc4CtNkDf3cPEJ78LIB2LvGGwIyItKx0E4J0xMANQ14gQ04YK3XxOK8zrT8wky1IMsXd2X3u9BYkvM7tzU01qpP8wPQHvb1QZ8GxpcVu8_xh6DnRsbGhoZx4H6gX-nLnQ2JRtP1RxM6Ozocz8Wtr7qYYv88A5NVa4TQ/w640-h372/2022-05-16_13h45_51.png" width="640" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6BCP3cb68ytxIGXanqYmvMMaYYsxxHbS1MURpaNPRi0SVX0XpPeNc-eOpa7MGUW-dcsl2nsIOW_1fhmDLBMFo2-tzl6EijPbRadNANBbm3EgPNtw0j2KatYEbZiDc2QwVV7HTv7PCQUkyce56tIPpx0MEeYdGYK-9S6tbT4_Lt5g-9xg8vSIIFyHX2A/s2250/2022-05-16_13h51_48.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1401" data-original-width="2250" height="398" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6BCP3cb68ytxIGXanqYmvMMaYYsxxHbS1MURpaNPRi0SVX0XpPeNc-eOpa7MGUW-dcsl2nsIOW_1fhmDLBMFo2-tzl6EijPbRadNANBbm3EgPNtw0j2KatYEbZiDc2QwVV7HTv7PCQUkyce56tIPpx0MEeYdGYK-9S6tbT4_Lt5g-9xg8vSIIFyHX2A/w640-h398/2022-05-16_13h51_48.png" width="640" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><br /> <p></p>imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-75642007890674262802022-01-14T13:25:00.006+09:002022-01-14T13:25:48.314+09:00outlookの設定(備忘録)<p> </p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiw-THiL_VSScK0Q05S728JZUPuidZru_1FaxItbtmhyKtyjnRA2v8ogBRhd99lTtaMBG93Q4O7MH_Gc7lDoW2PeJG34eab5t8CSrWD7tz250XK67F_upKU-1E3Xd53RIlDpn6T1sBmGZtRZ0W9irxbfk-T0C0SmPf_Oug_CfBQRdNsAXfgy0VqHK62UA=s947" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="676" data-original-width="947" height="456" src="https://blogger.googleusercontent.com/img/a/AVvXsEiw-THiL_VSScK0Q05S728JZUPuidZru_1FaxItbtmhyKtyjnRA2v8ogBRhd99lTtaMBG93Q4O7MH_Gc7lDoW2PeJG34eab5t8CSrWD7tz250XK67F_upKU-1E3Xd53RIlDpn6T1sBmGZtRZ0W9irxbfk-T0C0SmPf_Oug_CfBQRdNsAXfgy0VqHK62UA=w640-h456" width="640" /></a></div><br /><p></p>imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-90048750957243578662022-01-06T22:56:00.005+09:002022-02-24T12:16:10.754+09:00PDF 左右を別々のページで保存⇒JPG変換<p> ①見開き1ページの場合は、左右別々のページに分ける</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgi2NyOih-7sUCvBhGVJ8Y_VH0XOMr77CQ_f2XGpg0thRS1EQ-b9pvRzSEqjY37yXrEEVcbL4EMsE3Pmhe9YQ7RaMrlLVHIvX-s7fXNbP3pGhmVe4lhpRcRhQTn8XqLnSVginjQzFXdkRjV6OpUFIl8QwwpCS_5aFxa6Ruly-yZpKvp7n2AHnRDX5kdqQ=s1644" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1080" data-original-width="1644" height="420" src="https://blogger.googleusercontent.com/img/a/AVvXsEgi2NyOih-7sUCvBhGVJ8Y_VH0XOMr77CQ_f2XGpg0thRS1EQ-b9pvRzSEqjY37yXrEEVcbL4EMsE3Pmhe9YQ7RaMrlLVHIvX-s7fXNbP3pGhmVe4lhpRcRhQTn8XqLnSVginjQzFXdkRjV6OpUFIl8QwwpCS_5aFxa6Ruly-yZpKvp7n2AHnRDX5kdqQ=w640-h420" width="640" /></a></div><br /><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgXMtEfTaRER9DaW-8Kt8pqfsCx4HKfXQiaN-M212o9Ky8M9142BK8Kj7DrFWeSeMNanq62spBf4bKw6r1DdU2X4Ix_Ei05esHZgbJvEf5y4KcpMbIjrtUyQhO7JlB8CgCyWkCmYHCjbLBM-aVBA9AKe5DAiiTfxbd4EbvrM1Z5l_jhOpqU3Eb7pLkYMw=s1863" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1495" data-original-width="1863" height="514" src="https://blogger.googleusercontent.com/img/a/AVvXsEgXMtEfTaRER9DaW-8Kt8pqfsCx4HKfXQiaN-M212o9Ky8M9142BK8Kj7DrFWeSeMNanq62spBf4bKw6r1DdU2X4Ix_Ei05esHZgbJvEf5y4KcpMbIjrtUyQhO7JlB8CgCyWkCmYHCjbLBM-aVBA9AKe5DAiiTfxbd4EbvrM1Z5l_jhOpqU3Eb7pLkYMw=w640-h514" width="640" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><br />imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-47116562558444535932021-11-25T11:47:00.000+09:002021-11-25T11:47:00.923+09:00<p>acrobat Pro</p><p>認証エラー</p><p>編集>環境設定>セキュリティー(拡張)</p><p>でチェックを外す<span> *順番注意</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-LckTpBHRrmY/YZ75DMLjX0I/AAAAAAAAHlA/lstssma4h-cRsRl6BOiv0634huW4BXKWwCLcBGAsYHQ/s1152/2021-11-25_11h43_37.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="743" data-original-width="1152" height="412" src="https://1.bp.blogspot.com/-LckTpBHRrmY/YZ75DMLjX0I/AAAAAAAAHlA/lstssma4h-cRsRl6BOiv0634huW4BXKWwCLcBGAsYHQ/w640-h412/2021-11-25_11h43_37.png" width="640" /></a></div><br /><span><br /></span><p></p>imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-91376542049325373812021-07-08T15:06:00.003+09:002023-11-19T21:24:31.453+09:00<p> ①日付が空白の場合、<span style="background-color: #fcfdfe; color: #333333; font-family: "Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W3", Meiryo, メイリオ, Osaka, "MS PGothic", arial, helvetica, sans-serif; font-size: 13px;">99999999 ; 日付を自動で入力する</span></p><p><span style="background-color: #fcfdfe; color: #333333; font-family: "Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W3", Meiryo, メイリオ, Osaka, "MS PGothic", arial, helvetica, sans-serif; font-size: 13px;">Case ( IsEmpty ( 日付 ) ; 99999999 ; 日付 )</span></p>imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-22295511839743691312021-07-07T13:24:00.003+09:002021-07-07T13:26:06.030+09:00<p> PDFからExcelへの変換</p><p>Acrobatでツール>PDF書き出し>スプレットシート>Excel形式で書き出す</p><p>一つのセルの中で纏まってしまったら、セル内の文字を選択し(セルを選択ではない)</p><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-Fsh051k_U-A/YOUryANuXNI/AAAAAAAAHh4/_v1vWsK7HrEwSbQTynX2Rbo29WYWhEpzgCLcBGAsYHQ/s585/2021-07-07_13h20_08.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="520" data-original-width="585" height="284" src="https://1.bp.blogspot.com/-Fsh051k_U-A/YOUryANuXNI/AAAAAAAAHh4/_v1vWsK7HrEwSbQTynX2Rbo29WYWhEpzgCLcBGAsYHQ/w320-h284/2021-07-07_13h20_08.png" width="320" /></a></div><br /><p><br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-56w89xqJpHc/YOUr5rEGL4I/AAAAAAAAHh8/-Nse04icgjkPbKA9Eu2grgoe_MHuVfa0wCLcBGAsYHQ/s967/2021-07-07_13h20_37.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="967" data-original-width="847" height="320" src="https://1.bp.blogspot.com/-56w89xqJpHc/YOUr5rEGL4I/AAAAAAAAHh8/-Nse04icgjkPbKA9Eu2grgoe_MHuVfa0wCLcBGAsYHQ/s320/2021-07-07_13h20_37.png" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;">改行ごとに列が分かれる</div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-Ta80hQQKfWI/YOUr9hPTcQI/AAAAAAAAHiA/qHCv2RqJem4kW1IYk5FCtsOkbYFPE7C7ACLcBGAsYHQ/s899/2021-07-07_13h21_07.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="450" data-original-width="899" height="200" src="https://1.bp.blogspot.com/-Ta80hQQKfWI/YOUr9hPTcQI/AAAAAAAAHiA/qHCv2RqJem4kW1IYk5FCtsOkbYFPE7C7ACLcBGAsYHQ/w400-h200/2021-07-07_13h21_07.png" width="400" /></a></div><br />imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-80325292299708289812021-03-24T17:37:00.007+09:002021-03-24T17:37:49.202+09:00ファイルメーカー アクションボタンの作成<p> ①アクションを格納するフィールドを作成</p><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-aGfOzqbEyFw/YFr5ebawBnI/AAAAAAAAHdg/lvFPAT1IRxMNZPk15O5f-Z5x3TM3rH-XgCLcBGAsYHQ/s755/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="755" data-original-width="669" height="640" src="https://1.bp.blogspot.com/-aGfOzqbEyFw/YFr5ebawBnI/AAAAAAAAHdg/lvFPAT1IRxMNZPk15O5f-Z5x3TM3rH-XgCLcBGAsYHQ/w568-h640/1.png" width="568" /></a></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">②アクションの値一覧を作成</div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-QxTh4sxfhQk/YFr5h2dTvNI/AAAAAAAAHdk/Yk97h8GgUL4qktEpucG4PNFCGCWWArAsQCLcBGAsYHQ/s779/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="530" data-original-width="779" height="436" src="https://1.bp.blogspot.com/-QxTh4sxfhQk/YFr5h2dTvNI/AAAAAAAAHdk/Yk97h8GgUL4qktEpucG4PNFCGCWWArAsQCLcBGAsYHQ/w640-h436/2.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">③アクションごとのスクリプトを作成</div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-QLPrMYGhl1c/YFr5ktAPduI/AAAAAAAAHdo/rgbtsOxhupM0dTpqa9ueqmUwf3mSjtuEACLcBGAsYHQ/s989/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="719" data-original-width="989" height="466" src="https://1.bp.blogspot.com/-QLPrMYGhl1c/YFr5ktAPduI/AAAAAAAAHdo/rgbtsOxhupM0dTpqa9ueqmUwf3mSjtuEACLcBGAsYHQ/w640-h466/3.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">④アクションボタンにフィールドと値一覧を指定</div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-SqTZhuu68Qs/YFr5n8pyWiI/AAAAAAAAHds/0G4OTUZaMFgYM3xBJkzqfFFqILve4GDWwCLcBGAsYHQ/s689/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="689" height="476" src="https://1.bp.blogspot.com/-SqTZhuu68Qs/YFr5n8pyWiI/AAAAAAAAHds/0G4OTUZaMFgYM3xBJkzqfFFqILve4GDWwCLcBGAsYHQ/w640-h476/4.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">⑤スクリプトトリガーを指定</div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-rFX9Nwluho4/YFr5qsYH2PI/AAAAAAAAHdw/Ul80ugnwETEF9SNRnPmiug_n10Dht0LSACLcBGAsYHQ/s764/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="764" data-original-width="678" height="640" src="https://1.bp.blogspot.com/-rFX9Nwluho4/YFr5qsYH2PI/AAAAAAAAHdw/Ul80ugnwETEF9SNRnPmiug_n10Dht0LSACLcBGAsYHQ/w568-h640/5.png" width="568" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><p></p>imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-58817390034681531062021-03-23T11:11:00.000+09:002021-03-23T11:13:00.678+09:00ファイルメーカー WEBからコピーしたフォントをリセット<p> <span style="background-color: white; color: #333333; font-family: Helvetica, Helvetica, Arial, sans-serif; font-size: 16px;">計算値自動入力で、TextFormatRemove ( Self ) という計算式を書式を取り除く関数を入力する</span></p><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-hHt_ty3Mh7g/YFlOGg2SpmI/AAAAAAAAHdA/L9XH3hagMJgOFwt8jwoK42eovxMeM9_oACLcBGAsYHQ/s2048/2021-03-23_11h08_33.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="1336" data-original-width="2048" height="418" src="https://1.bp.blogspot.com/-hHt_ty3Mh7g/YFlOGg2SpmI/AAAAAAAAHdA/L9XH3hagMJgOFwt8jwoK42eovxMeM9_oACLcBGAsYHQ/w640-h418/2021-03-23_11h08_33.png" width="640" /></a></div><br />imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-72661622798815603822020-03-17T11:13:00.005+09:002020-03-17T11:13:38.187+09:00重複した写真を削除してくれるアプリhotos Duplicate Cleaner<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-x5T0JO56PvU/XnAyJ1HFLvI/AAAAAAAAHUc/WIqBzg90FD003fcFFaqjrOTMNzKlJ7kdQCLcBGAsYHQ/s1600/Photos-Duplicate-Cleaner.webp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="193" data-original-width="223" src="https://1.bp.blogspot.com/-x5T0JO56PvU/XnAyJ1HFLvI/AAAAAAAAHUc/WIqBzg90FD003fcFFaqjrOTMNzKlJ7kdQCLcBGAsYHQ/s1600/Photos-Duplicate-Cleaner.webp" /></a></div>
<br />imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-30471090578730565792020-03-17T11:05:00.002+09:002021-06-10T19:45:24.937+09:00Exifの撮影日時で、一括リネームShupapan<br />
<a href="https://www.vector.co.jp/soft/mac/util/se496881.html">https://www.vector.co.jp/soft/mac/util/se496881.html</a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-OQVQc-fXd5A/XqYdlbjTzyI/AAAAAAAAHWE/4fVQmgacfJoksBvZ-p1oWl3XZRfkzYAaACLcBGAsYHQ/s1600/images.jpeg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="122" data-original-width="150" height="161" src="https://1.bp.blogspot.com/-OQVQc-fXd5A/XqYdlbjTzyI/AAAAAAAAHWE/4fVQmgacfJoksBvZ-p1oWl3XZRfkzYAaACLcBGAsYHQ/s200/images.jpeg" width="200" /></a></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-aPuD8m831JQ/YMHtMKjF2QI/AAAAAAAAHgU/PCgDPmJbngwgj4FcDQBxOrWY1sZGPmGCQCLcBGAsYHQ/s1090/ima_BLOG__Exif%25E3%2581%25AE%25E6%2592%25AE%25E5%25BD%25B1%25E6%2597%25A5%25E6%2599%2582%25E3%2581%25A6%25E3%2582%2599%25E3%2580%2581%25E4%25B8%2580%25E6%258B%25AC%25E3%2583%25AA%25E3%2583%258D%25E3%2583%25BC%25E3%2583%25A0.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="743" data-original-width="1090" height="436" src="https://1.bp.blogspot.com/-aPuD8m831JQ/YMHtMKjF2QI/AAAAAAAAHgU/PCgDPmJbngwgj4FcDQBxOrWY1sZGPmGCQCLcBGAsYHQ/w640-h436/ima_BLOG__Exif%25E3%2581%25AE%25E6%2592%25AE%25E5%25BD%25B1%25E6%2597%25A5%25E6%2599%2582%25E3%2581%25A6%25E3%2582%2599%25E3%2580%2581%25E4%25B8%2580%25E6%258B%25AC%25E3%2583%25AA%25E3%2583%258D%25E3%2583%25BC%25E3%2583%25A0.png" width="640" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<br />
<br />
<a href="https://exiftool.org/">ExifTool by Phil Harvey</a><br />
<br />
1.をダウンロードして、インストールし<br />
2.「アプリケーション/ユーティリティ」から、「ターミナル」を起動する。<br />
*ターミナルウインドウにファイルをドラッグ&ドロップすると、そのファイルパスが自動で入力されます。<div class="separator" style="clear: both; text-align: center;"><br /></div><br />imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-25014390781492928052020-01-04T00:35:00.004+09:002020-01-04T00:38:28.360+09:00VIDEO_TSフォルダDVDを作成する方法Ripltでリッピングし、VIDEO_TSフォルダを作成する<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://1.bp.blogspot.com/-AdliH5NBkCQ/Xg9e9fdJMlI/AAAAAAAAHTA/GeLy9btlbwg1xS-T6edkhmovQBq28xGTgCLcBGAsYHQ/s1600/Insert_DVD_%25E3%2581%25A8_Blogger__ima_BLOG_-_%25E6%258A%2595%25E7%25A8%25BF%25E3%2582%2592%25E4%25BD%259C%25E6%2588%2590_%25E3%2581%25A8_Wondershare_%25E3%2582%25B9%25E3%2583%25BC%25E3%2583%258F%25E3%2582%259A%25E3%2583%25BC%25E3%2583%25A1%25E3%2583%2586%25E3%2582%2599%25E3%2582%25A3%25E3%2582%25A2%25E5%25A4%2589%25E6%258F%259B%25EF%25BC%2581.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="365" data-original-width="319" height="320" src="https://1.bp.blogspot.com/-AdliH5NBkCQ/Xg9e9fdJMlI/AAAAAAAAHTA/GeLy9btlbwg1xS-T6edkhmovQBq28xGTgCLcBGAsYHQ/s320/Insert_DVD_%25E3%2581%25A8_Blogger__ima_BLOG_-_%25E6%258A%2595%25E7%25A8%25BF%25E3%2582%2592%25E4%25BD%259C%25E6%2588%2590_%25E3%2581%25A8_Wondershare_%25E3%2582%25B9%25E3%2583%25BC%25E3%2583%258F%25E3%2582%259A%25E3%2583%25BC%25E3%2583%25A1%25E3%2583%2586%25E3%2582%2599%25E3%2582%25A3%25E3%2582%25A2%25E5%25A4%2589%25E6%258F%259B%25EF%25BC%2581.png" width="279" /></a></div>
<br />
WonderShareスパーメディア変換!でVIDEO_TSフォルダ内のデータをドラッグし<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://1.bp.blogspot.com/-5_OZPpOUnzs/Xg9ftm8fJAI/AAAAAAAAHTI/V3gBsVKC_AobKYCgYK7YEJ-1tMSjKpsjQCLcBGAsYHQ/s1600/Wondershare_%25E3%2582%25B9%25E3%2583%25BC%25E3%2583%258F%25E3%2582%259A%25E3%2583%25BC%25E3%2583%25A1%25E3%2583%2586%25E3%2582%2599%25E3%2582%25A3%25E3%2582%25A2%25E5%25A4%2589%25E6%258F%259B%25EF%25BC%2581.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="887" data-original-width="1466" height="386" src="https://1.bp.blogspot.com/-5_OZPpOUnzs/Xg9ftm8fJAI/AAAAAAAAHTI/V3gBsVKC_AobKYCgYK7YEJ-1tMSjKpsjQCLcBGAsYHQ/s640/Wondershare_%25E3%2582%25B9%25E3%2583%25BC%25E3%2583%258F%25E3%2582%259A%25E3%2583%25BC%25E3%2583%25A1%25E3%2583%2586%25E3%2582%2599%25E3%2582%25A3%25E3%2582%25A2%25E5%25A4%2589%25E6%258F%259B%25EF%25BC%2581.png" width="640" /></a></div>
<br />
画像品質を調整して、実行する<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://1.bp.blogspot.com/-cfxsvyHCGjc/Xg9f6ikY34I/AAAAAAAAHTM/Dzs1ZYrce-k5ai1_8OuDuRyuJuV618fiwCLcBGAsYHQ/s1600/Wondershare_%25E3%2582%25B9%25E3%2583%25BC%25E3%2583%258F%25E3%2582%259A%25E3%2583%25BC%25E3%2583%25A1%25E3%2583%2586%25E3%2582%2599%25E3%2582%25A3%25E3%2582%25A2%25E5%25A4%2589%25E6%258F%259B%25EF%25BC%2581%2B2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1001" data-original-width="1524" height="420" src="https://1.bp.blogspot.com/-cfxsvyHCGjc/Xg9f6ikY34I/AAAAAAAAHTM/Dzs1ZYrce-k5ai1_8OuDuRyuJuV618fiwCLcBGAsYHQ/s640/Wondershare_%25E3%2582%25B9%25E3%2583%25BC%25E3%2583%258F%25E3%2582%259A%25E3%2583%25BC%25E3%2583%25A1%25E3%2583%2586%25E3%2582%2599%25E3%2582%25A3%25E3%2582%25A2%25E5%25A4%2589%25E6%258F%259B%25EF%25BC%2581%2B2.png" width="640" /></a></div>
<br />imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-76538415096602555442019-12-26T00:58:00.003+09:002023-11-19T21:24:49.281+09:00Macで年賀状印刷おまかせ宛名はがきを立ち上げる<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-mv3Aw7Ft3Hw/XgOG1hvI2iI/AAAAAAAAHSQ/5UeXtAiu-gYugXzC-1MvZOq-NcSmMdXfgCLcBGAsYHQ/s1600/%25E3%2582%25B9%25E3%2582%25AF%25E3%2583%25AA%25E3%2583%25BC%25E3%2583%25B3%25E3%2582%25B7%25E3%2583%25A7%25E3%2583%2583%25E3%2583%2588_2019_12_26_0_53-2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="161" data-original-width="309" height="166" src="https://1.bp.blogspot.com/-mv3Aw7Ft3Hw/XgOG1hvI2iI/AAAAAAAAHSQ/5UeXtAiu-gYugXzC-1MvZOq-NcSmMdXfgCLcBGAsYHQ/s320/%25E3%2582%25B9%25E3%2582%25AF%25E3%2583%25AA%25E3%2583%25BC%25E3%2583%25B3%25E3%2582%25B7%25E3%2583%25A7%25E3%2583%2583%25E3%2583%2588_2019_12_26_0_53-2.png" width="320" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
連絡帳は私で、icloudは妻のアドレス帳が表示される。グループを作成して、年賀状を送るグルーピングを行う<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-s76y5VB9JW0/XgOHLke4FII/AAAAAAAAHSY/RvWjwV80EyQzvHlM2bvykr63sG5d9IFjgCLcBGAsYHQ/s1600/%25E3%2582%25B9%25E3%2582%25AF%25E3%2583%25AA%25E3%2583%25BC%25E3%2583%25B3%25E3%2582%25B7%25E3%2583%25A7%25E3%2583%2583%25E3%2583%2588_2019_12_26_0_54.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="1113" data-original-width="1554" height="458" src="https://1.bp.blogspot.com/-s76y5VB9JW0/XgOHLke4FII/AAAAAAAAHSY/RvWjwV80EyQzvHlM2bvykr63sG5d9IFjgCLcBGAsYHQ/s640/%25E3%2582%25B9%25E3%2582%25AF%25E3%2583%25AA%25E3%2583%25BC%25E3%2583%25B3%25E3%2582%25B7%25E3%2583%25A7%25E3%2583%2583%25E3%2583%2588_2019_12_26_0_54.png" width="640" /></a></div>
<br />imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-76053567611727039292019-12-25T22:28:00.002+09:002019-12-25T22:28:29.115+09:00年賀状の印刷設定<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-KB-vfOum_j4/XgNjqsrBuEI/AAAAAAAAHRs/PUOG2IBhq0Y4ZEcDH_PL0bUQ3rCJpUNVgCLcBGAsYHQ/s1600/1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="499" data-original-width="749" height="425" src="https://1.bp.blogspot.com/-KB-vfOum_j4/XgNjqsrBuEI/AAAAAAAAHRs/PUOG2IBhq0Y4ZEcDH_PL0bUQ3rCJpUNVgCLcBGAsYHQ/s640/1.png" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-eoaSZKfd-0A/XgNjwjr3OvI/AAAAAAAAHRw/XAiWAVxnZEUs8ehXp8RSjC--ltzSdSQ2ACLcBGAsYHQ/s1600/2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="503" data-original-width="769" height="418" src="https://1.bp.blogspot.com/-eoaSZKfd-0A/XgNjwjr3OvI/AAAAAAAAHRw/XAiWAVxnZEUs8ehXp8RSjC--ltzSdSQ2ACLcBGAsYHQ/s640/2.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-zzakqWKNUnI/XgNj1jZhq7I/AAAAAAAAHR0/FF85sLzG5YA_L5tMQoSLelAOq1z1KHEzwCLcBGAsYHQ/s1600/3.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="582" data-original-width="770" height="482" src="https://1.bp.blogspot.com/-zzakqWKNUnI/XgNj1jZhq7I/AAAAAAAAHR0/FF85sLzG5YA_L5tMQoSLelAOq1z1KHEzwCLcBGAsYHQ/s640/3.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-UZo6I5NcS5k/XgNj7R27XsI/AAAAAAAAHR8/zJk7c9FrNTQTgM_MvFDVOn5Cic_8xz5qgCLcBGAsYHQ/s1600/4.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="412" data-original-width="772" height="340" src="https://1.bp.blogspot.com/-UZo6I5NcS5k/XgNj7R27XsI/AAAAAAAAHR8/zJk7c9FrNTQTgM_MvFDVOn5Cic_8xz5qgCLcBGAsYHQ/s640/4.png" width="640" /></a></div>
<br />imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-73980386852379911002018-09-07T10:29:00.000+09:002018-09-07T10:29:13.065+09:00アクロバット テキストBOXのフォントサイズ変更control+Eでプロパティーを表示<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-7FhVsgsjZEI/W5HUUhbh1dI/AAAAAAAAHOg/eVLSyaj6KIcrhp4jnee2WUTmagVc5owNACLcBGAs/s1600/2018-09-07_10h28_36.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="64" data-original-width="671" height="60" src="https://4.bp.blogspot.com/-7FhVsgsjZEI/W5HUUhbh1dI/AAAAAAAAHOg/eVLSyaj6KIcrhp4jnee2WUTmagVc5owNACLcBGAs/s640/2018-09-07_10h28_36.png" width="640" /></a></div>
imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-33799280421311921482017-03-17T22:15:00.000+09:002017-03-17T22:15:25.834+09:00EXEL 画像を読み込みすぎて重くなったファイルを軽くする画像を選択し、書式>画像の圧縮を実行する<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-Kns9PvIzt0s/WMvhLcGaC4I/AAAAAAAAHMg/nZTdyQlZC5UFxfWz9n_PdeT34utyVPlzQCEw/s1600/2017-03-17_22h12_55.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="306" src="https://3.bp.blogspot.com/-Kns9PvIzt0s/WMvhLcGaC4I/AAAAAAAAHMg/nZTdyQlZC5UFxfWz9n_PdeT34utyVPlzQCEw/s640/2017-03-17_22h12_55.png" width="640" /></a></div>
<br />imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-40997347501342482072016-10-05T19:46:00.001+09:002016-10-05T19:46:04.659+09:00エクセル 全角⇒半角に変換する方法<div class="operation" style="background-color: white; color: #222222; font-family: Meiryo, arial, helvetica, clean, sans-serif; font-size: 14.08px; font-weight: bold; margin-left: 14px;">
▼操作概要:カタカナは全角のまま英数文字だけ半角に変換する<br /><div class="small" style="font-size: 11.5456px;">
※A2セルに入力されているデータをB2:C2セルを作業用に使いながら、カタカナは全角・英数文字は半角にしてD2セルに表示する例</div>
<br />B2セルに「=ASC(A2)」という数式を入力<br /> ↓<br />B2セルをコピーしてC2セルに値のみ貼り付け<br /> ↓<br />D2セルに「=PHONETIC(C2)」という数式を入力</div>
<div style="background-color: white; color: #222222; font-family: Meiryo, arial, helvetica, clean, sans-serif; margin-bottom: 1em; margin-top: 1em;">
</div>
<div style="background-color: white; color: #222222; font-family: Meiryo, arial, helvetica, clean, sans-serif; margin-bottom: 1em; margin-top: 1em;">
上記の操作を行えばD2セルにはカタカナは全角のまま英数文字だけ半角のデータが表示されます。</div>
imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-31777761424488831842016-07-14T17:01:00.000+09:002016-07-14T17:01:07.502+09:00Exel 2つのファイルの相違を見つける<span style="background-color: white; color: #333333; font-family: "lucida grande" , "hiragino kaku gothic pron" , "ヒラギノ角ゴ pron w3" , "meiryo" , , sans-serif; font-size: 15.4px; line-height: 21.56px;">新規ブック newbook.xls のセル A1 に式 =[ファイルB.xls]Sheet1!A1=[ファイルB.xls]Sheet1!A1 を入力します。</span><br />
<span style="background-color: white; color: #333333; font-family: "lucida grande" , "hiragino kaku gothic pron" , "ヒラギノ角ゴ pron w3" , "meiryo" , , sans-serif; font-size: 15.4px; line-height: 21.56px;"><br /></span>
<span style="background-color: white; color: #333333; font-family: "lucida grande" , "hiragino kaku gothic pron" , "ヒラギノ角ゴ pron w3" , "meiryo" , , sans-serif; font-size: 15.4px; line-height: 21.56px;">このセルに次の[条件付き書式]を設定します。</span><br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://1.bp.blogspot.com/-fWm6rkCTKIM/V4dGPFpxQzI/AAAAAAAAHKw/YrQrpyBeO8oGoz-ai7ZUtZg1WrGzwMAagCLcB/s1600/20160714_164002.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://1.bp.blogspot.com/-fWm6rkCTKIM/V4dGPFpxQzI/AAAAAAAAHKw/YrQrpyBeO8oGoz-ai7ZUtZg1WrGzwMAagCLcB/s400/20160714_164002.jpeg" width="352" /></a></div>
<span style="background-color: white; color: #333333; font-family: "lucida grande" , "hiragino kaku gothic pron" , "ヒラギノ角ゴ pron w3" , "meiryo" , , sans-serif; font-size: 15.4px; line-height: 21.56px;"><br /></span>
<span style="background-color: white; color: #333333; font-family: "lucida grande" , "hiragino kaku gothic pron" , "ヒラギノ角ゴ pron w3" , "meiryo" , , sans-serif; font-size: 15.4px; line-height: 21.56px;"><br /></span>
<br style="background-color: white; color: #333333; font-family: "Lucida Grande", "Hiragino Kaku Gothic ProN", "ヒラギノ角ゴ ProN W3", Meiryo, メイリオ, sans-serif; font-size: 15.4px; line-height: 21.56px;" />
<span style="background-color: white; color: #333333; font-family: "lucida grande" , "hiragino kaku gothic pron" , "ヒラギノ角ゴ pron w3" , "meiryo" , , sans-serif; font-size: 15.4px; line-height: 21.56px;">“セルの値が” “次の値に等しい” “FALSE”</span><span style="background-color: white; color: #333333; font-size: 15.4px; line-height: 21.56px;">書式: パターン色を赤</span><br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://3.bp.blogspot.com/-XgkErEpInis/V4dGYW-fxCI/AAAAAAAAHK0/v68FdPJOOAwvX8tUe5MlUqPAPhSCiPnswCLcB/s1600/2016-07-14_16h41_10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="263" src="https://3.bp.blogspot.com/-XgkErEpInis/V4dGYW-fxCI/AAAAAAAAHK0/v68FdPJOOAwvX8tUe5MlUqPAPhSCiPnswCLcB/s400/2016-07-14_16h41_10.png" width="400" /></a></div>
<span style="background-color: white; color: #333333; font-size: 15.4px; line-height: 21.56px;"><br /></span>
<span style="background-color: white; color: #333333; font-size: 15.4px; line-height: 21.56px;">そのセルをコピーして広げます</span><br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://1.bp.blogspot.com/-Cdf4mutsZgY/V4dGp_gtzJI/AAAAAAAAHK4/LxtcKbSKvTwp0gNQQs1jsK5IZdvmYHBdgCLcB/s1600/2016-07-14_16h54_05.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="484" src="https://1.bp.blogspot.com/-Cdf4mutsZgY/V4dGp_gtzJI/AAAAAAAAHK4/LxtcKbSKvTwp0gNQQs1jsK5IZdvmYHBdgCLcB/s640/2016-07-14_16h54_05.png" width="640" /></a></div>
<span style="background-color: white; color: #333333; font-size: 15.4px; line-height: 21.56px;"><br /></span>
<span style="background-color: white; color: #333333; font-size: 15.4px; line-height: 21.56px;"><br /></span>
<span style="background-color: white; color: #333333; font-size: 15.4px; line-height: 21.56px;"><br /></span>imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-6131718617867615872016-03-14T22:13:00.002+09:002016-03-14T22:15:11.720+09:00VectorWorks 初期設定<div class="separator" style="clear: both; text-align: left;">
<a href="https://2.bp.blogspot.com/-mggbpzrs3CY/Vua45f6tOZI/AAAAAAAAHJg/m8KhPIIj0MA8_2KVYs4CXIiO8MwM_5Pkw/s1600/2016-03-14_22h12_05.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="288" src="https://2.bp.blogspot.com/-mggbpzrs3CY/Vua45f6tOZI/AAAAAAAAHJg/m8KhPIIj0MA8_2KVYs4CXIiO8MwM_5Pkw/s640/2016-03-14_22h12_05.png" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://4.bp.blogspot.com/-s63prGkNTg4/Vua5WIb2stI/AAAAAAAAHJk/uc7z6ojNpWsfE5AMgKSaMTGMs4fwsQy9A/s1600/2016-03-14_22h14_26.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="264" src="https://4.bp.blogspot.com/-s63prGkNTg4/Vua5WIb2stI/AAAAAAAAHJk/uc7z6ojNpWsfE5AMgKSaMTGMs4fwsQy9A/s640/2016-03-14_22h14_26.png" width="640" /></a></div>
<br />imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0tag:blogger.com,1999:blog-6355113568462884511.post-24914079493946908942016-03-07T09:28:00.002+09:002016-04-11T20:40:03.168+09:00Exel 端数の切り捨て<div class="separator" style="clear: both; text-align: left;">
数式は=ROUNDUP(SUM(AB4/AG4),-2)</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="https://1.bp.blogspot.com/-CQ-QhQOnpvI/VtzLHcC43-I/AAAAAAAAHJM/pL5rhmDllxw/s1600/%25E3%2582%25B9%25E3%2582%25AF%25E3%2583%25AA%25E3%2583%25BC%25E3%2583%25B3%25E3%2582%25B7%25E3%2583%25A7%25E3%2583%2583%25E3%2583%2588_022416_091016_PM.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="440" src="https://1.bp.blogspot.com/-CQ-QhQOnpvI/VtzLHcC43-I/AAAAAAAAHJM/pL5rhmDllxw/s640/%25E3%2582%25B9%25E3%2582%25AF%25E3%2583%25AA%25E3%2583%25BC%25E3%2583%25B3%25E3%2582%25B7%25E3%2583%25A7%25E3%2583%2583%25E3%2583%2588_022416_091016_PM.jpg" width="640" /></a></div>
<br />imahttp://www.blogger.com/profile/14570461736884471926noreply@blogger.com0