Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lock a row at top for titles of columns?
Is there a way to lock the top row that contains the description of columns
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't insert columns between columns | Excel Discussion (Misc queries) | |||
How do I lock columns together in a single row for sorting purpos. | Excel Discussion (Misc queries) | |||
LOCK columns | New Users to Excel | |||
How do I lock hidden columns? | Excel Worksheet Functions | |||
The $ thing to lock cells at rows or columns | Excel Discussion (Misc queries) |