Monday, December 02, 2013

Page Setup & Printing Tips for MS Excel


MS Excel Tips by Marks PC


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.


Excel 2010 Page Setup Dialogue Box


Print: Look at the image below:


Excel 2003 Print Option


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:

Ms Excel 2010 Print Dialogue Box


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:

Excel 2010 Document View


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.


 

Stay with Marks PC Solution to get more interesting IT topics!


7 comments:

  1. if you don't mind could i ask one Question?

    why are you stop country redirection?

    ReplyDelete
    Replies
    1. My GOD! Have you noticed this?!
      The 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 . . .

      Delete
    2. thanks Andur

      I 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.

      Delete
    3. sorry your name is wrong type from me Abdur

      Delete
    4. I 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 :)

      I 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 :)

      Delete
    5. but i don't feel speed problem in my blog

      and i am already try custom domain but adsense not approve upgrade requites

      so back to blogger

      Delete
    6. Hmm . . . Custom domain has some problems. Sometimes your host might not work properly. But blogger will be active always.

      Delete