Excel cells display famous sayings by time rules

Source: Internet
Author: User

Because of my work, I often deal with Excel worksheets for a long time. I remember at the bottom of the TM there is a warm little secretarial tip that changes over time. Can we not give our Excel to add such a similar hint? We are teachers, then the automatic change of a famous aphorism every hour?

The effect is to display a famous aphorism in the specified cell every hour, automatically changing over time, once per hour, 24 hours uninterrupted. The method of implementation is also easier said.

The first step: we want to collect 24 famous aphorism, put them in sequence in the SHEET2 worksheet of the A1:a24 cell, each cell a aphorism, respectively, 0 to 23 points to display the content. As shown in Figure 1.

Step Two: Click the menu command "Insert → name → definition" To open the "Define Name" dialog box. Enter our defined name in the Enter box under name in current workbook, such as "Mingyan". Then, in the input box under reference location, enter the formula "=offset (sheet2! $A $1,hour (now), 0,1,1)". The outer double quotes are not included, and the formula input should be done in the Half-width state of the English language. As shown in Figure 2. When the input is complete, click OK to close the dialog box.

Step three: Click on the specified cell, such as the C5 cell in the SHEET3 worksheet, and enter the formula "=mingyan". Enter, see, the corresponding famous aphorism is not there?

Left-click the Sheet2 sheet tab, and then click the menu command "format → worksheet → hide" To hide our famous aphorism. In this way, when the SHEET3 worksheet C5 every hour to change a famous aphorism, it will appear more magical, the effect will be better.

OK, just three steps, isn't it easy?

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.