excel公式快速填充_审核Excel公式快速提示

excel公式快速填充

This week, I’ve added a new page to my Contextures site, with a few quick tricks for auditing worksheet formulas.

本周，我在Contextures网站上添加了一个新页面，其中包含一些审核工作表公式的快速技巧。

工作表上的审核公式 (Auditing Formulas on a Worksheet)

I’m giving an Excel tips presentation on Friday, and one of the topics that I’ll include is Auditing Excel Formulas.

我将在星期五进行Excel技巧演讲，而我将包括的主题之一是“审核Excel公式”。

In the video below, you’ll see how to:

在下面的视频中，您将看到如何：

• use keyboard shortcuts or Ribbon commands to show worksheet formulas
  使用键盘快捷键或功能区命令显示工作表公式
• show formulas in an adjacent column, using the new FORMULATEXT function
  使用新的FORMULATEXT函数在相邻列中显示公式
• use keyboard shortcuts to go to dependent or precedent cells
  使用键盘快捷键转到相关或先前的单元格
• trace precedent and dependent cells with arrows, then remove the arrows
  用箭头跟踪先例和从属单元，然后删除箭头

审核公式的更多提示 (More Tips for Auditing Formulas)

For more tips on how to audit formulas in your Excel files, go to my Contextures website. There's also an Excel file that you can download, to follow along with the video.

有关如何审核Excel文件中公式的更多提示， 请访问Contextures网站 。 您还可以下载一个Excel文件，并随视频一起下载。

视频：工作表上的审核公式 (Video: Auditing Formulas on a Worksheet)

To see a few commands and shortcuts for auditing and troubleshooting formulas, watch this short video.

要查看一些用于审核和故障排除公式的命令和快捷方式，请观看此简短视频。

演示地址

博客问题 (Blog Problems)

In other news, for the past couple of weeks I’ve had lots of trouble with this blog. It’s been up and down, and I’m sorry if you’ve come to visit, and found the doors closed!

在其他新闻中，过去几周来，我在此博客上遇到了很多麻烦。 它已经上下了，很抱歉，如果您来参观，发现门已关闭！

The sturdy-looking door shown below is at Brock’s Monument, in Niagara-on-the-Lake, which I visited earlier this month.

下图所示的坚固门位于尼亚加拉湖畔的布罗克纪念碑(Brock's Monument)，我本月初曾参观过该门。

So, I’ve turned off a few things on the blog, like subscribing to comments, to see if that helps.

因此，我关闭了博客上的一些内容，例如订阅评论，以查看是否有帮助。

Maybe Dick Kusleika, at Daily Dose of Excel, has some tips for me, if he has managed to sorted out his blog problems.

如果他设法解决了博客问题 ，也许Excel的Dose的Dick Kusleika对我有一些提示。

翻译自: https://contexturesblog.com/archives/2014/05/29/auditing-excel-formulas-quick-tips/

excel公式快速填充