Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Print Column Heads WITHOUT Excel Column Lables
I'm trying to print the column heads, and I have gone into file page setup
sheet and tried both "rows to repeat at top" and highlighted the rows I wanted, and also clicked "row and column headings." When I go to print, though, my row is on every page, but it is not at the top, the Excel labels (A,B,C,D) are at the top, and the Excel numbers (1, 2, 3, 4) are on the side of every page!! I have even added a row and column, but they still show up on every page! It looks incredibly unprofessional. Anyone know how to fix this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Print Column Heads WITHOUT Excel Column Lables
By selecting "row and column headers" you ensured they will print.
Uncheck that option. Leave the "rows to repeat at top" as $1:$1 Gord Dibben MS Excel MVP On Thu, 19 Jun 2008 06:33:03 -0700, Sarah E <Sarah wrote: I'm trying to print the column heads, and I have gone into file page setup sheet and tried both "rows to repeat at top" and highlighted the rows I wanted, and also clicked "row and column headings." When I go to print, though, my row is on every page, but it is not at the top, the Excel labels (A,B,C,D) are at the top, and the Excel numbers (1, 2, 3, 4) are on the side of every page!! I have even added a row and column, but they still show up on every page! It looks incredibly unprofessional. Anyone know how to fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing column heads from ABC to 123 | Excel Discussion (Misc queries) | |||
Alpha column lables | Excel Worksheet Functions | |||
List Tabs and Column Heads | Excel Discussion (Misc queries) | |||
Column heads are numbers | Excel Discussion (Misc queries) | |||
column heads | New Users to Excel |