EXCEL WORKSHEETS - FORMATTING ISSUES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HOW DO I ADD HORIZONTAL BORDER LINES TO MULTIPLE COLUMNS IN AN EXCEL EXCEL
WORKSHEET?

ALSO, I WANT TO NUMBER THE PAGES IN THE WORKSHEET; HOWEVER, I DO NOT WANT
NUMBER 1 TO SHOW ON THE FIRST PAGE.

THANKS. YOUR HELP WILL BE APPRECIATED.
 
Please turn off the Caps Lock.

Hard on the ears and difficult to read.

1. Select the range of cells across columns(do not select entire columns) then
Format>Cells>Borders

Hit the bottom border button and the middle border button.

2. For printing, you mean? Page number in a footer or header?

Either two manual print jobs or VBA macro.

http://www.rondebruin.nl/print.htm#Header


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Insert Page Numbers on Worksheet in Excel 2007 6
header/page border 2
Different Page Numbers In Worksheet w/Page Breaks 8
Excel Borders not printing in Excel 8
How can I add letters to page numbers in Excel. 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Worksheet Formula Issues 3

Back
Top