Re: [AI] Excel query

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

Re: [AI] Excel query

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

Re: [AI] Excel query

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,

Re: [AI] Excel query

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

Re: [AI] Excel query

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

[AI] Excel query

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,

Re: [AI] Excel Query

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

Re: [AI] Excel Query

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

Re: [AI] Excel Query

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

Re: [AI] Excel Query

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

Re: [AI] Excel Query

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

Re: [AI] Excel Query

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

Re: [AI] Excel Query

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,

Re: [AI] Excel Query

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

Re: [AI] Excel Query

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

Re: [AI] Excel Query

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

Re: [AI] Excel Query

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

[AI] Excel Query

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.

Re: [AI] excel query.

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

Re: [AI] excel query.

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.

[AI] excel query.

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

Re: [AI] Excel query

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

[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:

[AI] Excel query

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

Re: [AI] Excel query

=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

[AI] Excel query

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

Re: [AI] Excel query, very urgent

] 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

[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. Guidance required very urgently. -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID:

Re: [AI] Excel query, very urgent

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

Re: [AI] Excel query, very urgent

: 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

Re: [AI] EXCEL QUERY

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

[AI] EXCEL QUERY

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

Re: [AI] EXCEL QUERY

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

Re: [AI] EXCEL QUERY

: (+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

Re: [AI] EXCEL QUERY

! 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