How to show hidden rows

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” »

Value of the last filled cell in a column or in a row

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” »

Address of the first empty cell in a column

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