To show hidden rows in Excel, you can follow different methods depending on how the rows were hidden (via right-click, filtering, or manually). Here’s a comprehensive breakdown of how to unhide rows, with examples for each scenario.
Continue reading “How to show hidden rows” »I’m using Array Formulas to find the last filled or the last non empty cell ,it’s the same :). Important: Each formula must be confirmed by Ctrl+Shift+Enter (not just Enter). Continue reading “Value of the last filled cell in a column or in a row” »
In some cases it is useful to know the address of the first empty cell in a column. This is a way to do this without macros. Write the following formula and press CTRL+SHIFT+ENTER. Excel adds braces { } and saves it as array formula.
=ADDRESS(ROW(INDEX(firstCell:lastCell, MATCH(TRUE,LEN(firstCell:lastCell)=0,0),1)),column number)
Continue reading “Address of the first empty cell in a column” »
Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress
