- .NET 4.0 Generics
- David Lai Xavier Hacking
- 200字
- 2021-04-02 19:30:09
Copying the formatting 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...
- Click on the source cell that you want to copy the formatting from.
- Click on the Format Painter icon which you can find on the Clipboard section of the Home tab.
- Click on the cell or range that you want to copy the source cell's formatting to.
How it works...
The Format Painter 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 every time.
For Dashboard Design developers, it happens very often where we have to copy colored cells that represent different types of logic such as dynamic visibility cells, insertion cells, and so on.
There's more...
An alternative to accomplishing the same task is to copy a cell and then click Paste Special... and choose to Paste Formats only.
推薦閱讀
- Excel函數(shù)、公式、圖表、數(shù)據(jù)處理從新手到高手
- Vulkan學(xué)習(xí)指南
- Word-Excel-PowerPoint 2010三合一從新手到高手（超值版）
- Maya影視動(dòng)畫高級(jí)模型制作全解析
- ERP沙盤模擬簡(jiǎn)明教程
- Learning VirtualDub: The complete guide to capturing, processing and encoding digital video
- Maya 2019三維動(dòng)畫基礎(chǔ)案例教程
- CakePHP 1.3 Application Development Cookbook
- ANSYS Workbench中文版超級(jí)學(xué)習(xí)手冊(cè)
- Photoshop CC完全自學(xué)教程：從入門到實(shí)踐（全新版）
- 中文版3ds Max 2014-VRay效果圖制作完全自學(xué)教程
- 中文版Maya 2016基礎(chǔ)培訓(xùn)教程
- Revit建模進(jìn)階標(biāo)準(zhǔn)教程（實(shí)戰(zhàn)微課版）
- 攝影師的后期必修課（RAW格式篇）
- Deep Inside osCommerce: The Cookbook