Re: [AI] Need help in MS excel
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 > 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 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 >> 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 -45 > > -- > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking o
RE: [AI] Need help in MS excel
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 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 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 -45 -- 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.
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 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 -45 -- 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.
[AI] Need help in MS excel
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.
