I have a spreadsheet with several hundred numbers. I would like to hide a range of numbers. Help
I have a spreadsheet with several hundred numbers. I would like to hide a range of numbers. Help
How are the numbers arranged on the sheet? Are they contiguous?
How do you want to hide them? Do you want them to be completely inaccessible to users, or just not visible? One way to "hide" data is to use a white font. Users can still find and manipulate the data, though.
The only to hide data more thoroughly is to hide ane entire column or row, but I can't tell from your description whether that is going to solve your problem.
Be specific about hiding a range of numbers. Do you mean that you have, for example, numbers that are 1-1000 and you want to hide numbers in the range 225-700? If so you can use conditional formatting to make all numbers white that fall in that range.
I have a million numbers. I only want the even thousand to show. ex 1000, 2000, 3000. I do not want to delete the numbers in between. (my numbers have letters and numbers) so i would like to say hide rows 2 - 999 to show only the thousandths number
Sorry, but this raises more questions than it answered. How are your
numbers arranged? All in one column? Is there other data besides these numbers?
(If you have letters in your numbers, then they are not numbers, they are text.)
One way to do this is to create an extra column. If we assume your numbers are in column A, then in the first row of this new column the formula would be
=MOD(A1,1000)=0
Then add Filter and filter to show only those rows with a value of TRUE in this new column.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks