In some files there is a central sheet that you keep returning to. It might hold the inputs or the controls for the file. You can simplify getting to that sheet by using a logo as a hyperlink.
Using a logo means you can place it anywhere on another sheet. It’s also easy to copy and paste the logo on other sheets once created.
You can add a hyperlink to any image, so it doesn’t have to be a logo.
There are two easy ways to open the Insert Hyperlink dialog.
Either right-click the image and select Hyperlink – see image below.
Or select the image and press Ctrl + k.
Click the Place in This Document button and select the sheet to go to. You can also link to a named range. They would be listed under Defined Names. Using a range name avoids sheet name changes that can break hyperlinks.
Click OK and it’s done.
Useful Shortcut – return from hyperlink
After you follow a hyperlink you can return to where you were when you clicked it by first pressing F5 and then pressing Enter.
Stay tuned for a way to create an almost unbreakable hyperlink in a future blog post.
When creating a drop down selection you usually want to restrict the user to certain entries. There are cases however when you want to allow the user to choose an option or allow them to type in their own entry.
Entering today’s date in Excel can be done a couple of ways. It depends on whether you want the cell to always show the current day’s date or whether you want to capture today’s date so that it doesn’t change.
Excel’s Go To feature provides a quick way to select certain types of cells. For example, if you wanted to apply the same fill colour to all formula cells on a sheet, you can do that in five easy steps using Go To.
The ALT key (there’s one on either side of your Spacebar) has some really useful shortcuts. See if they can save you some time and effort. These can be handy if, like me, you sometimes struggle with your laptop’s built-in mouse controller and you don’t have your external mouse handy. And remember most keyboard shortcuts work in all versions of Excel.
The F4 function key in Excel has a dual personality.
When used normally it will repeat your last action. This is useful for formatting, deleting rows and other operations that require a few keystrokes. Pressing F4 can reduce the keystrokes. F4 can also repeat running a macro.