filtering

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filtering

Filtering

resolvedResolved · Low Priority · Version Standard

Chris has attended:
Excel Advanced course

Filtering

How can I make sure the whole sheet will sort when I apply a filter (rather than just the column I'm querying)?

RE: Filtering

Hello Chris,

Hope you enjoyed your Microsoft Excel course with BEST Training.
Thank you for your question regarding making sure the whole sheet will sort when applying a filter.

This is a good question, and one that is fortunately easy to answer. With the new versions of Excel, generally it will select the entire table that you are working with, provided that you put your cursor into the table before you activate the filter.

If you find that this is not the case, you can test to see what Excel will automatically select, and then make a choice to modify that before filtering.

The way to to do this is to put your cursor anywhere in the table, and the hold CTRL and press *. This will select the table that you are currently in. ( Also good for just generally selecting big tables!). If this selection is not what you want, then you can manually select the cells that you want to include in the filter.
If there is a break in the data, then Excel will not be able to determine that, and will leave any unconnected data out of the selection. For example, if you have data in columns A to D, and then none in E, with data starting in F, excel will not be able to automatically include all the fields - you need to manually select them.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer


 

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips


Server loaded in 0.09 secs.