【Excelのアレ】セルの色や罫線など書式だけをコピーする小ワザ

2016年06月17日 08:00:00
グルメ
ミトク

Excelでセルの背景色・文字色や罫線などをきちっと組んだ表を作った後、「別の表もこの書式で作りたい……」と思うのはよくある場面。こんな時、表の数式や値はコピーせずに、表の書式だけをコピーする方法を覚えておくと便利です！

※本記事では「Microsoft Office Excel 2016」を例にしております。

「書式のコピー／貼り付け」ボタンか「貼り付けのオプション」を活用しよう

▲まずは書式をコピーしたいセルを選択。次に「ホーム」タブの「書式のコピー/貼り付け」ボタンをクリックしましょう。

▲ポインタがペイントブラシに変わるので、書式を貼り付けたいセルをクリックします。

▲こんな感じで、セルの内容を省いて書式だけ別の表にコピーできました。

▲以上の手順が面倒な場合は、通常通りコピーしたいセルを選択して「Ctrl+C」。次にペーストしたいセルで右クリックし、メニューの「貼り付けのオプション」から「書式設定」を選択します。クリップボードに％のアイコンが目印です。

▲この方法でも同様に、書式のみを別のセルに貼り付けることが可能です。

【Excelのアレ】数式ではなく「計算結果の値だけをコピペ」する方法

【Excelのアレ】重複データのあるセルを検索して行ごと削除する方法

【Excelのアレ】（株）を株式会社に一括で揃える小ワザ

アクセスランキング

Tips

A PHP Error was encountered
Severity: Notice
Message: Undefined offset: 0
Filename: smarty/08d1cc69876d91563afb9c1f4d21cc8b7b96caa4_0.file.tips.tpl.php
Line Number: 41
Backtrace:
File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/08d1cc69876d91563afb9c1f4d21cc8b7b96caa4_0.file.tips.tpl.php
Line: 41
Function: _error_handler
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_resource_base.php
Line: 123
Function: content_66f26b3d14aa11_83151422
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_compiled.php
Line: 114
Function: getRenderedTemplateCode
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 217
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 386
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/d064ec4523cd2f49c67136b7b84705846d19c90b_0.file.side.tpl.php
Line: 43
Function: _subTemplateRender
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_resource_base.php
Line: 123
Function: content_66f26b47775ef5_14228348
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_compiled.php
Line: 114
Function: getRenderedTemplateCode
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 217
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 386
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/597cefa22c7600eaa32b117569a9685c70819274_0.file.show.tpl.php
Line: 417
Function: _subTemplateRender
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 248
Function: callBlock
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 184
Function: callBlock
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 186
Function: process
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 156
Function: process
File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/fbdaa42e51518f8881faeabdc1199f6dd175d1ce_0.file.base_index_layout.tpl.php
Line: 88
Function: instanceBlock
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_resource_base.php
Line: 123
Function: content_66f26b3cb92fa0_94546305
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_compiled.php
Line: 114
Function: getRenderedTemplateCode
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 217
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 386
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 116
Function: _subTemplateRender
File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/597cefa22c7600eaa32b117569a9685c70819274_0.file.show.tpl.php
Line: 71
Function: endChild
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_resource_base.php
Line: 123
Function: content_671b089d2e5dc3_21870328
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_compiled.php
Line: 114
Function: getRenderedTemplateCode
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 217
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_templatebase.php
Line: 238
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_templatebase.php
Line: 116
Function: _execute
File: /www/wwwroot/homev2.kingsoft.jp/application/libraries/SmartyLibrary.php
Line: 45
Function: fetch
File: /www/wwwroot/homev2.kingsoft.jp/application/controllers/ArticleController.php
Line: 32
Function: view
File: /www/wwwroot/homev2.kingsoft.jp/public/index.php
Line: 292
Function: require_once
A PHP Error was encountered
Severity: Notice
Message: Trying to access array offset on value of type null
Filename: smarty/49292b3df7e5bd60f7381ff16c5ca4532cf9476f_0.file.card.tpl.php
Line Number: 24
Backtrace:
File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/49292b3df7e5bd60f7381ff16c5ca4532cf9476f_0.file.card.tpl.php
Line: 24
Function: _error_handler
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_resource_base.php
Line: 123
Function: content_66f26b3d136f97_11902452
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_compiled.php
Line: 114
Function: getRenderedTemplateCode
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 384
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/08d1cc69876d91563afb9c1f4d21cc8b7b96caa4_0.file.tips.tpl.php
Line: 41
Function: _subTemplateRender
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_resource_base.php
Line: 123
Function: content_66f26b3d14aa11_83151422
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_compiled.php
Line: 114
Function: getRenderedTemplateCode
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 217
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 386
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/d064ec4523cd2f49c67136b7b84705846d19c90b_0.file.side.tpl.php
Line: 43
Function: _subTemplateRender
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_resource_base.php
Line: 123
Function: content_66f26b47775ef5_14228348
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_compiled.php
Line: 114
Function: getRenderedTemplateCode
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 217
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 386
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/597cefa22c7600eaa32b117569a9685c70819274_0.file.show.tpl.php
Line: 417
Function: _subTemplateRender
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 248
Function: callBlock
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 184
Function: callBlock
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 186
Function: process
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 156
Function: process
File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/fbdaa42e51518f8881faeabdc1199f6dd175d1ce_0.file.base_index_layout.tpl.php
Line: 88
Function: instanceBlock
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_resource_base.php
Line: 123
Function: content_66f26b3cb92fa0_94546305
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_compiled.php
Line: 114
Function: getRenderedTemplateCode
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 217
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 386
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 116
Function: _subTemplateRender
File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/597cefa22c7600eaa32b117569a9685c70819274_0.file.show.tpl.php
Line: 71
Function: endChild
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_resource_base.php
Line: 123
Function: content_671b089d2e5dc3_21870328
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_compiled.php
Line: 114
Function: getRenderedTemplateCode
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 217
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_templatebase.php
Line: 238
Function: render
File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_templatebase.php
Line: 116
Function: _execute
File: /www/wwwroot/homev2.kingsoft.jp/application/libraries/SmartyLibrary.php
Line: 45
Function: fetch
File: /www/wwwroot/homev2.kingsoft.jp/application/controllers/ArticleController.php
Line: 32
Function: view
File: /www/wwwroot/homev2.kingsoft.jp/public/index.php
Line: 292
Function: require_once

" class="text-decoration-none w-100" target="_blank">

A PHP Error was encountered

Severity: Notice

Message: Trying to access array offset on value of type null

Filename: smarty/49292b3df7e5bd60f7381ff16c5ca4532cf9476f_0.file.card.tpl.php

Line Number: 29

Backtrace:

File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/49292b3df7e5bd60f7381ff16c5ca4532cf9476f_0.file.card.tpl.php
Line: 29
Function: _error_handler

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_resource_base.php
Line: 123
Function: content_66f26b3d136f97_11902452

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_compiled.php
Line: 114
Function: getRenderedTemplateCode

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 384
Function: render

File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/08d1cc69876d91563afb9c1f4d21cc8b7b96caa4_0.file.tips.tpl.php
Line: 41
Function: _subTemplateRender

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_resource_base.php
Line: 123
Function: content_66f26b3d14aa11_83151422

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_compiled.php
Line: 114
Function: getRenderedTemplateCode

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 217
Function: render

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 386
Function: render

File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/d064ec4523cd2f49c67136b7b84705846d19c90b_0.file.side.tpl.php
Line: 43
Function: _subTemplateRender

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_resource_base.php
Line: 123
Function: content_66f26b47775ef5_14228348

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_compiled.php
Line: 114
Function: getRenderedTemplateCode

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 217
Function: render

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 386
Function: render

File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/597cefa22c7600eaa32b117569a9685c70819274_0.file.show.tpl.php
Line: 417
Function: _subTemplateRender

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 248
Function: callBlock

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 184
Function: callBlock

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 186
Function: process

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 156
Function: process

File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/fbdaa42e51518f8881faeabdc1199f6dd175d1ce_0.file.base_index_layout.tpl.php
Line: 88
Function: instanceBlock

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_resource_base.php
Line: 123
Function: content_66f26b3cb92fa0_94546305

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_compiled.php
Line: 114
Function: getRenderedTemplateCode

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 217
Function: render

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 386
Function: render

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
Line: 116
Function: _subTemplateRender

File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/597cefa22c7600eaa32b117569a9685c70819274_0.file.show.tpl.php
Line: 71
Function: endChild

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_resource_base.php
Line: 123
Function: content_671b089d2e5dc3_21870328

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_template_compiled.php
Line: 114
Function: getRenderedTemplateCode

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_template.php
Line: 217
Function: render

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_templatebase.php
Line: 238
Function: render

File: /www/wwwroot/homev2.kingsoft.jp/application/third_party/smarty/libs/sysplugins/smarty_internal_templatebase.php
Line: 116
Function: _execute

File: /www/wwwroot/homev2.kingsoft.jp/application/libraries/SmartyLibrary.php
Line: 45
Function: fetch

File: /www/wwwroot/homev2.kingsoft.jp/application/controllers/ArticleController.php
Line: 32
Function: view

File: /www/wwwroot/homev2.kingsoft.jp/public/index.php
Line: 292
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 1

Filename: smarty/08d1cc69876d91563afb9c1f4d21cc8b7b96caa4_0.file.tips.tpl.php

Line Number: 41

Backtrace:

File: /www/wwwroot/homev2.kingsoft.jp/application/cache/smarty/08d1cc69876d91563afb9c1f4d21cc8b7b96caa4_0.file.tips.tpl.php
Line: 41
Function: _error_handler