官术网_书友最值得收藏!

Copying the format of one cell to another cell or range

This recipe shows you how to copy the formatting of one cell to another cell or range. For example, we can copy a yellow background and Calibri font from cell A1 to cell A2.

How to do it...

  1. Click on the source cell that you want to copy the formatting from.
  2. Click on the Format Painter icon, which you can find in the Clipboard section of the Home tab.
    How to do it...
  3. Click on the cell or range that you want to copy the source cell's formatting to.

How it works...

For SAP BusinessObjects Dashboards developers, it happens very often when they have to copy colored cells that represent different types of logic such as dynamic visibility cells, insertion cells, and so on.

The Format Painter tool works by taking the source cell that you have selected and applying the formatting to the cell(s) that you paint to. This is very useful because we can copy cell formats without having to perform a Copy and Paste Special action every time.

There's more...

An alternative to accomplishing the same task is to copy a cell and then click Paste Special... and choose the Formats option from Paste.

主站蜘蛛池模板: 饶河县| 沐川县| 元阳县| 湄潭县| 来宾市| 民县| 无极县| 商城县| 凌源市| 阿合奇县| 讷河市| 石台县| 上蔡县| 隆昌县| 玉屏| 朝阳市| 宣恩县| 抚顺县| 兰坪| 电白县| 二连浩特市| 长治县| 潍坊市| 桃园县| 莱西市| 乌兰察布市| 新民市| 龙门县| 卓资县| 惠水县| 永仁县| 青河县| 庆云县| 巴中市| 东阿县| 剑河县| 德州市| 安吉县| 漾濞| 万宁市| 阿城市|