Hi Krishna
Step1 Press control +g and type cell range that you want to format for
exam ple: a1:h29
Step2 go to the ribbon tab by pressing alt +h then use tab key until
you hear styless grouping conditional formatting then press spacebar.
Step3 use down arrow key and select format cells based on
Hi Minar,
How can i do that?
On 1/2/23, Minar Singh wrote:
> Hi Krishna,
>
> Apply conditional formatting based on text in a cell. This technique
> will 100 % work as per your expectation.
>
> On 1/2/23, Krishna Bodawala wrote:
>> Hello members,
>>
>> Happy New Year to all.
>> I have a small
Hi Krishna,
Apply conditional formatting based on text in a cell. This technique
will 100 % work as per your expectation.
On 1/2/23, Krishna Bodawala wrote:
> Hello members,
>
> Happy New Year to all.
> I have a small query regarding Excel.
> I am working in sheet, where the column have red,
Hello sir,
I don’t want to apply filters. The sheet already contains cell highlighted in
red, green, and orange colour. I need only those cells which are highlighted
green, so how can I eliminate the other cells which are not used to me.
I know the Keystroke insert plus F to check the font
Hello sir,
You can apply the color filter for this.
To check the color you can keep the focus on the particular cell and
press insert alfa numeric 5 and accordingly you will be apply the
filter for the particular color.
On 1/2/23, Krishna Bodawala wrote:
> Hello members,
>
> Happy New Year to
Hello members,
Happy New Year to all.
I have a small query regarding Excel.
I am working in sheet, where the column have red, green, orange highlighted
cels. I need only the cells which are green highlighted, how can I eliminate
the other cels row which are highlighted Red?
Sincerely,
vlookup has four arguments.
1. first argument you have to give which column you have to use for
searching similar value in other database.
2. second argument is the row and column range of the destination data
sheet in excel.
3. third argument is after finding the exact match, what related
record
I would be thankful if you along with other list members can help me
in learning v. look-up feature through which one can make various
comparison in data base...
On 3/12/16, Himanshu Sahu wrote:
> Dear Zujar,
> Again you hit bulls eye, as usual!!!
> It works
Dear Zujar,
Again you hit bulls eye, as usual!!!
It works perfectly...
Now, please tell me how to remove this setting from the workbook/sheet?
And is their any permanent solution so that all excel documents I work
upon, should have this reading option by default?
On 3/12/16, Zujar Shabbir
go to the headers columns where headings are available.
press insert+shift+c and insert+shift+r
On 3/12/16, Himanshu Sahu wrote:
> Dear All,
> Many thanks for your valuable guidance.
> I've been able to perform series function now but my other query is
> still
I believe you're looking for column headings and row titles. Open the
workbook and perform the following:
1. Place the cursor on the row that contains column headings. For
example, row #1, row #5, etc. You may select multiple rows too.
2. Press CTRL+ALT+INSERT+C.
3. Place the cursor in the column
Dear All,
Many thanks for your valuable guidance.
I've been able to perform series function now but my other query is
still unresolved.
I had asked:
"How to instruct JAWS to read row and column heading while moving
through all row and columns respectively in a sheet?"
I meant to say that if I am
Hi friend,
Just to share in continuation in what Nidhi has just shared.
In a cell type 1 and select the cells by holding the shift key and
down or right arrow. Then press Alt + e i s and then a dialogue box
would come and in that step value 1 would appear; if you want the
common difference as 1,
On 3/12/16, Him Prasad Gautam wrote:
> For auto numbering, do
> * type 1 in that cell from which you want to have auto numbering begin.
> * move one cell down.
> * type the equal sign.
> * press up arrow.
> * type plus sign and 1
> * press enter.
> * Copy the cell
For auto numbering, do
* type 1 in that cell from which you want to have auto numbering begin.
* move one cell down.
* type the equal sign.
* press up arrow.
* type plus sign and 1
* press enter.
* Copy the cell (press control + c)
* paste the formula up to that range you want to have auto
Hi,
perhaps the commands are:
insert + shift + alt + c or r, respectively.
Sent with AquaMail for Android
http://www.aqua-mail.com
On March 11, 2016 9:37:58 PM Aravind R wrote:
go to the column and row where headers are placed.
press insert+shift+c for setting
go to the column and row where headers are placed.
press insert+shift+c for setting them as column title and press
insert+shift+r for setting row title.
On 3/11/16, Himanshu Sahu wrote:
> Friends,
> Please guide me step by step for execution of following tasks in
Friends,
Please guide me step by step for execution of following tasks in excel:
1. How to instruct JAWS to read row and column heading while moving
through all row and columns respectively in a sheet?
2. How to insert auto serial Numbers in cells?
I am using JAWS 13 and office 7.
Thank you. Got it.
Sent with AquaMail for Android
http://www.aqua-mail.com
On February 21, 2016 7:32:15 PM Zujar Shabbir Kanchwala
wrote:
Hi,
Probably, the cell is formatted to display 1 decimal place. You may
check the format in the Format Cells dialog box under
Hi,
Probably, the cell is formatted to display 1 decimal place. You may
check the format in the Format Cells dialog box under the Number tab.
If the Category list box shows 'Number' and Decimal Places edit combo
box displays 1 then you may want to change this to either of the
following:
1.
Hello Accessindians, greetings of the day.
I am facing a strange issue with excel. excel automatically rounds off
the figures in some cells. for example, 6.18 automatically becomes 6.2
or 13.39 becomes 13.4. i have not inserted any formula to round off
the figures. i tried to edit the figure but
Subject: [AI] Excel query
Hello friends,
I have a problem in the following formula. Please suggest correction.
If cell ‘r8’ equals “cl” the value of cell ‘o8’ should come in cell ‘i8’
automatically by formula.
Thank you.
Regards
Mukesh Baviskar
Mobile: 9403161157
Skype id: mukeshbaviskar
Blog
Hello friends,
I have a problem in the following formula. Please suggest correction.
If cell ‘r8’ equals “cl” the value of cell ‘o8’ should come in cell ‘i8’
automatically by formula.
Thank you.
Regards
Mukesh Baviskar
Mobile: 9403161157
Skype id: mukeshbaviskar
Blog:
Hello Friends,
I have created a leave register and required a macro coding/formula to get the
appropriate remark in remark column. My query is as follows:
column ‘a2’ leave credited
column ‘d’ days required
column ‘f’ remark
Result condition:
If days required are leave credited the remark
=IF(A2 = D2, CONCATENATE(Sanctioned - days with pay(, A2, )),
CONCATENATE(Sanctioned - days without pay (, D2 - A2, )))
On 3/30/13, Mukesh mukeshbaviskar@gmail.com wrote:
Hello Friends,
I have created a leave register and required a macro coding/formula to get
the appropriate remark in
Hi all,
I have an excel sheet with the details of my contacts from all across the
country. The sheet has two columns - District and State. The state column is a
dropdown list and I want to make the District column also a dropdown list. My
requirement is that when I select one state, the list
] On Behalf Of Vamshi. G
Sent: Wednesday, February 09, 2011 8:32 PM
To: accessindia
Subject: [AI] Excel query, very urgent
Hi friends,
When I copy a cell which has a sum formula and paste it in another
sheet, Jaws is saying number ref instead of the actual number. I
want the actual number to be pasted
Hi friends,
When I copy a cell which has a sum formula and paste it in another
sheet, Jaws is saying number ref instead of the actual number. I
want the actual number to be pasted.
Guidance required very urgently.
--
G. Vamshi
PH Res : +91 877-2243861
Mobile: +91 9949349497
E-mail ID:
are likely
to get this error.
Geetha
- Original Message -
From: Vamshi. G gvamsh...@gmail.com
To: accessindia accessindia@accessindia.org.in
Sent: Wednesday, February 09, 2011 3:02 PM
Subject: [AI] Excel query, very urgent
Hi friends,
When I copy a cell which has a sum formula
: Vamshi. G gvamsh...@gmail.com
Sent: Wednesday, February 09, 2011 8:32 PM
To: accessindia accessindia@accessindia.org.in
Subject: [AI] Excel query, very urgent
Hi friends,
When I copy a cell which has a sum formula and paste it in another
sheet, Jaws is saying number ref instead of the actual
address will never change, where
ever you copy.
I hope this will help you.
regards
- Original Message -
From: Vikas Kapoor [EMAIL PROTECTED]
To: accessindia@accessindia.org.in
Sent: Sunday, July 09, 2006 12:30 AM
Subject: Re: [AI] EXCEL QUERY
Thanks Sameer once again but this didn't solve
Dear Members,
I know here on this list there are many excel specialists. Though I don't have
any mastery over excel, I use this application for a very limited purposes like
preparing the internal assessment for my college students and I find it very
useful for this purpose. I just wanted to
ID:
[EMAIL PROTECTED]
Yahoo ID:
[EMAIL PROTECTED]
Skype ID: dl_vikas
Mobile: (+91) 9891098137.
- Original Message -
From: ajay sharma [EMAIL PROTECTED]
To: accessindia@accessindia.org.in
Sent: Saturday, July 08, 2006 5:38 PM
Subject: Re: [AI] EXCEL QUERY
hi vikas myself ajay
: (+91) 9891098137.
- Original Message -
From: sameer latey [EMAIL PROTECTED]
To: accessindia@accessindia.org.in
Sent: Saturday, July 08, 2006 10:31 PM
Subject: Re: [AI] EXCEL QUERY
Try the following to copy and paste the same formula
in multiple cells.
1. Place your focus
!
Regards,
Vikas Kapoor,
MSN ID:
[EMAIL PROTECTED]
Yahoo ID:
[EMAIL PROTECTED]
Skype ID: dl_vikas
Mobile: (+91) 9891098137.
- Original Message -
From: sameer latey [EMAIL PROTECTED]
To: accessindia@accessindia.org.in
Sent: Saturday, July 08, 2006 10:31 PM
Subject: Re: [AI] EXCEL QUERY
35 matches
Mail list logo