ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to roll mouse in formula (https://www.excelbanter.com/excel-worksheet-functions/244933-how-roll-mouse-formula.html)

wcp

How to roll mouse in formula
 
Hi , need to use this operate as excel 2003. When I type = [and type
formula] , as this time I can roll the mouse to see the cell I need [but
2007 can't do] Why ??? or I miss some config in excel option ?
Need your help , because sometime I have more row in sheet and inconvenience
to use right scroll bar.
Thank you.
Wichian P.

Ms-Exl-Learner

How to roll mouse in formula
 
Try this€¦

Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing Options Uncheck the "Zoom on roll
with IntelliMouse"

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

Hi , need to use this operate as excel 2003. When I type = [and type
formula] , as this time I can roll the mouse to see the cell I need [but
2007 can't do] Why ??? or I miss some config in excel option ?
Need your help , because sometime I have more row in sheet and inconvenience
to use right scroll bar.
Thank you.
Wichian P.


wcp

How to roll mouse in formula
 
No , this option mean to zoom in-out only.

"Ms-Exl-Learner" เขียน:

Try this€¦

Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing Options Uncheck the "Zoom on roll
with IntelliMouse"

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

Hi , need to use this operate as excel 2003. When I type = [and type
formula] , as this time I can roll the mouse to see the cell I need [but
2007 can't do] Why ??? or I miss some config in excel option ?
Need your help , because sometime I have more row in sheet and inconvenience
to use right scroll bar.
Thank you.
Wichian P.


Ms-Exl-Learner

How to roll mouse in formula
 
When that Zoom option is checked, in that time also we cant able to scroll
the mouse to our desired cell while editing a formula. That is the reason I
have suggested it.

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

No , this option mean to zoom in-out only.

"Ms-Exl-Learner" เขียน:

Try this€¦

Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing Options Uncheck the "Zoom on roll
with IntelliMouse"

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

Hi , need to use this operate as excel 2003. When I type = [and type
formula] , as this time I can roll the mouse to see the cell I need [but
2007 can't do] Why ??? or I miss some config in excel option ?
Need your help , because sometime I have more row in sheet and inconvenience
to use right scroll bar.
Thank you.
Wichian P.


Ms-Exl-Learner

How to roll mouse in formula
 
I think I found it€¦

Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing OptionsCheck the Allow Editing
Directly In Cells

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

No , this option mean to zoom in-out only.

"Ms-Exl-Learner" เขียน:

Try this€¦

Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing Options Uncheck the "Zoom on roll
with IntelliMouse"

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

Hi , need to use this operate as excel 2003. When I type = [and type
formula] , as this time I can roll the mouse to see the cell I need [but
2007 can't do] Why ??? or I miss some config in excel option ?
Need your help , because sometime I have more row in sheet and inconvenience
to use right scroll bar.
Thank you.
Wichian P.


wcp

How to roll mouse in formula
 
So much thank you , Ms-Exl-Learner.

"Ms-Exl-Learner" เขียน:

I think I found it€¦

Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing OptionsCheck the Allow Editing
Directly In Cells

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

No , this option mean to zoom in-out only.

"Ms-Exl-Learner" เขียน:

Try this€¦

Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing Options Uncheck the "Zoom on roll
with IntelliMouse"

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

Hi , need to use this operate as excel 2003. When I type = [and type
formula] , as this time I can roll the mouse to see the cell I need [but
2007 can't do] Why ??? or I miss some config in excel option ?
Need your help , because sometime I have more row in sheet and inconvenience
to use right scroll bar.
Thank you.
Wichian P.


Ms-Exl-Learner

How to roll mouse in formula
 
You're Welcome

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

So much thank you , Ms-Exl-Learner.

"Ms-Exl-Learner" เขียน:

I think I found it€¦

Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing OptionsCheck the Allow Editing
Directly In Cells

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

No , this option mean to zoom in-out only.

"Ms-Exl-Learner" เขียน:

Try this€¦

Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing Options Uncheck the "Zoom on roll
with IntelliMouse"

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

Hi , need to use this operate as excel 2003. When I type = [and type
formula] , as this time I can roll the mouse to see the cell I need [but
2007 can't do] Why ??? or I miss some config in excel option ?
Need your help , because sometime I have more row in sheet and inconvenience
to use right scroll bar.
Thank you.
Wichian P.


MurrayBarn

How to roll mouse in formula
 
I have that box ticked but it still wont scroll. I am using XP Pro, Excel
2007 and a Microsoft Optical Wireless mouse



"Ms-Exl-Learner" wrote:

I think I found it€¦

Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing OptionsCheck the Allow Editing
Directly In Cells

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

No , this option mean to zoom in-out only.

"Ms-Exl-Learner" เขียน:

Try this€¦

Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing Options Uncheck the "Zoom on roll
with IntelliMouse"

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

Hi , need to use this operate as excel 2003. When I type = [and type
formula] , as this time I can roll the mouse to see the cell I need [but
2007 can't do] Why ??? or I miss some config in excel option ?
Need your help , because sometime I have more row in sheet and inconvenience
to use right scroll bar.
Thank you.
Wichian P.


Ms-Exl-Learner

How to roll mouse in formula
 
Have you Unchecked the zoom option?

--------------------
(Ms-Exl-Learner)
--------------------



"MurrayBarn" wrote:

I have that box ticked but it still wont scroll. I am using XP Pro, Excel
2007 and a Microsoft Optical Wireless mouse



"Ms-Exl-Learner" wrote:

I think I found it€¦

Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing OptionsCheck the Allow Editing
Directly In Cells

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

No , this option mean to zoom in-out only.

"Ms-Exl-Learner" เขียน:

Try this€¦

Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing Options Uncheck the "Zoom on roll
with IntelliMouse"

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"wcp" wrote:

Hi , need to use this operate as excel 2003. When I type = [and type
formula] , as this time I can roll the mouse to see the cell I need [but
2007 can't do] Why ??? or I miss some config in excel option ?
Need your help , because sometime I have more row in sheet and inconvenience
to use right scroll bar.
Thank you.
Wichian P.



All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com