Ask any queries related to excel

my query is not specific to excel..

how do u print  a doc on priority basis.i mean how to give preference to a doc so that the print of the user is executed on priority basis and other prints of other users comes later.plz reply

Dear Experts,

Please tell me, If we select our data of some pages in Excel, it gives default PAGE NUMBERS i.e., 1 to ......., How to put desired page number for starting page ? say 1- 6 pages is default setting, I want to be print of page numbers from 50 to 56. Is there any solution for this?

THANKS IN ADVANCE.

Whether we can calculate time diffrence in folowing condition:

cell1(A.M)         cell2(P.M)         cell3 (difference)

10.15               4.30                          ???

answer should either be 375 minutes, 6 hrs and  15mins or 6.25 or 6:15

which formula could be used here?

good keep sharing...........

Originally posted by : sathya
	Dear Experts, Please tell me, If we select our data of some pages in Excel, it gives default PAGE NUMBERS i.e., 1 to ......., How to put desired page number for starting page ? say 1- 6 pages is default setting, I want to be print of page numbers from 50 to 56. Is there any solution for this? THANKS IN ADVANCE.

In Pagebreak Preview mode you can know the page no. of your selected page, so while printing enter page no. start from & to.

Originally posted by : JMD
	Whether we can calculate time diffrence in folowing condition:   cell1(A.M)         cell2(P.M)         cell3 (difference) 10.15               4.30                          ??? answer should either be 375 minutes, 6 hrs and  15mins or 6.25 or 6:15 which formula could be used here?

substraction formula in cell3.

=cell2-cell1
 

this is not working.

kindly be serious...

Originally posted by : JMD
	this is not working. kindly be serious...

see attached file.

Please tell me how to protect folder with password in MS Excell

We can move one linked  one sheet to another sheet by short cut key ctrl+[  but how will we move reverse back previous sheet.

Originally posted by : Ram kr.
	We can move one linked  one sheet to another sheet by short cut key ctrl+[  but how will we move reverse back previous sheet.

Press {F5} {Enter}.

Excelent.

Thanks

I want to find number like inv no. 12536 and date   in various column which is not fixed some where it is right, mid and left. I want to seperate a one command.

1. we use in audit tool (Trace precedent) then only linked sheet symbole  is desplay. i want to see sheet name alongwith sheet symbole.2. we have export a file in  excel format without grid line. how can we convert into normal excel file with lining/grid line.