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

Upgrade to CAclubindia Pro. Subscribe Now!

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.

Upgrade to CAclubindia Pro. Subscribe Now!

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: 253 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.

Upgrade to CAclubindia Pro. Subscribe Now!

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.