Tanu (Accountant) (767 Points)
20 October 2010Dear frnz,
somebody has hidden some starting rows in my excel sheet but these are showing while seeing print preview. tell me from where these could be correct.
n second one negative amount showing highlighted while i fill no color in that cell. i looked fomat features but cudnt find any relevant option.
please guide me.
ANCHAL
(a)
(30 Points)
Replied 20 October 2010
OPEN FILE - GO TO PAGE SETUP- GO TO SHEET TAB- CLICK ROW AND COLUMN HEADING.
II GO TO FORMAT - CONDITINAL FORMATING
Tanu
(Accountant)
(767 Points)
Replied 20 October 2010
IInd option worked, but first problem is still same. There is no setting in Sheet menu. I've checked already.
Thanx for help
Bhavin Bhadra
(Job)
(174 Points)
Replied 20 October 2010
Dear Tanu,
To open hidden raw do the following steps.
Open sheet,
Press Ctrl +A (Select All)
then go to format menu, select row option and then select unhide.
Sukanya
(Professional)
(550 Points)
Replied 20 October 2010
Hi tanu,
When problems like these crop up, first try to finish your task and then experiment with excel.
You need to be smart.
First copy the required cells for printing in a different sheet and then do formatting there, and take a print out.
Another option is that you can set the print area and avoid all the problems you are facing.
Go to file-print - set print area.
After ur print is taken, go to Tools - options - there will be options for deactivating hidden cells for print. You can do it...
When you are free, try to learn these nuances by trial and error, otherwise we cannot learn excel .
ALL THE BEST!!!!
Tanu
(Accountant)
(767 Points)
Replied 21 October 2010
thanx a lot both of u
and Sukanya again thanx for guiding for future.
Byeeee...........
and keep smiling...................:)
Landmark Judgments: Important Provisions of the EPF & ESI Act interpreted by the Honorable Supreme Court of India
CAclubindia
