Subscriber Bernie wrote to ask:
can you tell me How to Print an Excel Sheet? Thanks
Such a huge, open-ended question…
I wasn’t sure whether he was a beginning Excel user who didn’t know how to print, or one who had upgraded to a newer version that hides the menu bar, or what.
So, I answered with a simple method to print the spreadsheet:
Press and release the Alt key — this will display the menu bar.
Select File, then Print
With Excel 2007, instead of pressing and releasing the Alt key, you can click on the Office "Orb" at the top left corner of the Excel window, and select Print.
Bernie wrote back to report on his efforts. Fortunately, he gave some more info this time:
First of all, let me thank you for such a fast reply.
I did your steps. Opened Excel to a blank spreadsheet.
The Alt key highlighted "FILE" not menu bar. Selected File and print
and I got a Plain blank sheet from my Printer!
If you have the time, what would you suggest me to do?
Again Terry, thanks so much. Bernie
Apparently his menu bar wasn’t hidden (although I still don’t know which version of Excel he’s using), so the Alt key wasn’t needed (Excel 2007 hides the menu bar by default, as do many current Windows programs.
Well, the first thing I notice from his email is that he opened a blank spreadsheet. He doesn’t mention entering anything into the spreadsheet nor opening an existing spreadsheet. So, if he tried to print a blank spreadsheet, that’s what he printed — a blank piece of paper.
Assuming that Bernie actually entered some data in some of the spreadsheet cells, or opened an existing spreadsheet after first opening Excel, his blank printed sheet is from a different problem.
In Excel, there are two print functions that can get you into trouble and out of trouble. Apparently, they’ve gotten Bernie into trouble.
The functions are Set Print Area and Clear Print Area. They’ve moved around a bit in Excel’s menu structure. On the Windows 7 Ribbon interface, they’re found on the Page Layout Tab. Click on the Print Area menu icon and you’ll see the two functions.
If that’s not where they’re located in your Excel version (or if you’re using another spreadsheet program and looking for similar functions), you can check the program’s built-in Help function to help you locate the Set and Clear Print Area menu bar entries.
By default, Excel will print the currently used range of rows & columns in the current Sheet of the Excel workbook. Set Print Area is used to select a smaller range/portion of the spreadsheet for printing.
It sounds like Bernie’s spreadsheet has a blank section of the spreadsheet selected for printing. He needs to use the Clear Print Area function.
Then, he can either print the full spreadsheet or use Set Print Area to print only the part ge wants to print.
To use Set Print Area, you select/highlight the portion of spreadsheet you want to print, then click on Print Area, Set Print Area, and then File, Print.