官术网_书友最值得收藏!

Making the spreadsheet more readable with comments

Sometimes cells need additional information to explain how they are used. Of course you can write this text as a label in another spreadsheet cell, but a better solution is to use comments.

Getting ready

You can use the same basic dashboard as for the previous recipe.

How to do it...

  1. Right-click the cell to which you want to add the extra information.
  2. Choose Insert Comment.
  3. Add your text. A small red rectangle will appear in the right upper corner of the cell.
  4. Now hover your mouse over the cell and the comment you just entered will appear.

How it works...

Comments are related to one spreadsheet cell only and are only shown if you hover the mouse over this cell. This is a great way to document information that you do not need to see all the time, which keeps your data model clean.

A good case to use this is when you are building a dashboard with multiple layers in combination with dynamic visibility. You might use numbers to identify each layer and use a cell to contain the number of the active layer. You can use a comment to describe the meaning of these cell values.

A little remark about the usage of comments is that they do increase the size of the Dashboard Design file a bit.

主站蜘蛛池模板: 三河市| 嘉义县| 开阳县| 苍梧县| 大冶市| 扬州市| 新河县| 盐源县| 文水县| 密云县| 平乡县| 利辛县| 来凤县| 全南县| 彰化市| 濮阳县| 那坡县| 安庆市| 通海县| 泰来县| 饶平县| 河东区| 桦甸市| 繁峙县| 新丰县| 博白县| 岚皋县| 凌源市| 日照市| 宁远县| 阳东县| 庄浪县| 涟水县| 合山市| 灵山县| 桂平市| 汤阴县| 城固县| 和林格尔县| 江都市| 巨鹿县|