- .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.
推薦閱讀
- Adobe創(chuàng)意大學After Effects CS5 產品專家認證標準教材
- AI繪畫教程：Midjourney關鍵詞靈感手冊
- AutoCAD 2019中文版從入門到精通
- 中文版Illustrator 2021完全自學教程
- Oracle SQL Developer 2.1
- 中文版Illustrator CC基礎培訓教程（移動學習版）
- 中文版3ds Max 2021完全自學教程
- Blender 2.5 Materials and Textures Cookbook
- SolidWorks2016中文版從入門到精通/CAX工程應用叢書
- Premiere Pro短視頻剪輯零基礎一本通
- 中文版3ds Max 2022基礎教程
- 從零開始：Indesign CC 2019設計基礎+商業(yè)設計實戰(zhàn)
- 剪映真?zhèn)鳎?8招玩轉短視頻剪輯
- Quality Assurance for Dynamics AX-Based ERP Solutions
- Revit建模進階標準教程（實戰(zhàn)微課版）