Excel 2007 / Excel 2010 – Print area greyed out

I had a user today that needed Microsoft 2007 Excel help. She was unable to print an Excel spreadsheet correctly. After some questioning and watching the user flow through her process, I noticed something interesting. She was unable to print the data in the sheet tabs at the bottom of her spreadsheet. I went to Page setup then the Sheet tab. The Print area section was greyed out. A few Google searches later, I found the answer. Here’s how I resolved her Excel problem.

 

Select Clear Print Area (click image to see full size)

Select the below arrow (click image to see full size)

Select the appropriate area you desire to print (click image to see full size)

Leave a Reply

Your email address will not be published. Required fields are marked *