Excel shortcut keys filter2/19/2023 I've moved the Auto Filter option up so that, in the example below, I hit the "9" key: "New Orleans")ģ) Hit what ever key or combinations of keys necessary to activate that QAT option. ![]() Take the following steps:ġ) Move your cursor using the cursor movement keys to position the active cell based on what you want to filter the data by (e.g. But I said that we were going to do this without the use of a mouse! That's where Key Tips comes in. All you need to now is select any cell that you want to filter by, click on that command, and it will automatically filter the data by that selection. This has now added an command to the QAT. ![]() Here is how you do that:ġ) Click the down arrow at the end of the QAT and choose "More Commands" One way is to add an Auto Filter command to the QAT (Quick Access Toolbar). Now, how can we do all this without the mouse? Well, there are a few options. To avoid that many clicks, we can just do the following:ġ) Without activating the Filter option, right-click on "New Orleans"ģ) Select "Filter by Selected Cell's Value"Īnd we would end up with the same result as above. If we wanted to filter the data by, say, the New Orleans location, we would need to take the following steps:Ĥ) Click the down arrow on the Location header Here we have a data set with varying information, some in color: If you get a preview, look for the download arrow in the upper right hand corner. You can download the file here and follow along. ![]() We will also discuss how to do all this without the use of a mouse, utilizing keyboard shortcuts or key tips only. In this tutorial we'll take a look at basic filtering in Excel, but more specifically how to filter by selection.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |