activate excel tooltip

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I have 2 questions for anyone who can help:

1. How can I activate the option that makes Excel show me the syntax model
of a formula/function I want to introduce in the address bar?

2. How can I filter only the rows with a particular color(e.g. want to
select only the rows formatted with green background)
I'd be grateful if you can send me any solution on my email address:

(e-mail address removed)

Thank you.
 
1.
From your address bar type: =SUM( then press CTRL+SHIFT+A

2.
Copy the entire column into a spare column
Find/Replace the colour green and relpace with value 1
Then autofilter that column by the value 1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

active combobox - possible to configure as display value andcoordinate value? 3
conditional format - table - cell empty return default color 1
how to add tooltips to excel udfs i created? 7
Excel VBA - counting cells by colors and names to it in two different rows. 0
Tooltip and ActiveX control 2
edit chart datapoint tooltip 3
Help with Tooltip on clipart 12
need help on excel vba please :ActiveWorkbook.FollowHyperlink Address:="TextBox1.Text" 5

Back
Top