您现在的位置是:首页 > 办公软件 > excleexcle
EXCEL 利用条件格式修饰排序后数据
爱读书aread.cc2022-10-02 22:28:01excle0人已围观
简介爱读书aread.cc翻译,转载请保留此信息 . 1. Sort the List by Customer Name by selecting a cell in column C and clicking the Sort icon.(按客户排序)
2. Select cell A1 in the Current Region and press Ctrl+S
爱读书aread.cc翻译,转载请保留此信息 .
1. Sort the List by Customer Name by selecting a cell in column C and clicking the Sort icon.(按客户排序)
2. Select cell A1 in the Current Region and press Ctrl+Shift+*(按ctrl+shift+*选择排序后区域)
3. From the Format menu, select Conditional Formatting.(选格式-条件格式)
4. In Condition 1, select Formula Is.
5. In the Formula box, enter the formula =$C1$C2. Be sure to enter the formula with absolute reference for the column and relative reference for the row.(输入公式=$C1$C2,注意绝对引用及相对引用)
6. In the Conditional Formatting dialog box, click the Format button, select the Border tab, in Border section click Underline and then choose a color.(在条件格式中的格式对话框,选择边框中的下边框及颜色)
7. Click OK twice.(按确定)
2. Select cell A1 in the Current Region and press Ctrl+Shift+*(按ctrl+shift+*选择排序后区域)
3. From the Format menu, select Conditional Formatting.(选格式-条件格式)
4. In Condition 1, select Formula Is.
5. In the Formula box, enter the formula =$C1$C2. Be sure to enter the formula with absolute reference for the column and relative reference for the row.(输入公式=$C1$C2,注意绝对引用及相对引用)
6. In the Conditional Formatting dialog box, click the Format button, select the Border tab, in Border section click Underline and then choose a color.(在条件格式中的格式对话框,选择边框中的下边框及颜色)
7. Click OK twice.(按确定)
Tags:
很赞哦! ()
下一篇:EXCEL 自定义排序方式
相关文章
随机图文
-
excel折线图_excel生成折线图
Excel-折线图 excel使我们工人的数据统计神器,但有些时候我们还会遇到诸如柱状图、折线 -
excel快速切换工作表_excel表格间切换
Excel-工作表操作 excel的工作表是工作簿的直接操作界面,excel工作簿中包含工作表,一个工 -
EXCEL 在页眉或页角中插入图片
爱读书aread.cc翻译,转载请保留此信息 . 1. From the File menu, select Page Setup. 2. Select the Header/Footer tab. 3. Select Custom Header. 4. Select Left section. 5. Click the Picture icon (the second i -
EXCEL 用千表示数值的方法
爱读书aread.cc翻译,转载请保留此信息 . 1. Press Ctrl+1 to open the Format Cells dialog box. 2. Select the Number tab, and from Category, select Custom. 3. In the Type box, enter the following Custom Fo
留言与评论 (共有 条评论) |