Navigation Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/navigation/ Bestselling Excel and Power BI Courses Sun, 16 Jun 2024 09:45:05 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Navigation Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/navigation/ 32 32 Excel Settings You Should Change Now https://www.xelplus.com/excel-settings-to-change/ Thu, 25 Aug 2022 09:00:00 +0000 https://www.xelplus.com/?p=9064 Excel comes with default settings and options. You can change these to support your workflow and be more productive. This post covers my list of options to review.

The post Excel Settings You Should Change Now appeared first on Xelplus - Leila Gharani.

]]> Use This Excel Hidden Shortcut to Select Column with Blank Cells https://www.xelplus.com/excel-shortcut-select-column-with-blanks/ Thu, 12 Mar 2020 10:00:00 +0000 https://www.xelplus.com/?p=11432 Find out a secret workaround that takes care of the problem of blank cells in the middle of your data range when you're trying to quickly navigate to the end of the range with the help of shortcuts. It can get really frustrating, especially in a long range with lots of blanks. But there is a way - several, in fact. Next time you come across this issue, you will be fully equipped.

The post Use This Excel Hidden Shortcut to Select Column with Blank Cells appeared first on Xelplus - Leila Gharani.

]]> Excel ActiveX Combo Box with VBA https://www.xelplus.com/excel-activex-combo-box-with-vba/ Thu, 20 Sep 2018 12:42:00 +0000 https://www.xelplus.com/?p=9896 Learn how to create an ActiveX combo-box that allows for easy navigation for larger workbooks. While we're creating this, you also learn about Excel's Event procedures.

The post Excel ActiveX Combo Box with VBA appeared first on Xelplus - Leila Gharani.

]]>