Skip to main content

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!


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

Post a Comment

Popular posts from this blog

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them. 
To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs. 

I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side. 

You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom. 

EffectCheat CodeAdrenaline ModeMUNASEFAll Cars ExplodeALLCARSGOBOOMAll Cars Have NitroCOXEFGU or SPEEDFREAKAll Green LightsZEII…

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!!






About the Activator Name: KMSPico 10.1.5File Size: 3 MB (Approx)File Type: Zipped Folder100% Neat & Clean - No virus!

Activating Capacity . . .
KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010Windows 10, 8.1 & 8Hopefully this version will work for both 32 bit & 64 bit versions of Windows.








Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else.Install it as trial version without any key.Use the following activator . . .

Download > Install > Enjoy . . . Get the file from here. The first link i…

Office 2010 Activator (KMS) !!

Day by day cracking has been a tough job. But yet very possible. Earlier a software may require only serial key to activate. But today there are many other options. Sometimes you might be asked to connect to the internet to activate or sometimes you're asked to make a phone call! 






Microsoft Office 2010 has the same problem. It is not simply activated by the CD key. Sometimes CD key may not be asked during the installation process. If you're required to enter serial then try any of the following:



YF79C-7Y4B4-PGM89-6BKGJ-46PBT

FC7HF-CF42G-MX6D7-8K9T7-BT9QT

2PWHY-KT4X6-96PYW-XQR7V-HW2W9
PYMDW-8DFY2-Y68BB-XHDGD-CT443
7XD2X-JWJ94-BCHBW-W9WXP-J2WPT
P6RW8-B8X84-FFK73-4BPWM-KRHX3


After installing a trial version of Office 2010 you're allowed to use it for 30 days only. After that it will ruin your peace. It will give you continuous love messages each time you start office. Today I'm gonna share an activator by which you can activate Office 2010 and stop unwanted love messages by MS Of…

Office 2013 Activator (KMSpico 10.1.5)

KMSpico 9.1.3 is really an amazing tool for activating Office 2013. And as a bonus, you can also activate Windows 8 or 8.1 with this activator. Earlier I shared different activators for Office and Windows. And those activators are working fine. If you can't activate your Office or Windows by those activators, then you can try this one. 





I've got Microsoft Office Professional Plus 2013 (final version) last week. And before that I was using Office 2010. After installing Office 2013, I was unable to use it before activating. And with this KMSpico 9.1.3 my Office gets activated within minutes. It's very easy to use! 






Furthermore, this KMS is capable of activating -  Windows 8 and 8.1 (All Versions) Windows Vista and 7 (Business, Professional & Enterprise Edition)Office 2010 and 2013Windows Server 2008/2008R2Windows Server 2012/2012R2

Activation Procedure: Download the KMSpico 10.1.5 from Here.Now double click on it. And follow the manual include inside.Press Next > Accept ter…

IDM 7.2 Portable Free Download!!

There is nothing new to tell about Internet Download Manager (IDM). Most of you are familiar with this amazing download accelerator. But still people look for the cracked version of IDM. Version changes over time. And people try to get the new activated version. Today I'm gonna share IDM 7.2 (Portable) with you! 

Before I begin, I should declare that this is not a registered version of IDM actually. But the settings of this IDM are modified. You don't need to upgrade or register this version. After 30 days, you will not get the notifications to upgrade. And you will enjoy all the advantages just like a registered version. 
But there is nothing to worry about. You can download this portable version of IDM without hesitation. It's just 4.7 MB. You don't need to install it. This version will never demand serial from you. And the download link is 100% free from ads, spams or malware.


Downlaod IDM 7.2 Portable either from Link 1 or Link 2. Unzip the folder and move it to your …

Download GTA Vice City Cheat Codes (PDF)

Couple of years ago, GTA Vice City was one of the most popular game. GTA games are always preferred by the gamers. Most of the GTA games like Vicy City, Liberty City, San Andreas have cheat codes. With these cheat codes, you can complete missions easily. When something is very difficult to perform normally, you can use cheats. 

Here I'm gonna share 32 selected cheats with you. I've omitted the unnecessary cheats. And these cheats are also applicable for GTA Liberty City!


Press any of the below cheats while playing the game. The right part of the table contains the cheats and the left part contains the results. 

Effect
Cheat Code All Cars are FasterGet There FastArmorPrecious ProtectionBetter Driving SkillGrip is EverythingCaddyBetter Than WalkingCars Float on WaterSea WaysCars FlyAirshipCars FlyingCome Fly With MeClear Wanted LevelLeave Me AloneCommit SuicideI cant take it any moreDestroy All CarsBig BangFast CarGet There QuicklyFaster Game ClockLife is passing me byFaster Game Pla…

Disable Automatic Update in Windows 10

As I mentioned earlier, Windows 10 has come with some boring changes. One of the stupid changes is related to Automatic Update. In Windows 10, you're set to automatically install new updates. And you've no choice to change this settings. Because the change settings option is disable. 


Applies to: Windows 10




Disable Automatic Update (Final Edition)



When you Disable Automatic Update?

If your net bandwidth is limitedIf you don't need windows updates at allIf the updates cause activators not work in your PC
In earlier versions of Windows (Windows 7, 8 or 8.1), you can manually configure the update settings. There were four settings: Install updates automaticallyDownload updates but let me choose whether to install themCheck for updates but let me choose . . . Never check for updates
In Windows 10, you don't have any option to choose any of these settings. It's simply disabled. You can't use the drop down menu. Look at the image below:




But still you have a chance to configu…