Excel: Show only numbers of a certain size
If you only want to display numbers of a certain size in Excel, you can simply hide the other numbers and numbers, so you can keep an overview even with large tables.
Auto filter: Only show certain numbers in Excel
You can use the autofilter if, for example, you have a table in which you only want to display the rows whose value in the column exceeds 100:
- To do this, mark the area of the column from which you want to exclude the numbers below 100 and click on "Data"> "Auto filter"
- Clicking on the arrow symbol in the marked column creates a list with the marked values of the column and various options in parentheses.
- Select "User-defined" and enter "> 100" in the first field at the top. This filter specifies that only the rows are displayed whose value in the selected column is 100 or higher.
- In this case, however, Excel hides the entire rows if the value is below 100. If you want to see all rows, but only show the amounts above 100 in the cells with the amount, use a user-defined cell format.
Show specific numbers in Excel with custom cell format
- To do this, select the desired cell range and select "Format"> "Cell"> "User-defined". Under "Formats" delete the entry Standard and instead write the string [<100] \ Standard.
- This format hides all values below 100, but the rest of the line is still visible. Excel continues to include the hidden values in the result.
- For example, if you only want to display values between 0 and 100, use the format [100] \ Standard.