The footers in my spreadsheet seem to be indented differently from the main
spreadsheet margin.

Does anyone know a way to get the footers to align to the same margin as the
data?

(I'm OK if it's a VBA solution too!)

Cheers

M

Mine showed the left footer was one space to the left of the automatic page
margin, so I put a space in front of my left footer and then it was aligned.
Are you looking at your left footer or your center footer? If it is your
center footer, you would have to add spaces to the right of any text to move
the text to the left. Using spaces is the only way I know to align the
footer text to page margins.



"Michelle" <(E-Mail Removed)> wrote in message
news:5CAA22C1-0034-4C72-BD17-(E-Mail Removed)...
> The footers in my spreadsheet seem to be indented differently from the
> main spreadsheet margin.
>
> Does anyone know a way to get the footers to align to the same margin as
> the data?
>
> (I'm OK if it's a VBA solution too!)
>
> Cheers
>
> M

I've made the page margins narrower - more space for data, but the footer
margins (left and right) have stayed the same

Does that make sense?

M


"JLGWhiz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Mine showed the left footer was one space to the left of the automatic
> page margin, so I put a space in front of my left footer and then it was
> aligned. Are you looking at your left footer or your center footer? If it
> is your center footer, you would have to add spaces to the right of any
> text to move the text to the left. Using spaces is the only way I know to
> align the footer text to page margins.
>
>
>
> "Michelle" <(E-Mail Removed)> wrote in message
> news:5CAA22C1-0034-4C72-BD17-(E-Mail Removed)...
>> The footers in my spreadsheet seem to be indented differently from the
>> main spreadsheet margin.
>>
>> Does anyone know a way to get the footers to align to the same margin as
>> the data?
>>
>> (I'm OK if it's a VBA solution too!)
>>
>> Cheers
>>
>> M
>
>

I am not really an expert on headers and footers, but it has always appeared
to me that they have their own margin settings and that those are fixed.
From my feeble recollections, it seems that I have always had to manipulate
the text in the header/footers for alignment with my page settings. The
exception to the fixed range might be when large fonts are used in the
footers, that it will expand vertically. I'll have to check that our, not
sure if that is true in Excel, but might have been in MS Word. Anyhow, it
is a separate entity from the page object.


"Michelle" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> I've made the page margins narrower - more space for data, but the footer
> margins (left and right) have stayed the same
>
> Does that make sense?
>
> M
>
>
> "JLGWhiz" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Mine showed the left footer was one space to the left of the automatic
>> page margin, so I put a space in front of my left footer and then it was
>> aligned. Are you looking at your left footer or your center footer? If
>> it is your center footer, you would have to add spaces to the right of
>> any text to move the text to the left. Using spaces is the only way I
>> know to align the footer text to page margins.
>>
>>
>>
>> "Michelle" <(E-Mail Removed)> wrote in message
>> news:5CAA22C1-0034-4C72-BD17-(E-Mail Removed)...
>>> The footers in my spreadsheet seem to be indented differently from the
>>> main spreadsheet margin.
>>>
>>> Does anyone know a way to get the footers to align to the same margin as
>>> the data?
>>>
>>> (I'm OK if it's a VBA solution too!)
>>>
>>> Cheers
>>>
>>> M
>>
>>
>

After playing around with this for a while, I find that if no print area is
set, the default area starts with column A. If data in column A is right
justified and data in the footer is left justified then it can have the
effect of the data in column A being indented. However, if both are left
justified, then my tests show that they will align. Also, If a print area
is specified by the user and both the left column of the print area and the
footer are left justified then they will align. However if one or the other
is not left justified there could be an offset indenture of one to the
other. So, I suppose the answer is to make sure the left column of the
print area and the left footer are both left justified to make them align.



"Michelle" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> I've made the page margins narrower - more space for data, but the footer
> margins (left and right) have stayed the same
>
> Does that make sense?
>
> M
>
>
> "JLGWhiz" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Mine showed the left footer was one space to the left of the automatic
>> page margin, so I put a space in front of my left footer and then it was
>> aligned. Are you looking at your left footer or your center footer? If
>> it is your center footer, you would have to add spaces to the right of
>> any text to move the text to the left. Using spaces is the only way I
>> know to align the footer text to page margins.
>>
>>
>>
>> "Michelle" <(E-Mail Removed)> wrote in message
>> news:5CAA22C1-0034-4C72-BD17-(E-Mail Removed)...
>>> The footers in my spreadsheet seem to be indented differently from the
>>> main spreadsheet margin.
>>>
>>> Does anyone know a way to get the footers to align to the same margin as
>>> the data?
>>>
>>> (I'm OK if it's a VBA solution too!)
>>>
>>> Cheers
>>>
>>> M
>>
>>
>