Excel-底部边框(如果存在文本)? [英] Excel - bottom border if text is present?

问题描述

我现在正在创建一张发票，每张发票上的文本量将有所不同.

I'm creating an invoice at the moment, and there's going to be varying amounts of text on each invoice.

理想情况下，我希望能够输入内容，一旦这样做，它将在该行的底部创建一个边框，从A到K(如果可以的话).

Ideally I'd like to be able to enter content, and as soon as I do that, it'll create a border along the bottom of that row, from A to K if that makes sense.

这可能吗?

干杯:)

推荐答案

不严格编程...您可以从A1到Kn中选择单元格，然后转到格式">条件格式".选择公式是"，输入= $ A1<>".单击格式并设置边框.

Not strictly programming... you can select the cells from A1 to Kn then go to Format > Conditional Formatting. Select "Formula Is", enter =$A1<>"". Click format and set the border.

现在，如果您向col中的单元格输入文本. A，该行将加底线直到K列.不熟悉发票，我只能希望这是您想要的:)

Now if you enter a text to a cell in col. A, that row will be underlined up to column K. Not being familiar with invoices I can only hope this is what you wanted :)

这篇关于Excel-底部边框(如果存在文本)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！