Beginners are usually scared while printing from Microsoft Excel. They face problem when setting up page or margin. I had the same problem few years ago. Remember, when you can't do something, never give up. Try to do it with care. You will learn through mistake. I've just wasted some papers to understand which option does what. And thus I learned how to print excel workbook properly . . . :)
In this post, I'm gonna discuss about Page Setup, Margin and Print option of Microsoft Excel. Since I'm using version 2010, it will difficult for me to show the related screenshots of 2003 and 2007. But I will try to make it clear for the users of previous versions.
Microsoft Excel 2003:
Before I begin, I'd like to say you, upgrade to Office 2010. This is really an amazing version of Microsoft Office. If you're still using 2003 or 2007, you're just missing the magic! Okay let's start -
Page Setup: You should set up your page properly to print a workbook. Otherwise you may get the wrong output. Some lines of your workbook might be missing.
Find the Page Setup option from the File menu. Now go to the Page tab. Set your Orientation - Portrait or Landscape. Choose Paper Size - A4/ Letter/ Legal as your need.
Now move to the Margin tab. Set your margin for Top, Bottom, Left & Right. Then hit OK.
Look at your workbook. Now you will be able to see the boundary of your workbook. Each page will have a boundary. If any part of your workbook is out of this boundary, it will be printed in the next page. So, if you need to adjust your text, you must follow this boundary. If a minor portion of your workbook is out of this boundary, you can reduce your margin to increase the printing area.
Print: Look at the image below:
Print Range: If you choose All, everything in the current workbook will be printed. Nobody usually do so. We will use the Print What option. If you need to print a particular part of your workbook, just select it. Then press Ctrl + P and Choose Selection. Hit on the OK button.
If you can manage to set your contents in a single page (within a boundary) then you can go to the Print Range option. Then select Page(s) box. Type 1 to 1 in the From and To box. Hit OK. That's it.
Microsoft Excel 2007 & 2010:
Except some new features, Office 2007 and 2010 have got almost similar interface. Page setup and printing option is almost same in both versions. I guess you all are able to set up page and margin in Excel.
In ribbon interface, you will get the Page Setup option under Page Layout Tab. Click at the right bottom corner to get the Page Setup Dialogue box. Now set up page and margin as you need.
Print: Look at the image below to set up the print options:
Though the interface is quite different from that of Excel 2003, the options are almost similar. You can choose Active Sheet or Selection or Page Range. Nothing is confusing. You can get this dialogue options by pressing Ctrl + P. And these options are same in both 2007 and 2010.
If you wanna print a particular part of your workbook, just select that part and then press Ctrl + P > Choose Selection > Print.
What's New in Excel 2010?
At the beginning, I said you're missing magic! What's this? I'm sharing a little example with you. In 2010, you have the Page Layout View like Word!
You know what is page layout view? Or can you guess? Excel 2010 lets you divide your sheet into different pages. This is somewhat similar to the pages of MS Word. If you divide your sheet into pages, you will never be confused while printing a document! Look at the image below to do it:
When you run Excel, the default mode is Normal. To activate the page layout option, you have to go to the right bottom corner. There you will get the zoom option. And just left to the zoom option, you will get Normal, Page Layout and Page Break Preview button. The middle button is Page Layout.
Page Setup: You should set up your page properly to print a workbook. Otherwise you may get the wrong output. Some lines of your workbook might be missing.
Find the Page Setup option from the File menu. Now go to the Page tab. Set your Orientation - Portrait or Landscape. Choose Paper Size - A4/ Letter/ Legal as your need.
Now move to the Margin tab. Set your margin for Top, Bottom, Left & Right. Then hit OK.
Look at your workbook. Now you will be able to see the boundary of your workbook. Each page will have a boundary. If any part of your workbook is out of this boundary, it will be printed in the next page. So, if you need to adjust your text, you must follow this boundary. If a minor portion of your workbook is out of this boundary, you can reduce your margin to increase the printing area.
Print: Look at the image below:
Print Range: If you choose All, everything in the current workbook will be printed. Nobody usually do so. We will use the Print What option. If you need to print a particular part of your workbook, just select it. Then press Ctrl + P and Choose Selection. Hit on the OK button.
If you can manage to set your contents in a single page (within a boundary) then you can go to the Print Range option. Then select Page(s) box. Type 1 to 1 in the From and To box. Hit OK. That's it.
Microsoft Excel 2007 & 2010:
Except some new features, Office 2007 and 2010 have got almost similar interface. Page setup and printing option is almost same in both versions. I guess you all are able to set up page and margin in Excel.
In ribbon interface, you will get the Page Setup option under Page Layout Tab. Click at the right bottom corner to get the Page Setup Dialogue box. Now set up page and margin as you need.
Print: Look at the image below to set up the print options:
Though the interface is quite different from that of Excel 2003, the options are almost similar. You can choose Active Sheet or Selection or Page Range. Nothing is confusing. You can get this dialogue options by pressing Ctrl + P. And these options are same in both 2007 and 2010.
If you wanna print a particular part of your workbook, just select that part and then press Ctrl + P > Choose Selection > Print.
What's New in Excel 2010?
At the beginning, I said you're missing magic! What's this? I'm sharing a little example with you. In 2010, you have the Page Layout View like Word!
You know what is page layout view? Or can you guess? Excel 2010 lets you divide your sheet into different pages. This is somewhat similar to the pages of MS Word. If you divide your sheet into pages, you will never be confused while printing a document! Look at the image below to do it:
When you run Excel, the default mode is Normal. To activate the page layout option, you have to go to the right bottom corner. There you will get the zoom option. And just left to the zoom option, you will get Normal, Page Layout and Page Break Preview button. The middle button is Page Layout.
if you don't mind could i ask one Question?
ReplyDeletewhy are you stop country redirection?
My GOD! Have you noticed this?!
DeleteThe answer is - to keep the loading time minimum. It slows down site by 1 or 2 second.
You could ask this question in here - Disable Blogger Redirection. :)
Use the search option to find any post. Thanks for staying with Marks PC . . .
thanks Andur
DeleteI want to tell you
I read your post Disable Blogger Redirection then apply on my blog
benefit: -
increase viewers
increase adsene income (first time cross 10$ and above per day)
increase my global alexa Rank
thanks but i am surprise you discontinue this script.
sorry your name is wrong type from me Abdur
DeleteI really dislike the redirection. But I give importance to the speed first. If you visit my site and get it slow, this hurts me a lot :)
DeleteI don't use unnecessary gadgets in my site you know. But using this script has many advantages. I will try to purchase a domain so that it doesn't redirect :)
but i don't feel speed problem in my blog
Deleteand i am already try custom domain but adsense not approve upgrade requites
so back to blogger
Hmm . . . Custom domain has some problems. Sometimes your host might not work properly. But blogger will be active always.
Delete