- 1、本文档共69页,可阅读全部内容。
- 2、原创力文档(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
Excel – Basic Training - Shclearn
Adding Fill Color Using Cell Styles To Create a New Cell Style Highlight the cell or cell range where you want to apply your style. Select the Cell Styles tool from the Home tab of the Ribbon to see the style gallery. Select New Cell Style to open the Style dialog box. Enter a name for the style in the Style Name field. Check the Style Includes boxes to indicate what formatting features the style should include. The options vary based on the active cell. Select Format to open the Format Cells dialog box. Use the Format Cells dialog box to indicate each formatting feature for the style. Select OK when you have finished indicating all of the formatting features for the style. The Number tab allows you to set number formatting for cells that contain values. The Alignment tab allows you to set text alignment for cells that contain text. The Font tab allows you to set the font for the style. The Border tab allows you to set customized borders for the style. The Fill tab allows you to set customized fill color for the style. The Protection tab allows you to protect the cells from changes if you use the Protection feature. Select OK to save your style and close the Style dialog box. The new style appears at the top of the Cell Style gallery. Using Conditional Formatting Highlight the cell or cell range where you want to use conditional formatting. Select the Conditional Formatting tool from the Home tab on the Ribbon. Select New Rule. Excel opens the New Formatting Rule dialog box. The options in this dialog box differ, based on the Rule Type you select. Select the Rule Type and follow the prompts to indicate the conditions for when to apply the formatting. Select Format to open the Format Cells dialog box to create the formatting to apply when the conditions are met. Select OK to save your rule and close the New Formatting Rule dialog box. Changing the Theme Module Twelve: Wrapping Up Words from the Wise Remember to spend some time planning your worksheet. Be cl
您可能关注的文档
- CRRT药物剂量.ppt
- crrt治疗剂量2015-6-5 图文.ppt
- C程序设计 05选择结构程序设计.ppt
- ct引导下肺穿刺活检术 课件.ppt
- c语言程序设计课件第5章 数组.ppt
- D-10电力变压器试验工作程序.doc
- DAV311 包装作业指导书.doc
- DAV316 包装作业指导书.doc
- CRTS2型双块式轨枕制造工艺.ppt
- d04 酒店效益管理提高酒店服务质量的可实行措施.pptx
- 第一单元 圆柱与圆锥-2023-2024学年六年级数学下学期期中专项复习(北师大版).docx
- (期中备考)第一单元-负数解决问题专项讲义.docx
- (期中备考)第三单元-圆柱与圆锥解决问题专项讲义.docx
- 牛津上海版七年级下英语Unit 2单元测试卷.doc
- 专题03:成语、俗语的运用 - 原卷版(统编版).docx
- (期中备考)第五单元-数学广角—鸽巢问题专项讲义.docx
- 专题01 字音字形(二考点六题型)60题(原卷版).docx
- 期中自测卷-道德与法治三年级下册统编版.docx
- 江苏省南京市建邺区小升初模拟卷(二)解析版.docx
- 危险化学品仓储设施安全标准化推进考核试卷.docx
最近下载
- GB_T 42900-2023 金属材料 高应变速率高温压缩试验方法.docx
- 中国抑郁障碍防治指南(第二版)简介PPT课件.pptx
- 心脏肿瘤讲课.pptx VIP
- 外研社版英语4年级上册单词表衡水体描红练字帖(三年级起点含音标和例句).pdf
- 电动自行车一线通、RS485、CAN2.0通信协议规范、基于RS485通信的充放电流程示例.pdf VIP
- 湖南省湖南师范大学附属中学2024-2025学年高二上学期入学考试数学试卷(解析版).docx VIP
- 四年级音乐 跳柴歌 课件.pptx
- 《复用医疗器械预处理操作规程》.pdf VIP
- 火灾自动报警及联动控制系统技术交底.docx VIP
- GB_T 43674-2024加氢站通用要求.docx VIP
文档评论(0)