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...
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
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"
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...
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.
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...