Excel Tips Archives - How To Excel At Excel

Hide Excel Formulas And Lock Cells To Avoid Editing.

November 6, 2020 by Barbara —Leave a Comment

Hello Excellers and welcome back to another #Excel #FormulaFriday blog post in my Excel 2020 series. Today I want to show you how to not only hide your Excel formula from users but lock those cells. This will prevent any user from attempting to edit your formulas. Keep your hard work away from prying eyes right?. Note. I am not claiming this is 1oo% foolproof but will prevent the average Excel Joe user busting out your Excel Dashboard, or worksheet solution. If you have created a great … [Read more...]

Macro Mondays – How To Remove All Hyperlinks From An Excel Workbook

November 2, 2020 by Barbara —Leave a Comment

Hello, Excellers. Welcome back t another #MacroMonday Excel blog post in my 2020 macro Series. I recently had this question submitted via email from a subscriber. How to remove all hyperlinks. They had a LOT of hyperlinks in an Excel workbook (with 50+ sheets). They needed to quickly delete the hyperlinks as they were no longer relevant. It is easy to remove multiple hyperlinks from a single worksheet, but removing hyperlinks from multiple worksheet tabs requires a little more work. … [Read more...]

Evil Halloween Excel Trick-A Spreadsheet That Scrolls Backwards

October 30, 2020 by Barbara —Leave a Comment

Hello, Excellers. Want a Halloween trick Let's have a bit of fun and be a bit evil?. It is Halloween after all. How about a worksheet prank?. A spreadsheet that scrolls backwards with this Evil Halloween Excel Trick. Only send this to your friends and colleagues who would take a joke now. Really. It is very frustrating. I did warn you. This workbook just does not seem correct somehow. So, it scrolls the opposite way you would expect. I have great fun with an … [Read more...]

Macro Mondays – 3 Reasons To Use Comments In Your Excel VBA Code

October 19, 2020 by Barbara

Hello, Excellers it is time for another blog post on #MacroMonday series again. Today I will go through my top 3 reasons to use comments in your Excel VBA Code. This is sometimes also referred to commenting out a block of code. Top 3 Reason To Use Comments In Your Excel VBA Code. So, let's look at my top 3 reasons to use comments or commentary in your Excel VBA code. When looking at Excel VBA code you may have noticed that some of the code is (usually) in green. … [Read more...]

Is Your Deadline Approaching?. Get A Reminder In Excel.

October 16, 2020 by Barbara

Hello Excellers and welcome back to another #Excel tip in my #FormulaFriday 2020 series. Need to get a reminder in Excel?. Today, let's look at using the NETWORKDAYS function to get a reminder in Excel if your task deadline is approaching. This approach would be very useful for projects and reporting schedules. Do you need to know or reminded that your deadline day is approaching fast or you have a little bit of wriggle room left and are ahead of schedule?. Well, it is one date that … [Read more...]