Is there a way to put a line across each page using footer in page setup?
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:
gt; Is there a way to put a line across each page using footer in page
gt; setup?--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=534512I have followed your instruction but cannot paste.
quot;Bryan Hesseyquot; wrote:
gt;
gt; Not sure how this was supposed to go, but I use 60 spaces in a cell,
gt; underlined, copy, ESC (which keeps the copy) and paste into the centre
gt; tab of the page footer.
gt;
gt; This gives me the best page bottom line I have been able to achieve,
gt;
gt; Then I clear the cell.
gt;
gt; Hope this helps.
gt;
gt; --
gt;
gt; nc Wrote:
gt; gt; Is there a way to put a line across each page using footer in page
gt; gt; setup?
gt;
gt;
gt; --
gt; Bryan Hessey
gt; ------------------------------------------------------------------------
gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt; View this thread: www.excelforum.com/showthread...hreadid=534512
gt;
gt;
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:
gt; I have followed your instruction but cannot paste.
gt;
gt; quot;Bryan Hesseyquot; wrote:
gt;
gt; gt;
gt; gt; Not sure how this was supposed to go, but I use 60 spaces in a cell,
gt; gt; underlined, copy, ESC (which keeps the copy) and paste into the
gt; centre
gt; gt; tab of the page footer.
gt; gt;
gt; gt; This gives me the best page bottom line I have been able to achieve,
gt; gt;
gt; gt; Then I clear the cell.
gt; gt;
gt; gt; Hope this helps.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; nc Wrote:
gt; gt; gt; Is there a way to put a line across each page using footer in page
gt; gt; gt; setup?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Bryan Hessey
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Bryan Hessey's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=534512
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=534512I 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 JulyThe number is the page number.
Thanks.
quot;Bryan Hesseyquot; wrote:
gt;
gt; to copy characters (rather than 'cell copy', select the cell, then
gt; select the characters shown in the Formula Bar, copy, then press ESC to
gt; release the lock (but retain the copy), then go to the page footer and
gt; paste.
gt;
gt; HTH
gt;
gt; --
gt;
gt; nc Wrote:
gt; gt; I have followed your instruction but cannot paste.
gt; gt;
gt; gt; quot;Bryan Hesseyquot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; Not sure how this was supposed to go, but I use 60 spaces in a cell,
gt; gt; gt; underlined, copy, ESC (which keeps the copy) and paste into the
gt; gt; centre
gt; gt; gt; tab of the page footer.
gt; gt; gt;
gt; gt; gt; This gives me the best page bottom line I have been able to achieve,
gt; gt; gt;
gt; gt; gt; Then I clear the cell.
gt; gt; gt;
gt; gt; gt; Hope this helps.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; nc Wrote:
gt; gt; gt; gt; Is there a way to put a line across each page using footer in page
gt; gt; gt; gt; setup?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Bryan Hessey
gt; gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; gt; Bryan Hessey's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; gt; View this thread:
gt; gt; www.excelforum.com/showthread...hreadid=534512
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt; --
gt; Bryan Hessey
gt; ------------------------------------------------------------------------
gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt; View this thread: www.excelforum.com/showthread...hreadid=534512
gt;
gt;
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 amp;[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
---nc Wrote:
gt; I still cannot get it to work the way I wanted.
gt;
gt; Basically I want the footer to look like this
gt;
gt;
gt; __________________________________________________ ___________________
gt; 28 London School Financial Statement for the
gt; year
gt; ended 31 July
gt;
gt;
gt; The number is the page number.
gt;
gt; Thanks.
gt;
gt; quot;Bryan Hesseyquot; wrote:
gt;
gt; gt;
gt; gt; to copy characters (rather than 'cell copy', select the cell, then
gt; gt; select the characters shown in the Formula Bar, copy, then press ESC
gt; to
gt; gt; release the lock (but retain the copy), then go to the page footer
gt; and
gt; gt; paste.
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; --
gt; gt;
gt; gt; nc Wrote:
gt; gt; gt; I have followed your instruction but cannot paste.
gt; gt; gt;
gt; gt; gt; quot;Bryan Hesseyquot; wrote:
gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; Not sure how this was supposed to go, but I use 60 spaces in a
gt; cell,
gt; gt; gt; gt; underlined, copy, ESC (which keeps the copy) and paste into the
gt; gt; gt; centre
gt; gt; gt; gt; tab of the page footer.
gt; gt; gt; gt;
gt; gt; gt; gt; This gives me the best page bottom line I have been able to
gt; achieve,
gt; gt; gt; gt;
gt; gt; gt; gt; Then I clear the cell.
gt; gt; gt; gt;
gt; gt; gt; gt; Hope this helps.
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; nc Wrote:
gt; gt; gt; gt; gt; Is there a way to put a line across each page using footer in
gt; page
gt; gt; gt; gt; gt; setup?
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Bryan Hessey
gt; gt; gt; gt;
gt; gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; gt; gt; Bryan Hessey's Profile:
gt; gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; gt; gt; View this thread:
gt; gt; gt; www.excelforum.com/showthread...hreadid=534512
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Bryan Hessey
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Bryan Hessey's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=534512
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=534512Thanks 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?quot;Bryan Hesseyquot; wrote:
gt;
gt; Go to File, Page Setup, Header/Footer, Custom Footer, Left Pane
gt;
gt; Put in 4 spaces and press Enter, then left arrow twice to get to line
gt; 1, and Shift-left arrow to select the 4 spaces, click the A (font
gt; details) and select Underline, Single. Click in between the underlined
gt; spaces and add enough spaces to cross your page.
gt;
gt; Down arrow to the next line, and click for amp;[Page] and then type
gt; London ~~~ etc
gt; press enter and type 'Ended' and press to get the date (or type your
gt; date)
gt;
gt; OK to close the window, and check in Preview, lengthen or shorten the
gt; underlined spaces to suit.
gt;
gt; Hope this helps
gt;
gt; ---
gt;
gt;
gt; nc Wrote:
gt; gt; I still cannot get it to work the way I wanted.
gt; gt;
gt; gt; Basically I want the footer to look like this
gt; gt;
gt; gt;
gt; gt; __________________________________________________ ___________________
gt; gt; 28 London School Financial Statement for the
gt; gt; year
gt; gt; ended 31 July
gt; gt;
gt; gt;
gt; gt; The number is the page number.
gt; gt;
gt; gt; Thanks.
gt; gt;
gt; gt; quot;Bryan Hesseyquot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; to copy characters (rather than 'cell copy', select the cell, then
gt; gt; gt; select the characters shown in the Formula Bar, copy, then press ESC
gt; gt; to
gt; gt; gt; release the lock (but retain the copy), then go to the page footer
gt; gt; and
gt; gt; gt; paste.
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; nc Wrote:
gt; gt; gt; gt; I have followed your instruction but cannot paste.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Bryan Hesseyquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Not sure how this was supposed to go, but I use 60 spaces in a
gt; gt; cell,
gt; gt; gt; gt; gt; underlined, copy, ESC (which keeps the copy) and paste into the
gt; gt; gt; gt; centre
gt; gt; gt; gt; gt; tab of the page footer.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; This gives me the best page bottom line I have been able to
gt; gt; achieve,
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Then I clear the cell.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Hope this helps.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; nc Wrote:
gt; gt; gt; gt; gt; gt; Is there a way to put a line across each page using footer in
gt; gt; page
gt; gt; gt; gt; gt; gt; setup?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; Bryan Hessey
gt; gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; gt; gt; gt; Bryan Hessey's Profile:
gt; gt; gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; gt; gt; gt; View this thread:
gt; gt; gt; gt; www.excelforum.com/showthread...hreadid=534512
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Bryan Hessey
gt; gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; gt; Bryan Hessey's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; gt; View this thread:
gt; gt; www.excelforum.com/showthread...hreadid=534512
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt; --
gt; Bryan Hessey
gt; ------------------------------------------------------------------------
gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt; View this thread: www.excelforum.com/showthread...hreadid=534512
gt;
gt;
Not to my knowledge in the current version of Excel.
--
nc Wrote:
gt; Thanks Bryan.
gt;
gt; It works except for the number number of characters, there a limit of
gt; 255
gt; characters for the whole footer, that includes the line (Spaces).
gt;
gt; Anyway round this problem?
gt;
gt;
gt; quot;Bryan Hesseyquot; wrote:
gt;
gt; gt;
gt; gt; Go to File, Page Setup, Header/Footer, Custom Footer, Left Pane
gt; gt;
gt; gt; Put in 4 spaces and press Enter, then left arrow twice to get to
gt; line
gt; gt; 1, and Shift-left arrow to select the 4 spaces, click the A (font
gt; gt; details) and select Underline, Single. Click in between the
gt; underlined
gt; gt; spaces and add enough spaces to cross your page.
gt; gt;
gt; gt; Down arrow to the next line, and click for amp;[Page] and then type
gt; gt; London ~~~ etc
gt; gt; press enter and type 'Ended' and press to get the date (or type your
gt; gt; date)
gt; gt;
gt; gt; OK to close the window, and check in Preview, lengthen or shorten
gt; the
gt; gt; underlined spaces to suit.
gt; gt;
gt; gt; Hope this helps
gt; gt;
gt; gt; ---
gt; gt;
gt; gt;
gt; gt; nc Wrote:
gt; gt; gt; I still cannot get it to work the way I wanted.
gt; gt; gt;
gt; gt; gt; Basically I want the footer to look like this
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; __________________________________________________ ___________________
gt; gt; gt; 28 London School Financial Statement for
gt; the
gt; gt; gt; year
gt; gt; gt; ended 31 July
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; The number is the page number.
gt; gt; gt;
gt; gt; gt; Thanks.
gt; gt; gt;
gt; gt; gt; quot;Bryan Hesseyquot; wrote:
gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; to copy characters (rather than 'cell copy', select the cell,
gt; then
gt; gt; gt; gt; select the characters shown in the Formula Bar, copy, then press
gt; ESC
gt; gt; gt; to
gt; gt; gt; gt; release the lock (but retain the copy), then go to the page
gt; footer
gt; gt; gt; and
gt; gt; gt; gt; paste.
gt; gt; gt; gt;
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; nc Wrote:
gt; gt; gt; gt; gt; I have followed your instruction but cannot paste.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Bryan Hesseyquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Not sure how this was supposed to go, but I use 60 spaces in
gt; a
gt; gt; gt; cell,
gt; gt; gt; gt; gt; gt; underlined, copy, ESC (which keeps the copy) and paste into
gt; the
gt; gt; gt; gt; gt; centre
gt; gt; gt; gt; gt; gt; tab of the page footer.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; This gives me the best page bottom line I have been able to
gt; gt; gt; achieve,
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Then I clear the cell.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Hope this helps.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; nc Wrote:
gt; gt; gt; gt; gt; gt; gt; Is there a way to put a line across each page using footer
gt; in
gt; gt; gt; page
gt; gt; gt; gt; gt; gt; gt; setup?
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; gt; Bryan Hessey
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; gt; gt; gt; gt; Bryan Hessey's Profile:
gt; gt; gt; gt; gt;
gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; gt; gt; gt; gt; View this thread:
gt; gt; gt; gt; gt; www.excelforum.com/showthread...hreadid=534512
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Bryan Hessey
gt; gt; gt; gt;
gt; gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; gt; gt; Bryan Hessey's Profile:
gt; gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; gt; gt; View this thread:
gt; gt; gt; www.excelforum.com/showthread...hreadid=534512
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Bryan Hessey
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Bryan Hessey's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=534512
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=534512
留言列表
