Today, a colleague asked me how to set the range of input values ​​in Excel. The following describes how to set the range of input values ​​in Excel.

Open an Excel table;

select area;

data – data validation;

allow-decimal;

Data – between, enter 0 for the minimum value, enter 100 for the maximum value, OK;

Finally, look at the effect and set it successfully;

The above is the method of setting the input value range in Excel.

input values ​​in Excel

Excel find duplicates and extract

1 First open the excel sheet and select all the sheets that need to find duplicates.

2 Then click Conditional Formatting in the upper toolbar and select Highlight Cell Rules.

3 Click the Repeat value option again, and click the OK button in the pop-up window.

4 Then click Sort and Filter, select a filter option, and click the arrow above the table.

5 Finally, select Filter by Color, and then click Filter by Cell Color.

 

How to Freeze Specified Rows and Columns in Excel?

• Freeze first row or first column window   

The first step is to open the Excel sheet that needs to be consulted, click the [Start] tab, and find the [Freeze Window] option.  

The second step, click to expand the drop-down menu of [Freeze Window], we can see that there are three options, we can click to select [Freeze the first row]

• Freeze a row and a column at the same time, such as [Freeze row A2 and column A1]   

The first step is to open the Excel sheet that needs to be edited, and then select a cell where column A1 and row A2 intersect.  

The second step, click to expand the drop-down menu of [Freeze Window], and select the first option [Freeze]

input values ​​in Excel

How to delete a lot of blank rows and columns in Excel?

1. Open an excel sheet with a large number of blank rows and columns, and select the data range.

2. Click “Find and Select – Targeting Criteria”.

3. Select the empty value and click “OK”.

4. All blank lines are selected.

5. Click “Delete – Delete Worksheet Row”. If there are a lot of blank columns, you can do the same.

Is FM WhatsApp safe?

Why choose Fouad WhatsApp?

Leave a Reply

Your email address will not be published. Required fields are marked *