Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I put a border around headers?
I have an excdel workbook, containing a number of worksheets. They each have
headers and footers set up, but the headers all need to have a border around them. Is this possible? |
#2
|
|||
|
|||
Hi "bardo",
Not in Excel, but .you might use ... Preprinted sheets with borders and possible logos, you may have some difficulty lining things up. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "bardo" wrote in message ... I have an excdel workbook, containing a number of worksheets. They each have headers and footers set up, but the headers all need to have a border around them. Is this possible? |
#3
|
|||
|
|||
you can create the header/footer with the border around it as an image. in excel you can then insert an image as the header. -- tkaplan ------------------------------------------------------------------------ tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987 View this thread: http://www.excelforum.com/showthread...hreadid=474718 |
#4
|
|||
|
|||
You can't put an image into the header until later versions,
and you don't have much control where they print relative to left and right page margins. But I wasn't thinking. You can use the top rows of your spreadsheet as the headers, and draw boxes around what you want. Would probably only work well if it all fits across one page, you will have to plan your heading content according to your spreadsheet content. File, page setup, rows to repeat at top: $1:$4 Headings for Columns, and Page Numbering http://www.mvps.org/dmcritchie/excel/headcols.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "tkaplan" wrote in message ... you can create the header/footer with the border around it as an image. in excel you can then insert an image as the header. -- tkaplan ------------------------------------------------------------------------ tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987 View this thread: http://www.excelforum.com/showthread...hreadid=474718 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I put a border around headers?
This exactly what I need to do because I also need to print a border around
my header. But then I also need to print "Page n of t" available in the Custom Header options. (Each report is going to be 1 to a max of 4 pages.) Is the a way to do this in VBA code? Any help would be appreciated! "David McRitchie" wrote: You can't put an image into the header until later versions, and you don't have much control where they print relative to left and right page margins. But I wasn't thinking. You can use the top rows of your spreadsheet as the headers, and draw boxes around what you want. Would probably only work well if it all fits across one page, you will have to plan your heading content according to your spreadsheet content. File, page setup, rows to repeat at top: $1:$4 Headings for Columns, and Page Numbering http://www.mvps.org/dmcritchie/excel/headcols.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "tkaplan" wrote in message ... you can create the header/footer with the border around it as an image. in excel you can then insert an image as the header. -- tkaplan ------------------------------------------------------------------------ tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987 View this thread: http://www.excelforum.com/showthread...hreadid=474718 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I put a border around headers?
Why not put the page n of nn outside of the boxed header area
either in the footer or possibly in the actual header. There are several ways of including the page number that a cell would print on, but when the page number is to be in the rows to repeat at top, you would have to start the printing for each sheet and you would use that number used in your loop for the page number. Possible but not straightforward, if you have separator sheets on a network printer it would be very wasteful of paper as well. Some of the include page number cell will print in are in the related area(s) of http://www.mvps.org/dmcritchie/excel/pathname.htm for how to print each page individually see Myrna Larson's reply in this thread http://groups.google.com/groups?thre...wood.u-net.com --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "mato nanjin" wrote in message ... This exactly what I need to do because I also need to print a border around my header. But then I also need to print "Page n of t" available in the Custom Header options. (Each report is going to be 1 to a max of 4 pages.) Is the a way to do this in VBA code? Any help would be appreciated! "David McRitchie" wrote: You can't put an image into the header until later versions, and you don't have much control where they print relative to left and right page margins. But I wasn't thinking. You can use the top rows of your spreadsheet as the headers, and draw boxes around what you want. Would probably only work well if it all fits across one page, you will have to plan your heading content according to your spreadsheet content. File, page setup, rows to repeat at top: $1:$4 Headings for Columns, and Page Numbering http://www.mvps.org/dmcritchie/excel/headcols.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "tkaplan" wrote in message ... you can create the header/footer with the border around it as an image. in excel you can then insert an image as the header. -- tkaplan ------------------------------------------------------------------------ tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987 View this thread: http://www.excelforum.com/showthread...hreadid=474718 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) | |||
Changing Border Thickness Throughout Document | Excel Discussion (Misc queries) | |||
only last cell on page to have bottom border (cell area outline) | Excel Worksheet Functions | |||
Border misaligned | New Users to Excel | |||
Border misaligned | New Users to Excel |