EXCEL WORKSHEETS - FORMATTING ISSUES

L

LLOLA

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.
 
G

Gord Dibben

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
 
Top