How do I enter rows to repeat on sheet tab? in Excel General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Geoff W 8/1/2005 8:25 AM PST
  Question
  I get an error message when I enter rows 123456 in the rows to repeat at top
box.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Dave O 8/1/2005 8:40 AM PST
   
  Enter it like this:
$1:$6
.... to indicate rows 1 thru 6.

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Angel 8/14/2008 10:55 AM PST
   
 

"Dave O" wrote:

> Enter it like this:
> $1:$6
> .... to indicate rows 1 thru 6.
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
BONNIE B 10/16/2008 7:13 PM PST
   
  FINALLY, SOMEONE TELLS YOU EXACTLY HOW TO LIST IT. THANK YOU SO MUCH. I
ONLY WANTED ROW 1 REPEATED SO I HAD TO LIST IT $1:$1. HOORAY!

"Dave O" wrote:

> Enter it like this:
> $1:$6
> .... to indicate rows 1 thru 6.
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
David Biddulph 10/17/2008 1:14 AM PST
   
  The easy way is to select the row or rows you want, and that will fill in
the dialogue box for you.
--
David Biddulph

"BONNIE B" <BONNIE B@discussions.microsoft.com> wrote in message
news:3FB97989-25B5-47D6-9D4F-3617AFC2B584@microsoft.com...
> FINALLY, SOMEONE TELLS YOU EXACTLY HOW TO LIST IT. THANK YOU SO MUCH. I
> ONLY WANTED ROW 1 REPEATED SO I HAD TO LIST IT $1:$1. HOORAY!
>
> "Dave O" wrote:
>
>> Enter it like this:
>> $1:$6
>> .... to indicate rows 1 thru 6.
>>
>>


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Mikie 4/9/2009 9:24 AM PST
   
  Thanks! I was getting flustered.

"Dave O" wrote:

> Enter it like this:
> $1:$6
> .... to indicate rows 1 thru 6.
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Dave Peterson 8/1/2005 2:47 PM PST
  Answer
  I do my best not to type this in that box.

I'll just use the mouse and point at the rows I want to repeat at top. I'll let
excel figure out how to enter the value.

Geoff W wrote:
>
> I get an error message when I enter rows 123456 in the rows to repeat at top
> box.

--

Dave Peterson
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies