 |
 | 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 / January 2008Frozen rows
I have created a workbook that has three frozen rows at the top of the page. Is there a way to start numbering the rows below those 3 first. I.E. XDate XJim Glass huts XSales record ---------- 1 2 3 For appearance sake.............................. You can enter =ROW(-3) in A4 then copy down. Then uncheck Tools>Options>View>Row and Column Headers. BUT for the sake of formulas, A4 is still A4 no matter that it says 1. Gord Dibben MS Excel MVP >I have created a workbook that has three frozen rows at the top of the page. >Is there a way to start numbering the rows below those 3 first. [quoted text clipped - 7 lines] >2 >3 I'm lost, I tried the formula but it gives me an error in formula.  SignatureSocrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. > For appearance sake.............................. > [quoted text clipped - 17 lines] > >2 > >3 I think Gord may have meant to write this... =ROW()-3 Rick > I'm lost, I tried the formula but it gives me an error in formula. > [quoted text clipped - 20 lines] >> >2 >> >3 YES! Thanks for the correction, it works! SignatureSocrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. > I think Gord may have meant to write this... > [quoted text clipped - 26 lines] > >> >2 > >> >3 That's what Gord meant<g> Thanks Rick On Thu, 17 Jan 2008 23:04:45 -0500, "Rick Rothstein \(MVP - VB\)" <rickNOSPAMnews@NOSPAMcomcast.net> wrote: >I think Gord may have meant to write this... > [quoted text clipped - 26 lines] >>> >2 >>> >3 |
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.