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.
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]
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.