I created a dashboard sheet in a workbook and I am trying to lock it so it doesn’t scroll
Is there a way to lock a sheet?
Latest version Of LibreOffice 24.2
Garuda Linux
2 Likes
I think the best way is to hide the rows below and the columns to the right of the dashboard: Use the menu Format > Rows > Hide and Format > Columns > Hide once you have selected the ranges to hide.
3 Likes
Thanks for the help Steph1.
It didn’t quit work though, it just kept hiding the rows I selected underneath and to the right. But there is an endless supply of new rows and columns that just pick up where where I left off.
Thanks For the help LeroyG
I missed the freeze panes on the view tab. I found all the other freeze first row and first column options. If the freeze panes on the view tab was a snake, it would have bit me.
It work as far as freezing the rows now my dashboard does not move up. It will still scroll to the right though, but that’s not a big deal.
So I’ll consider it a win.
However I found that if you resize the window it un-does the freeze panes.
1 Like
Click on the first cell below your dashboard, then press Ctrl+Shift+DownArrow so all the rows up to one million are selected. Then use the menu Format > Rows > Hide.
Click on the first cell to the right of the dashboard, then press Ctrl+Shift+RightArrow so all the columns up to XFD are selected. Then use the menu Format > Columns > Hide.
1 Like
Seems to be a bug, but maybe an undocumented feature:
112641 – freeze rows/columns functions incorrect or unexpected when frozen rows/columns don't fit in Window.
So, @Steph1 solution is better.
1 Like
You can use data grouping (>Data>Group and Outline>Group) and combine it with the already mentioned Freeze tools if appropriate for you.
This way you can easily handle the size of the viewable ranges if needed differently for different situations.
See attatched example.
ask106490ManagingViewableRange.ods (9.3 KB)
1 Like
Thanks Lupp.
What I have is 14 outlined text boxes with formula results from tables and pivot tables along with a big pie chart in the middle from a pivot table from about 6 other sheets. So there’s no data, tables or rows and columns to group on the dashboard sheet.
I made a dashboard as a start page splash screen, so I can see all my balances and business overview on one screen.
I keep inadvertently scrolling it up. So I just want to lock it so it doesn’t move.
The freeze pane solves it as long as I don’t resize the window.
I was kinda hoping it would stay centered and not scroll as I move or resize the window.
Being how I’m on KDE 6 and waylan on an nvidia GPU I’m probably asking for too much. But I’ll take what little I can get.
- You were advised to use
>View>Freeze Rows and Columnsbut replied using the termfreeze panes. - If your settings (locale/language) shows it this way for you, you should state this explicitly. Otherwise you shouldn’ invent a new terminology in a next post to the thread.
- The deletion of a frozen “front range” (columns or rows) only occurs for me with
V24.2.2 English (Canada) under Win 10if the window first was down-sized from the opposite end till the border was out of view. Please be precise about observations. - Questioners are encouraged to check for answers already supplied in previous threads. My solution was given with the intention to help visitors coming this way, but having problems more precisely matching the literal subject of the topic. Your very special case where you only needed a few rows and columns to be excluded from scrolling while the rest was still scrollable was not known to me at that time.
See also:
AvoidingAnyScrollingOfAViewAsLongAsTheWindowIsLargeEnoughToShowItCompletely.ods (9.2 KB)