2024-02-12 20:00:00
How to create an Excel screen that is easy to work with
follow
Source: Nikkei PC, October 23, 2023 issue pp.77-82 Retitled and edited “How to create an Excel screen that is easy to work with”
(Article is based on information at the time of writing and may now differ)
By limiting the types and range of data that can be entered into cells, you can reduce errors when entering data. This time, let’s use “data entry rules” to add various settings to each column of the table.
Last time, I created a reservation record table where data was added sequentially, and I set the display format and converted it into a table. This time, let’s improve the same table (Figure 1). Specifically, use “data entry rules” to set the type and range of data that can be entered in each column. Prohibit input of other data or display a confirmation message. This can greatly reduce errors during input work.
*Explanation is provided for Excel 2016 and later versions.The screen is Microsoft 365 Personal Excel
From now on, you will need to register as a Nikkei Crosstech Active member.
Nikkei Crosstech Active is an information site that supports the selection and implementation of products and services for companies in the IT, manufacturing, and construction fields. We publish a lot of content such as product/service information and introduction examples. If you are viewing it for the first time, please register as a member (free of charge).
Next page Set the date range using a formula
1707768967
#Reduce #errors #Excel #input #restrict #detailed #data #entry #rules #create #easytowork #Excel #screen #Nikkei #Crosstech #Active
