Lock a row at top for titles of columns?
 

Is there a way to lock the top row that contains the description of columns

Thank you

"CyberTaz" wrote:

Hi bart-

Make sure you are in Normal View (_not_ in Print Preview) & go to FilePage
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

Hi bart-

Make sure you are in Normal View (_not_ in Print Preview) & go to FilePage
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

Lock a row at top for titles 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.

Lock a row at top for titles of columns?
 

Freeze row 1 by selecting A2 and WindowFreeze Panes.

Insert a column left of your data and in A2 enter =ROW()-1

Drag down as far as you wish.

ToolsOptionsView. 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
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.

Lock a row at top for titles of columns?
 

But.....................

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 WindowFreeze Panes.

Insert a column left of your data and in A2 enter =ROW()-1

Drag down as far as you wish.

ToolsOptionsView. 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
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.

Lock a row at top for titles 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 FilePage
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

Lock a row at top for titles 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" wrote in message
...
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
FilePage
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