> Hi bart-
>
> Make sure you are in Normal View (_not_ in Print Preview) & go to File>Page
> Setup. On the Sheet page specify what Row(s) to repeat at top.
>
> HTH |:>)
>
> "bart dotzman" wrote:
>
> > Is there a way to lock the top row that contains the description of columns
On the Sheet page - I have tried to tell it to freeze row 1 but If I type in
a 1 then it
says "reference not valid" If I type a1; IV1 it says formula contains
errors - so how do I tell it to keep row 1 at the top?
"CyberTaz" wrote:
> Hi bart-
>
> Make sure you are in Normal View (_not_ in Print Preview) & go to File>Page
> Setup. On the Sheet page specify what Row(s) to repeat at top.
>
> HTH |:>)
>
> "bart dotzman" wrote:
>
> > Is there a way to lock the top row that contains the description of columns
Use $1:$1 or just select it by clicking on that funny looking sheet icon to
the right of the little box and it will take you to the sheet, then click on
row 1 in the row header
--
Regards,
Peo Sjoblom
"Felicity11" <Felicity11@discussions.microsoft.com> wrote in message
news:6353FFBE-56E5-4D5A-9867-1D8659DDE727@microsoft.com...
> On the Sheet page - I have tried to tell it to freeze row 1 but If I type
> in
> a 1 then it
> says "reference not valid" If I type a1; IV1 it says formula contains
> errors - so how do I tell it to keep row 1 at the top?
>
> "CyberTaz" wrote:
>
>> Hi bart-
>>
>> Make sure you are in Normal View (_not_ in Print Preview) & go to
>> File>Page
>> Setup. On the Sheet page specify what Row(s) to repeat at top.
>>
>> HTH |:>)
>>
>> "bart dotzman" wrote:
>>
>> > Is there a way to lock the top row that contains the description of
>> > columns
I do not have a printer installed, nor want to nor will ever have. I use
Excel as a database then send my creation via email. I would like my title
row to not be numbered at all (or maybe "A") So that the row numbers
accurately reflecr the number of entries - one loses track when getting to
say, row #87, and one forgets to subtract 1.
Freeze row 1 by selecting A2 and Window>Freeze Panes.
Insert a column left of your data and in A2 enter =ROW()-1
Drag down as far as you wish.
Tools>Options>View. Uncheck "Row and column headers"
I think you have to have a printer installed.
Excel bases its settings on the default printer.
Gord Dibben MS Excel MVP
On Sat, 23 Aug 2008 08:58:00 -0700, Canopus
<Canopus@discussions.microsoft.com> wrote:
>I do not have a printer installed, nor want to nor will ever have. I use
>Excel as a database then send my creation via email. I would like my title
>row to not be numbered at all (or maybe "A") So that the row numbers
>accurately reflecr the number of entries - one loses track when getting to
>say, row #87, and one forgets to subtract 1.
That won't change the actual real row address, just the display.
Gord
On Sat, 23 Aug 2008 11:02:43 -0700, Gord Dibben <gorddibbATshawDOTca> wrote:
>Freeze row 1 by selecting A2 and Window>Freeze Panes.
>
>Insert a column left of your data and in A2 enter =ROW()-1
>
>Drag down as far as you wish.
>
>Tools>Options>View. Uncheck "Row and column headers"
>
>I think you have to have a printer installed.
>
>Excel bases its settings on the default printer.
>
>
>Gord Dibben MS Excel MVP
>
>On Sat, 23 Aug 2008 08:58:00 -0700, Canopus
><Canopus@discussions.microsoft.com> wrote:
>
>>I do not have a printer installed, nor want to nor will ever have. I use
>>Excel as a database then send my creation via email. I would like my title
>>row to not be numbered at all (or maybe "A") So that the row numbers
>>accurately reflecr the number of entries - one loses track when getting to
>>say, row #87, and one forgets to subtract 1.
Question
Reply
Top
Answer
Notify me of replies