ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   highlighting entire functions (https://www.excelbanter.com/excel-discussion-misc-queries/95062-highlighting-entire-functions.html)

BorisS

highlighting entire functions
 
is there any quick way of highlighting entire functions in a formula? In
other words, I know that the parentheses "bold up" when you arrow over their
counterparts, but is there a way to have a double-click sort of action that
selects the entire function, whereever you might be in it?
--
Boris

Dave Peterson

highlighting entire functions
 
I don't know, but if I'm editing a formula, I can do:

Home followed by Shift-End key
or
End followed by shift-home.

Or just use the mouse to "paint" over all the formula.

BorisS wrote:

is there any quick way of highlighting entire functions in a formula? In
other words, I know that the parentheses "bold up" when you arrow over their
counterparts, but is there a way to have a double-click sort of action that
selects the entire function, whereever you might be in it?
--
Boris


--

Dave Peterson

BorisS

highlighting entire functions
 
Does what you wrote get me from one end of the formula line to the other and
vice versa, while highlighting along the way?

I am looking for something that distinguishes teh end points of a function
inside a formula. Not sure if that initially made sense.
--
Boris


"Dave Peterson" wrote:

I don't know, but if I'm editing a formula, I can do:

Home followed by Shift-End key
or
End followed by shift-home.

Or just use the mouse to "paint" over all the formula.

BorisS wrote:

is there any quick way of highlighting entire functions in a formula? In
other words, I know that the parentheses "bold up" when you arrow over their
counterparts, but is there a way to have a double-click sort of action that
selects the entire function, whereever you might be in it?
--
Boris


--

Dave Peterson



All times are GMT +1. The time now is 08:34 AM.

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