 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2007On printing out a set of rows and columns at the beginning of every sheet.
I seem to remember that there is a way of specifying a set of rows and columns that get printed out at the top and left of each sheet when printing a worksheet that gets split into multiple sheets. Don J ---------------------------------------------------------------- File (menu) | Page Setup | Sheet (tab) "Rows to repeat at top" "Columns to repeat at left"  SignatureJim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Don J" <dej8801@comcast.net> wrote in message I seem to remember that there is a way of specifying a set of rows and columns that get printed out at the top and left of each sheet when printing a worksheet that gets split into multiple sheets. Don J Thanks! Don J ------------------------------------------------------------------ > File (menu) | Page Setup | Sheet (tab) > "Rows to repeat at top" > "Columns to repeat at left" <File> <Page Setup> <Sheet> tab, SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > I seem to remember that there is a way of specifying a set of rows and > columns that get printed out at the top and left of each sheet when printing [quoted text clipped - 3 lines] > > ---------------------------------------------------------------- Thanks! Don J -------------------------------------------------------------------- > <File> <Page Setup> <Sheet> tab, > [quoted text clipped - 6 lines] >> >> ---------------------------------------------------------------- Not OK! I insert the numeral "3" for three rows, or just "A" to designate the first row. In each case I get a message to the effect that the name is illegal. Whats going on? Don J ------------------------------------------------------------------ > Thanks! > [quoted text clipped - 11 lines] >>> >>> ---------------------------------------------------------------- It's looking for *2* numbers, a start and an end! You could choose to have 3 rows repeat at the top of each page. So, you'd enter 1:3 Same for columns, A:C Now, for a single row or column, 3:3 OR A:A SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Not OK! > [quoted text clipped - 24 lines] > >>> > >>> ---------------------------------------------------------------- Your syntax is wrong... $1:$3 and $A:$A works. The easiest way is to just select the rows or columns. SignatureJim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Don J" <dej8801@comcast.net> wrote in message Not OK! I insert the numeral "3" for three rows, or just "A" to designate the first row. In each case I get a message to the effect that the name is illegal. Whats going on? Don J |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.