Microsoft Excel Question:
Download Questions PDF

I am using Excel and I want to print only the bottom of the worksheet. There is not an option to do this in the print dialog box. How can this be done?

This can be accomplished by highlighting the area to be printed. Then go to File, print area, set print area, this will print only what is selected.

Download MS Excel Interview Questions And Answers PDF

Previous Question	Next Question
I am using Excel, and want to create a line graph with the data on my spreadsheet, ranging from January to December. However, I don not want the empty cells to be represented as zeroes in the line graph. Is there a way to graph all months without displaying the zero values?	How do I clear all formatting and cell contents from the cell in my spreadsheet?