Navigation Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/navigation/ Bestselling Excel and Power BI Courses Thu, 16 Mar 2023 23:10:13 +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 4 Excel Settings to Review to be More Productive 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 4 Excel Settings to Review to be More Productive 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.

]]>