Jul 06 2023 03:39 AM
I have a spreadsheet 3077 x BV, far wider than my screen can cope with.
So I frequently have to hide considerable numbers of columns to navigate around and edit lines and columns.
However when I unhide a set of columns, the cursor is placed at the top to the spreadsheet, even though my working cell may be 2000 lines lower down. It is a very fiddly process returning to that position.
How can the position of the working cell be retained while the view is changed?
Jul 06 2023 06:01 AM
By default, Excel positions the cursor at the top-left cell (A1) when you unhide columns or perform other actions that change the view. However, there are a couple of workarounds you can try to retain the position of the working cell while unhiding columns:
This will keep the selected rows and columns frozen, allowing you to scroll through the spreadsheet while retaining your working cell's position.
This method allows you to quickly jump back to your working cell after unhiding columns.
By using Freeze Panes or named ranges, you can maintain your working cell's position while hiding and unhiding columns, making it easier to navigate through large spreadsheets. Choose the method that suits your workflow and preferences.
The text and the steps were created with the help of AI.
My answer is voluntary and without guarantee.
Hope this will help you.
Jul 06 2023 01:22 PM
On which Excel version you are and how you do that? For example, I'm here
Select columns B and CO with pressed Ctrl. Right click, Unhide. And I'm still at the same place
Jul 12 2023 12:05 AM
Thank you. I am using Office 2021.
I repeated what you showed and had no problem.
Next time I am doing this operation, I shall pay more attention to what I click to find where I am going wrong.
Jul 12 2023 12:34 AM
@C V Horie , glad to know it sorted out, thank you for the update