Sure deepak ji, you can reach me out on +91 7666206653 on sunday Sent from my iPhone
> On 06-Apr-2023, at 23:48, deepakarora_07 via AccessIndia > <accessindia@accessindia.org.in> wrote: > > Thank you for your response! > But i'm still unable to understand the step for filtering the dates column so > it would be great help if we can talk over phone tomorrow or day after > tomorrow as per your availability so that I can understand it better. > > > Thanks & Regards, > Deepak > > -----Original Message----- > From: accessindia@accessindia.org.in <accessindia@accessindia.org.in> On > Behalf Of Khandu Bhandare > Sent: Thursday, April 6, 2023 5:36 PM > To: accessindia@accessindia.org.in > Subject: Re: [AI] Need help in MS excel > > Sure, I can help with these Excel issues you are experiencing. > > For filtering the data, Excel may not announce that a field has a drop-down > list when you navigate to the column. However, you can still access the > drop-down list by pressing Alt+Down arrow key once you are in the column. > This should open the filter drop-down list and allow you to filter the data > as needed. > > To use the "TRUE or FALSE" formula in Excel, you can follow these steps: > > Select the cell where you want to enter the formula. > Type the equals sign (=) to start entering the formula. > Type "TRUE" or "FALSE" (without the quotes) to enter the desired value. > Press Enter to confirm the formula and complete the entry. > When you move left or right to select the cell, NVDA may not announce the > cell's content or position. To verify the selected column, you can try to > navigate to the column's header or press the arrow keys to move to the next > or previous cell to confirm the selection. rather you may mention the cell > address whichever is required. > > To filter on a column with dates in Excel, follow these steps: > Select the column containing the dates you want to filter. > Press Alt+H then F then S then F to open the filter dialog box. > In the filter dialog box, select the drop-down list for the column containing > dates and choose the date filtering option you want to use. > Select the date range or specific dates you want to filter. > Press Alt+A to apply the filter and close the dialog box. > I hope this helps! Let me know if you have any other questions. > >> On 4/6/23, deepakarora_07 via AccessIndia <accessindia@accessindia.org.in> >> wrote: >> Hi All, >> >> >> >> Greetings for the day! >> >> >> >> I'm using MS excel with NVDA and facing some issues so need your help >> in below points; >> >> >> >> 1. For filtering the data, I use "alt+D+F+F" or " control+shift+L" but >> when I go to applied column, it does not announce that "this field has >> drop down" >> 2. When I want to use "True or False" formula and I press "=", it says >> nothing else than edit and also when I move right or left to select >> the cell it does not announce anything so how can I verify that which >> column is selected. >> 3. How we can filter on column with dates if someone please can help me >> step by step. >> >> Thanks & Regards, >> >> Deepak >> >> >> >> -- >> Disclaimer: >> 1. Contents of the mails, factual, or otherwise, reflect the thinking >> of the person sending the mail and AI in no way relates itself to its >> veracity; >> >> 2. AI cannot be held liable for any commission/omission based on the >> mails sent through this mailing list.. >> >> >> Search for old postings at: >> http://www.mail-archive.com/accessindia@accessindia.org.in/ >> --- >> You received this message because you are subscribed to the Google >> Groups "AccessIndia" group. >> To unsubscribe from this group and stop receiving emails from it, send >> an email to accessindia+unsubscr...@accessindia.org.in. >> To view this discussion on the web visit >> https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/002901d9687e%242db56190%24892024b0%24%40yahoo.co.in. >> > > > -- > “challenge the challenges!” > > Regards, > Khandu Bhandare| > Assistant Manager/Special Trainer|Centre of Excellence for persons with > disabilities > M: +91 7666206653 > kha...@sbifoundation.co.in,khandu.bhand...@sbi.co.in,bhandarekhand...@gmail.com > www.sbifoundation.in > SBI Foundation | Service Beyond Banking... > > 35, Ground Floor, The Arcade, World Trade Centre, Cuffe Parade, Mumbai -400005 > > -- > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > --- > You received this message because you are subscribed to the Google Groups > "AccessIndia" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to accessindia+unsubscr...@accessindia.org.in. > To view this discussion on the web visit > https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CA%2BkFfrqtgq%3D1BCfgQL6HMy2-p4J-8xt-3LOQfQyh32jugi51KA%40mail.gmail.com. > > -- > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > --- > You received this message because you are subscribed to the Google Groups > "AccessIndia" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to accessindia+unsubscr...@accessindia.org.in. > To view this discussion on the web visit > https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/005d01d968b4%2430845080%24918cf180%24%40yahoo.co.in. -- Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ --- You received this message because you are subscribed to the Google Groups "AccessIndia" group. To unsubscribe from this group and stop receiving emails from it, send an email to accessindia+unsubscr...@accessindia.org.in. To view this discussion on the web visit https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CA003D0A-D3FB-47DE-957C-695BB79B1951%40gmail.com.