Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
antoniokc
 
Posts: n/a
Default how do i set up repeating row/column titles in Excel?

i want row and column titles to automatically fill into place in a working
spreadsheet, but i do not know how.

can someone tell me how to do this?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default how do i set up repeating row/column titles in Excel?

I'm not sure whether you want col/row titles to be on every page when
printing or to always be visible when viewing the worksheet.

For printing:
<file<page setup<sheet tab
Set: rows and columns to repeat

For viewing:
Select the 1st cell below the col titles and to the right of the row titles
<window<freeze panes

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"antoniokc" wrote:

i want row and column titles to automatically fill into place in a working
spreadsheet, but i do not know how.

can someone tell me how to do this?

  #3   Report Post  
Posted to microsoft.public.excel.newusers
antoniokc
 
Posts: n/a
Default how do i set up repeating row/column titles in Excel?

thank, ron, for helping me out with this. i managed to print out my document
exactly as i wanted it!

best,
antonio

"Ron Coderre" wrote:

I'm not sure whether you want col/row titles to be on every page when
printing or to always be visible when viewing the worksheet.

For printing:
<file<page setup<sheet tab
Set: rows and columns to repeat

For viewing:
Select the 1st cell below the col titles and to the right of the row titles
<window<freeze panes

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"antoniokc" wrote:

i want row and column titles to automatically fill into place in a working
spreadsheet, but i do not know how.

can someone tell me how to do this?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel 5 and Excel 2000 question. Naveen Mukkelli Excel Discussion (Misc queries) 1 March 3rd 06 09:05 AM
repeating a data pattern in excel KelC Excel Discussion (Misc queries) 1 August 1st 05 08:38 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
Why have I got some repeating rows after a Excel 2003 sort Jayne Excel Discussion (Misc queries) 1 January 6th 05 05:34 PM


All times are GMT +1. The time now is 02:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"