Skip to main content

Restricting data type that can be entered in excel cells

Excel has a massive amount of functionality and components. Just need the right triggers and measures to make the most benefit out of it. Here I will again present a few amazing excel tools which would be a terrific help for you to generate compelling reports.

Specifying user data type inputs in excel columns means that you can design a report where you can restrict users to enter precise data types only in defined excel columns such as Date, number, time text length etc. Here are the few steps you need to follow.

1. Go to the menu Tab and select Data. click on Data validation in the right top of the data bar (Refer to the below screenshot).

2. Next, a fresh window will appear on the screen. Choose the Validation Data type that you want to be specified (Refer to the below screenshot)

3. We can also specify the Data range type from Data drop-down list (Refer to the below image)

For example, I want people to enter dates specific between 24-Jan-2022 to 31-Jan-2022 in the precise columns. Would pick Date option from the drop-down list, and further, between option in Data and enter a date range in the subsequent columns. (Refer to the below screenshot)

4. Further, you can add a warning type for the people on the columns, so they understand what to enter in the particular column. To do so, please click on Input Message on the top of the window and Add Title & Input message which you want to get appear as direction. For example, we have added Restricted Column in the Title and “Please enter data range between 22-Jan-2022-31-Jan-2022” in the Input Message ( Refer to the below Image).


5. Once done, press OK. That’s it, now it is prepared and would look something like this in the below screenshot while entering the data. Would not allow the user to enter any date other than defined in the rule.


Will throw this error if entered value exceeded defined rule

Labels:

Comments

Post a Comment

Popular posts from this blog

How to add CC recipients in Mail-Merge

Please refer How to do a Mail-Merge in MS Office to pursue this article further. I am going to explain the steps to send personalized emails to a huge group of receipts by looping people\groups in an email CC. Though, there is no straightforward technique for doing so. But there is one trick that functions like a charm. The trick is that we will create a new outlook rule which indicates whenever we send an email with the specific subject line, it will automatically include certain group\people in the CC. Steps to create this new rule in Outlook 1. Go to Rules in the menu bar and select Manage Rules & Alerts. 2. Then a dialogue box will appear. Click on the New Rule and choose Apply rule on messages I send in the following wizard (refer to the below screenshot) and Click Next. 3. In the subsequent window, tick the first line, which says with specific words in the subject line in Step 1 and click on a specific word from Step 2 (Refer to the below screenshot). 4. On clicking ...
Post a Comment
Read more

These instructions will allow you to save password-protected PDF attachments from Gmail to Google Drive.

Discover how to automatically save PDF attachments that require a password from Gmail to Google Drive and transform them into unencrypted versions that can be accessed conveniently washout a password. Financial statements are frequently sent by financial institutions as password-protected PDF files, including banks and credit card firms. Passwords formed from personal information, like your birthdate, Social Security number, or a special mix of details, are frequently used in these attachments. To access password-protected PDF files, you must enter the password each time. While Google Chrome allows for the permanent removal of passwords from PDFs, the manual and time-consuming nature of the process can be burdensome, especially if you have a substantial number of such attachments in your Gmail inbox. Imagine how easy it would be to have a solution that downloads all of your password-protected PDF attachments from Gmail straight to Google Drive and converts them into PDF files that aren...
Post a Comment
Read more

All you need to know about Service now ITSM Standard & ITSM Professional

ServiceNow offers two primary editions for its IT Service Management (ITSM) solution: ITSM Standard and ITSM Professional. Here's an explanation of each edition: ITSM Standard: ITSM Standard is the foundational edition of ServiceNow's ITSM offering. It provides essential ITSM capabilities to streamline service delivery and improve IT support processes. Key features of ITSM Standard include: Incident Management: Allows IT teams to log, track, and resolve incidents efficiently, minimizing service disruptions and reducing downtime. Problem Management : Helps identify the root causes of recurring incidents and facilitates proactive problem resolution to prevent future disruptions. Change Management: Enables IT teams to plan, assess, and implement changes in a controlled manner, reducing risks and maintaining service stability. Service Catalog : Provides a self-service portal where users can request IT services, track their requests, and access knowledge articles to find answers t...
Post a Comment
Read more