blanks Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/blanks/ Bestselling Excel and Power BI Courses Thu, 09 Mar 2023 11:06:57 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png blanks Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/blanks/ 32 32 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.

]]> Use this Excel Trick to Only Count Cells with Text (Exclude Numbers and Blanks) https://www.xelplus.com/excel-formula-hack-count-text/ Thu, 05 Mar 2020 10:00:00 +0000 https://www.xelplus.com/?p=11441 Check out this Excel formula hack to count text cells only. This mysterious syntax excludes blank cells, numbers and also cells with formulas that result in an empty string.

The post Use this Excel Trick to Only Count Cells with Text (Exclude Numbers and Blanks) appeared first on Xelplus - Leila Gharani.

]]> Skip Dates in Excel Charts https://www.xelplus.com/skip-dates-in-excel-charts/ Thu, 07 Sep 2017 10:40:00 +0000 https://www.xelplus.com/?p=11958 Learn a simple method to deal with gaps in your data, specifically missing dates. You don't want to display them in a chart, but Excel treats a date axis as continuous and will try to connect the line.

The post Skip Dates in Excel Charts appeared first on Xelplus - Leila Gharani.

]]>