Shulou(Shulou.com)06/01 Report--

Today, I will talk to you about how to understand the prompt message of mouse hover in excel. Many people may not understand it very well. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

Hint: to reveal, draw attention to, or give reminders and explanations.

In excel, it is often used to add reminders to a grid, such as the amount prompt to enter a numerical value or the maximum length value, and so on. There are also a variety of settings, simple, just insert annotations for the cell, and there are also complex validation methods. The following figure shows the annotation method:

In addition, the same function is often seen in web design, such as the common help prompt box (tips), which displays all the help information when the mouse hovers over the help icon. It's not hard, a few lines of JS script.

The moisturizing report is supported for release on Web, and parents also want the product to have the ability to display messages when the mouse moves to a certain location.

Embellish what customers want, not only support static information, but also allow developers to set dynamic prompt information (a cell that can display different information according to conditions).

Enter the door today to introduce the setting method of static information, and then introduce dynamic prompts in combination with the appropriate scene.

Ok! Let's get to the point. How to set static prompts for moisturizing the report? Take the "payroll" as an example, most people do not know how to calculate the attendance deduction, so here you can set a prompt for the "attendance deduction".

Procedure to prepare payroll report template

Prepare a web format report with the results shown in the following figure

The template is designed as follows

Note: the purpose of this example is to add hints to the title field, so regardless of the data source, the data in the third row is a fixed number.

Set static message prompt (WEB- prompt) in the template

Select E2 in the template, and edit the box "WEB"-"prompt"-"value" in the property area.

Preview report results

The prompt is valid only on the web side, so publish the report first, preview it by the browser, and the effect is as follows when the mouse hovers over "attendance deduction"

By setting cell prompts, it is easy to achieve the reminder function of hovering over the mouse. Like forced paging, dynamic background color and other tips, for this more commonly used function, the report tool has been taken into account in the design. If you encounter similar problems, it is still recommended to consult the manual and the corresponding settings.

After reading the above, do you have any further understanding of how to understand the prompt message of mouse over in excel? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.