Excel Middle mouse button click not scrolling

0 votes

I have a workbook that will not let me glide around by clicking and holding the middle mouse button.

I've seen a lot of answers and help around basic scrolling with the mouse, but that's working fine in this case. It's when I hold down the button, nothing happens. It works on other spreadsheets I have open at the same time so the problem must be specifically with that workbook.

I seem to remember having the same trouble long ago with a single sheet in a book.

Any ideas? The workbook does have a lot of VBA, but I've been unable to detect any part which would affect this. Could there be something buried in that?

Apr 1, 2022 in Database by Edureka
• 13,670 points
2,551 views

1 answer to this question.

0 votes

Workbook and Protected Sheet
If the sheets are protected and aren't working as they should, please unprotect the sheet and workbook using Review>Protect/Unprotect sheet /workbook.Protect Workbook

Defrost the Panes
When a user creates the freeze option incorrectly, the height of the rows is incorrectly changed, and we are unable to scroll properly. We may verify this by unfreezing the panes in the following manner:

In most circumstances, users are unable to scroll down Excel spreadsheets due to frozen panes. Select the View tab in Excel to unfreeze panes.
Freeze Panes is activated by pressing the Freeze Panes button.
Then choose Unfreeze Panes from the menu. After that, see if you can scroll down the spreadsheet.Unfreeze Panes

answered Apr 4, 2022 by Edureka
• 13,670 points

Related Questions In Database

0 votes
1 answer
0 votes
0 answers

Check Excel file format from PowerScript not relying on file extension

We have a number of Excel files ...READ MORE

Mar 31, 2022 in Database by Edureka
• 13,670 points
319 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,240 points
908 views
0 votes
1 answer
0 votes
1 answer

What is the NOT Operator in MySQL?

NOT operator displays a record when the ...READ MORE

answered Dec 14, 2018 in Database by Sahiti
• 6,370 points
754 views
0 votes
3 answers

MySQL "Could not create connection to database serve" error

Pls check that you have MySQL server ...READ MORE

answered Jul 3, 2020 in Database by anonymous
29,241 views
0 votes
1 answer

NOT IN vs NOT EXISTS

In my opinion, the most efficient way ...READ MORE

answered Feb 11, 2022 in Database by Neha
• 9,060 points
351 views
0 votes
1 answer

Should I use != or <> for not equal in T-SQL?

Most of the existing databases support != Databases that ...READ MORE

answered Feb 14, 2022 in Database by Vaani
• 7,020 points
267 views
0 votes
1 answer

Excel 2010 CTRL+SHIFT+L. Not working

The Macro-containing workbook was always open in ...READ MORE

answered Apr 4, 2022 in Database by Edureka
• 13,670 points
6,020 views
0 votes
1 answer

How to view the XML form of an Excel file?

Excel is a spreadsheet programme. Click File->Open in ...READ MORE

answered Mar 25, 2022 in Database by Edureka
• 13,670 points
5,039 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP