N
nc
Is there a way to put a line across each page using footer in page setup?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bryan Hessey
Not sure how this was supposed to go, but I use 60 spaces in a cell,
underlined, copy, ESC (which keeps the copy) and paste into the centre
tab of the page footer.
This gives me the best page bottom line I have been able to achieve,
Then I clear the cell.
Hope this helps.
--
underlined, copy, ESC (which keeps the copy) and paste into the centre
tab of the page footer.
This gives me the best page bottom line I have been able to achieve,
Then I clear the cell.
Hope this helps.
--
N
nc
I have followed your instruction but cannot paste.
B
Bryan Hessey
to copy characters (rather than 'cell copy', select the cell, the
select the characters shown in the Formula Bar, copy, then press ESC t
release the lock (but retain the copy), then go to the page footer an
paste.
HTH
--
select the characters shown in the Formula Bar, copy, then press ESC t
release the lock (but retain the copy), then go to the page footer an
paste.
HTH
--
I have followed your instruction but cannot paste.
N
nc
I still cannot get it to work the way I wanted.
Basically I want the footer to look like this
_____________________________________________________________________
28 London School Financial Statement for the year
ended 31 July
The number is the page number.
Thanks.
Basically I want the footer to look like this
_____________________________________________________________________
28 London School Financial Statement for the year
ended 31 July
The number is the page number.
Thanks.
B
Bryan Hessey
Go to File, Page Setup, Header/Footer, Custom Footer, Left Pane
Put in 4 spaces and press Enter, then left arrow twice to get to line
1, and Shift-left arrow to select the 4 spaces, click the A (font
details) and select Underline, Single. Click in between the underlined
spaces and add enough spaces to cross your page.
Down arrow to the next line, and click for &[Page] and then type
London ~~~ etc
press enter and type 'Ended' and press to get the date (or type your
date)
OK to close the window, and check in Preview, lengthen or shorten the
underlined spaces to suit.
Hope this helps
---
Put in 4 spaces and press Enter, then left arrow twice to get to line
1, and Shift-left arrow to select the 4 spaces, click the A (font
details) and select Underline, Single. Click in between the underlined
spaces and add enough spaces to cross your page.
Down arrow to the next line, and click for &[Page] and then type
London ~~~ etc
press enter and type 'Ended' and press to get the date (or type your
date)
OK to close the window, and check in Preview, lengthen or shorten the
underlined spaces to suit.
Hope this helps
---
N
nc
Thanks Bryan.
It works except for the number number of characters, there a limit of 255
characters for the whole footer, that includes the line (Spaces).
Anyway round this problem?
It works except for the number number of characters, there a limit of 255
characters for the whole footer, that includes the line (Spaces).
Anyway round this problem?
Bryan Hessey said:Go to File, Page Setup, Header/Footer, Custom Footer, Left Pane
Put in 4 spaces and press Enter, then left arrow twice to get to line
1, and Shift-left arrow to select the 4 spaces, click the A (font
details) and select Underline, Single. Click in between the underlined
spaces and add enough spaces to cross your page.
Down arrow to the next line, and click for &[Page] and then type
London ~~~ etc
press enter and type 'Ended' and press to get the date (or type your
date)
OK to close the window, and check in Preview, lengthen or shorten the
underlined spaces to suit.
Hope this helps
---
I still cannot get it to work the way I wanted.
Basically I want the footer to look like this
_____________________________________________________________________
28 London School Financial Statement for the
year
ended 31 July
The number is the page number.
Thanks.
B
Bryan Hessey
Not to my knowledge in the current version of Excel.
--
--
Thanks Bryan.
It works except for the number number of characters, there a limit of
255
characters for the whole footer, that includes the line (Spaces).
Anyway round this problem?
Bryan Hessey said:Go to File, Page Setup, Header/Footer, Custom Footer, Left Pane
Put in 4 spaces and press Enter, then left arrow twice to get to line
1, and Shift-left arrow to select the 4 spaces, click the A (font
details) and select Underline, Single. Click in between the underlined
spaces and add enough spaces to cross your page.
Down arrow to the next line, and click for &[Page] and then type
London ~~~ etc
press enter and type 'Ended' and press to get the date (or type your
date)
OK to close the window, and check in Preview, lengthen or shorten the
underlined spaces to suit.
Hope this helps
---
I still cannot get it to work the way I wanted.
Basically I want the footer to look like this
_____________________________________________________________________
28 London School Financial Statement for the
year
ended 31 July
The number is the page number.
Thanks.
:
to copy characters (rather than 'cell copy', select the cell, then
select the characters shown in the Formula Bar, copy, then press ESC
to
release the lock (but retain the copy), then go to the page footer
and
paste.
HTH
--
nc Wrote:
I have followed your instruction but cannot paste.
:
Not sure how this was supposed to go, but I use 60 spaces in a
cell,
underlined, copy, ESC (which keeps the copy) and paste into the
centre
tab of the page footer.
This gives me the best page bottom line I have been able to
achieve,
Then I clear the cell.
Hope this helps.
--
nc Wrote:
Is there a way to put a line across each page using footer in
page
setup?
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=21059
View this thread:
http://www.excelforum.com/showthread.php?threadid=534512
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=21059
View this thread:
http://www.excelforum.com/showthread.php?threadid=534512
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
View this thread: http://www.excelforum.com/showthread.php?threadid=534512