Margin settings in MSExcel

[lokeshsuhas]

Hi All,

I just got a big confusion in the margin settings.If you select the pagesetup options of the Excel sheet, you can see a margins tab in that at the top there will be two numeric text boxes one shows the "Header" and another one shows the "Top",If we select any textbox a particular line will be enable in the thumbnail picture.

What i actually want is ,whether the value shown in the "Top" includes the value of "Header" or not.

Say Top has 1.06 and Header has "0.24" whether this 1.06 is inclusive of 0.24 or not .

Thanks in advance.


Thanks,
Lokesh.

[BlastRanger]

if top has 1.06, header has 0.24
then top is not inside header.

So the answer is no

Header is the margin for your header of each page, for a common example, lets use footer (beside bottom).
Usually there are page number below each printed page to determine the page of the sheet. So the footer margin will be the page number margin, and so was the bottom margin is the content of the sheet.

NOTE : Header and footer margin is not the margin for the content of your sheet. Its margin for static value of every page

[outofthehat]

It's easy to see what's going on if you hit the 'Print Preview' button on that dialog box, then the 'Margins' button at the top of the page - you get dotted lines showing you where the header and top appear. You can manually adjust by dragging, then hit the 'setup' button at the top of the page to go back to the dialog box, to type numbers in for precision. When finished with Print Preview, hit the 'Close' button, or 'Print...' to go to that dialog box...

With printing, I tend to work from Print Preview, as you see immediately the effect of your changes in the Page Setup dialog box.

(The only things you can't do in Print Preview are on the 'Sheet' tab...)