In this tutorial we’ll take a look at basic filtering in Excel, but more specifically how to filter by selection. We will also discuss how to do all this without the use of a mouse, utilizing keyboard shortcuts or key tips only.
Tag Archives | Keyboard Shortcuts
There are many ways to start the creation of your formula in Excel. First, you can go to the Formulas tab and select the function you want from the Function Library: You can also click on the Insert Function button on the Formula bar and type in a description of what you want to do, […]
Using only keyboard shortcuts, this tutorial shows how you can find differences in your data range from your row or column headers in Excel.
You may find several blank rows within your data range that you need to delete. Depending upon how big your data is, there are several options to delete those rows. Let’s take a look at how to do that in Excel.
Here is one way that you can paste data into a range in Excel for only the visible rows and not those hidden…..
Here are some of my favorite keyboard shortcuts for selecting data, inserting columns and rows, and deleting columns and rows…..