Hello. Please, give me a hint on how to collapse and unfold a column with data in an Excel spreadsheet using a mouse wheel.

Select several cells and press Window | Lock panes. This is it?

I do not really understand what is going on and what would it be for? I am asking for an example to clarify the topic

This is very useful when the data column is quite long. By scrolling with the scroll wheel, you can go to the distant cell and do not pull or look through the entire column. Maybe it'll help. Data scrolling does not start from the first row, but is shifted down by a dozen or so. The whole problem is how to do this shift.

I don't really understand what you are asking but maybe you are talking about the grouping function. ALT + SHIFT + right arrow This way you can group selected columns or rows.

Thanks for your interest, but it's not about grouping, I've already mastered it. More about how to move the place from which the cell with the given data will start scrolling. This means that the previous cells, despite being scrolled with a roller, remain visible. It looks like moving the sheet itself down. Regards

Excel Data Collapse/Expand Using Mouse Wheel - How To?

automatyk120 23387 5

Treść została przetłumaczona

Zobacz oryginalną wersję tematu

Reply | New topic

#1 4560762 07 Dec 2007 08:33

automatyk120 automatyk120

Level 11

» |

Post #1
4560762 07 Dec 2007 08:33

Hello.
Please, give me a hint on how to collapse and unfold a column with data in an Excel spreadsheet using a mouse wheel.
ADVERTISEMENT
#2 4561117 07 Dec 2007 11:02

metalli metalli

Level 30

» | Helpful post? (0)

Post #2
4561117 07 Dec 2007 11:02

I do not really understand what is going on and what would it be for? I am asking for an example to clarify the topic
ADVERTISEMENT
#3 4561190 07 Dec 2007 11:51

automatyk120 automatyk120

Level 11

» | Topic author Helpful post? (0)

Post #3
4561190 07 Dec 2007 11:51

This is very useful when the data column is quite long. By scrolling with the scroll wheel, you can go to the "distant" cell and do not pull or look through the entire column.

Maybe it'll help.
Data scrolling does not start from the first row, but is shifted down by a dozen or so.
The whole problem is how to do this shift.
ADVERTISEMENT
#4 4561288 07 Dec 2007 12:03

mareczko mareczko

Level 17

» | Helpful post? (0)

Post #4
4561288 07 Dec 2007 12:03

I don't really understand what you are asking but maybe you are talking about the grouping function. ALT + SHIFT + "right arrow"
This way you can group selected columns or rows.
ADVERTISEMENT
#5 4561323 07 Dec 2007 12:18

automatyk120 automatyk120

Level 11

» | Topic author Helpful post? (0)

Post #5
4561323 07 Dec 2007 12:18

Thanks for your interest, but it's not about grouping, I've already mastered it.
More about how to move the place from which the cell with the given data will start scrolling. This means that the previous cells, despite being scrolled with a roller, remain visible.
It looks like moving the sheet itself down.
Regards
Helpful post

#6 4561329 07 Dec 2007 12:21

Smilox Smilox

Level 18

» | Helpful post? (+5)

Helpful post
Post #6
4561329 07 Dec 2007 12:21

Select several cells and press Window | Lock panes.

This is it?
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

Reply | New topic

Report a violation of the law

Home page
/
Forum
/
Computer Service
/
Software service
/
Excel Data Collapse/Expand Using Mouse Wheel - How To?

Excel Data Collapse/Expand Using Mouse Wheel - How To?

Didn't find an answer? Ask Artificial Intelligence