Five Excel tricks that will make you a wizard. Number one. Go to the following website and here you’ll see all of the different available shortcut keys in Excel. My personal favorite. Highlight some cells and press CTRL + 1 to very quickly format them. Number two. When entering a function, click on this icon. This opens up the function helper and this will walk you through how the function works. Number three. Use your mouse wheel to scroll up and down. Press CTRL + Shift together with your mouse wheel and you can scroll left to right. Number four. Go up to view, freeze panes, and freeze the top row. Now when you scroll down, it’ll lock the header in place. Number five. When referencing another cell, press the F4 key. This will toggle between absolute or locked references and relative references. With great power comes great responsibility.