Determine last cell on sheet with value

[me231]

find the last cell in a sheet with contents... not last cell in a column or last cell in a row -- - last cell on sheet with value

Ctrl+end is what keeps coming up - using mac keyboard i can't locate this shortcut

Fn and arrows so not work
Ctrl and Arrows don't work
Cmd and arrow up down take me to 1st and last rows - not last cell -

just curious

thanks in advance

[Alex1]

Try Cmd+End.

[me231]

but on mac keyboard where is that "end" Key - i have tried all the arrows with combinations of fn, ctrl option,cmd....with no glory = not super important just kinda frustrating

[RoryOF]

Possibly Fn right arrow.

[robleyd]

LMGTFY

https://osxdaily.com/2015/06/17/home-en ... functions/

[Lupp]

... not last cell in a column or last cell in a row -- - last cell on sheet with value ...

There isn't such a thing generally.
To call a cell the last one regarding one or another property would require a clearly defined linear order of all the cells.
Such an order doesn't exist. Only if you can assure that the set of all the cells of the sheet having the property of interest have a rectangular "closure" where the last element of the last column (also the last element of the last row then) also has that property, the result can be unambiguous.
In addition it must be unambiguously defined what is to be accepted as a "cell with value".
The attached example contains some Basic code from my library concerning the closure of cell sets.

aoo546343LastCellContainingValue_WHAT_posted.ods

(15.38 KiB) Downloaded 41 times

[Nick N,]

me231 wrote:
> find the last cell in a sheet with contents... not last cell in a column
> or last cell in a row -- - last cell on sheet with value
>
> Ctrl+end is what keeps coming up - using mac keyboard i can't locate this
> shortcut
>
> Fn and arrows so not work
> Ctrl and Arrows don't work
> Cmd and arrow up down take me to 1st and last rows - not last cell -
>
> just curious
>
> thanks in advance

Funny behavior. My wife told me that on her mac Fn and down arrow would do.

[MrProgrammer]

Ctrl+end is what keeps coming up - using mac keyboard i can't locate this shortcut

Look in Help. Help → OpenOffice Help → OpenOffice Calc → Index → shortcut keys;spreadsheets says to use Command+End, not Ctrl+End.

OpenOffice Calc help

202404251022.gif (74.79 KiB) Viewed 213 times

LibreOffice help is similar; use Command+End.

LibreOffice Calc help

202404251113.gif (32.93 KiB) Viewed 210 times

but on mac keyboard where is that "end" Key?

That is a MacOS question, not an OpenOffice question. Windows PCs usually have a key marked End. To learn about End, look in the documentation for your Mac. In Finder, I used Help → MacOS Help → Search → Windows keys → Windows keys on a Mac keyboard. The picture below is what I see on my Mac. On my Mac to perform End I hold fn and press right arrow. On my Mac to perform Command+End I hold Command and fn, then press right arrow. Your Mac may be different.

MacOS help

202404251033.gif (29.74 KiB) Viewed 213 times

There isn't such a thing [last cell on sheet with value] generally. … Such an order doesn't exist.

Correct, just as the Complex Numbers do not form an ordered field. The difficulty here is that Calc's help for the shortcut is incorrect in both OpenOffice and LibreOffice. It says: Moves the cursor to the last cell on the sheet which contains data. Command+End actually moves the cursor to the cell at the intersection of the last (bottommost) row with data and the last (rightmost) column with data. The cell itself might be empty. Pressing ⌘End, then ⌘⇧Home, will select all of the data on the sheet.

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Mac FAQ