Here's what I think about
getting more out of Microsoft Excel.
Control the cursor.
Enter a value in a cell and control what pressing TAB does. It doesn't have to go down!
Excel automatically moves the cursor to the next cell down when you press Enter after entering a value in a cell. What if you want to enter an item in the next column instead? To take control of this, go up top and try: File ->Excel Options -> Advanced ->Editing Options.
Enable Check-box “After pressing Enter, move selection” and its corresponding drop-down. Tip: Upon disabling the check-box, your arrow keys can be used to control the direction of the pointer. For example, if you’re entering data in a row, press the right-arrow key rather than Enter to move to the next cell in the same row.
"To the right, right?"
Right!
Make a SEARCH field.
First, make sure you have "Developers" shown in Excel's top ribbon. If you don't, go to File --> More --> Options --> Customize Ribbon and enable it. Trust me; you'll enjoy it.
Now open an Excel worksheet and go to the cell where you wish to create the search box. Type "SEARCH" or whatever you want to call it. Let's just say it's G1. Tip:Change its color to distinguish it from other cells.
Now select the whole data range from where you want the data, or the value searched. Go to Developers --> Conditional Formatting --> New Rule. On the next window, click the option: "Use a formula to determine which cells to format." Enter this formula =SEARCH($G$1,$A2&$B2&$C2&$D2) below the text box, where you see, "Format values where this value is true." The selected range, in this case, is A2: D27 (we're only grabbing the top rows of the actual data for this formula - NOT the labels above them, like Last Name, Date, or what have you).
Now, click the Format button below it to choose the highlight color of your searched data. SO after clicking "OK", saving the whole shebang, and clicking in your newfangled Search box, you'll see the results show up in the highlight color you chose.