Easy Office
LCI Learning

Ask any queries related to excel

Page no : 2

karan (ca final) (55 Points)
Replied 10 August 2011

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



satya (Executive Excise) (1839 Points)
Replied 10 August 2011

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.


JMD (STUDENT) (563 Points)
Replied 13 December 2011

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?

 



(Guest)

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


Exshail (Software) (1576 Points)
Replied 15 December 2011

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.

 




Exshail (Software) (1576 Points)
Replied 15 December 2011

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
 


JMD (STUDENT) (563 Points)
Replied 16 December 2011

this is not working.

kindly be serious...

 


Exshail (Software) (1576 Points)
Replied 16 December 2011

Originally posted by : JMD

this is not working.

kindly be serious...

 


see attached file.


Attached File : 58368 887806 time difference.xls downloaded: 122 times

Prashant (Accountant) (90 Points)
Replied 31 December 2011

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


Ram kr. (Buisness) (883 Points)
Replied 25 January 2012

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




Exshail (Software) (1576 Points)
Replied 25 January 2012

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


Ram kr. (Buisness) (883 Points)
Replied 27 January 2012

Excelent.

Thanks


Ram kr. (Buisness) (883 Points)
Replied 27 January 2012

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.


Ram kr. (Buisness) (883 Points)
Replied 28 January 2012

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. 

 





Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Join CCI Pro


Subscribe to the latest topics :

Search Forum: