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.
"Bryan Hessey" wrote:
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.
"Bryan Hessey" wrote:
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...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=534512
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=534512