Search results

hi all, i want to hide a part of text in excel cell. for example , say i type ----abc xyz, i dont't want xyz to be visible in the sheet. how can this be done thanks in advance

dear all, I want a hyperlink in excel to a file which will open the file location and select the file but not open it. After doing some searching on google I am able to achieve this using---------------- explorer.exe /select,"C:\Folder\subfolder\file.txt" . But here I have to paste this on file...

dear all, i want to find sum of the numbers that are coming before "*" i.e 2*50+7*60+4*45. here i need sum of 2,7,4. what can be the formula. thanks and rgds

dear all, say i have written 4*96+3*94 in a cell A1. I want the value of this in another cell say B1 by using A1. what formula can i use in B1 to get the result. thanks and regards

Dear all, I want to customise the size of excel window when i use restore down button so that whenever i use it , i get the set size. How can this be done

dear all, i have made selection of some non continuous rows in excel using f8 / shift f8 (or shift/control). but when i am pasting it in word all rows in between are also getting pasted. How can i paste my selection in word

hi all, I want to format a cell in such a way that if i type 45 M in the cell , the outcome should be 45 kg / M

dear all. how can i use conditional formatting from different workbook in excel 2016. I have tried using name range but i am getting this message "You may not use references to otherwork books for conditional formatting criteria"

dear all, I want to copy paste a part of excel in a comment. I am doing this by copying the part of excel and pasting this in comment using clipboard. But i am not getting the format of excel (for example: the border lines). As a result the copied part is messy. Is there a way to copy the excel...

Dear all, I have an "m x n" table containing numbers, If I select a number from this table , I want the top of row and column of the number to be highlighted. How can we do this using conditional formatting.

dear all. Is there any way by which if I type 12045 in a cell , the outcome is 12 ft X 45 inches. Last three digits should come in inches and if it is 045 than the result displayed should be 45 inches. Some other examples 12345 should be displayed as 12 ft X 345 inches 23045 should be...

dear all, I want to count the unique values satisfying 2 critera. eg ref no date item 2 01-02-2016 abc 3 01-02-2016 xyz 7 02-02-2016 abc 2 04-03-2016 abc 2 04-03-2016 xyz 7 05-03-2016 abc 3 07-03-2016 xyz here ref no. and date should be unique . so total...

hi all, I want a set of blank cells to give this message "no data entered". Using conditional formatting , i can colour the blank cells but i am not able to put "no data entered". Is there any way by which i can achieve this. thanks and rgds

hi , Is it possible to create pivot table from tables which are in 2 different files using microsoft query. Also I am facing an issue in my system where i am not able to refresh the pivot table created using four tables in the same file (using query). thanx and rgds

dear all , I want to replace only 0 with 2 in the below formula. =ROUND($E$247*J250,0) How can i use find and replace to achieve this the final outcome should be--- =ROUND($E$247*J250,2) thanx and rgds

dear all, how can i get comma separation when i am using formula of this type ="diff "&N2-M2 where in N2 say I have 1,52,500 and in M2 I have 11,200. the output should be ------------ diff 1,41,300 thanx and rgds

dear all. is there a short cut to move to the first row of a column. Say I am in cell G153 and I want to quicly move to G1. Also there are some cells in between G1 and G153 which are empty so cntrl + up arrow will not work. thanx and rgds

dear all, I have some data in a column which I want to paste in a filtered table in different sheet. How can this be done. thanx

dear all, say i have got following things in the cells cell a1 20 b1 X c1 40 In cell d1 i want to display 20 inch X 40 ft I can use =a1&b1&c1 in cell d1 and it gives 20X40. Further i can format cell d1 as @ "ft" and it gives 20X40ft. But is there any way where I can also get the "inch"...

dear all, I want to insert "-" (without inverted commas) in cells which are blank using conditional formatting. I am using the formula =isblank(a4) ,where say a4 is the blank cell , and putting "-" in custom number format but its not working. Same formula is working when i am putting some...

dear friends, just wanted to know why when i put equals 3000 in auto filter ,i don't get any result (shown in screenshot) but when i put greater than equal to 3000 i get the correct result thanx and rgds

dear all, is there any shortcut to toggle between function argument dialogue box and formula bar withou the use of mouse thanx and rgds

dear all, I want to insert row after there is change in a data in a column. eg name a a a c c d f g g now after "a" ends i want to put a blank row. similarly for c , d , f . g. I have searched and found vba solution. Is it possible to do this without using Vba. thanx and rgds

dear all, say i have some data on a sheet eg ajay maths 70 manoj history 80 ajay english 85 how can i get all data regarding ajay in a new sheet keeping in mind new data will keep on coming in the original sheet

hi all, one of my excel file suddenly is giving the following errror message : excel found unreadable content in ...........xlxs. Do you want to recover the contents of this workbook? what i want to know is what are unreadable content and in future how can i save my files from such error. I...