Hello Excellers, it has been a short while since I shared some simple Excel tips. So today I want to share an Excel shortcut with you. So, today let’s look at how to quickly box off cells in your Excel range.
We all love a shortcut, don’t we?. I use this every week on my reports. The Ctrl+Shift+& shortcut. This will put an outside standard cell border to your selected cells. you can see how easy and quick this is in the screencast below.
Similarly, if you want to remove your borders and reverse the process, you can use the Ctrl+Shift+_ Excel shortcut. Simple!.
Here are some other blog posts that you may find useful.
Excel Formula Friday – Using Advanced Excel Transpose
How To Excel At Excel – Formula Friday Blog Posts.
Formula Friday- 3 Ways To Enter Excel Formulas
If you want more Excel and VBA tips then sign up to my monthly Newsletter where I share 3 Tips on the first Wednesday of the month and you will automatically receive my free Ebook, 30 Excel Tips.
Likewise, if you want to see all of the blog posts in the Formula Friday Series or the Macro Monday Series Click The Link Below
How To Excel At Excel – Formula Friday Blog Posts.
How To Excel At Excel – Macro Mondays Blog Posts.