LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Why is my drag and fill not following the pattern?

I'm trying trying to create a column of number in a pattern:
1,1,1,2,2,2,3,3,3 etc. When I use the drag and fill option to continue this
pattern, it inserts extra rows and included decimals. How do I prevent this?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pattern Fill Leanbabe Charts and Charting in Excel 5 January 29th 10 01:31 AM
Graph Fill Pattern Question DPFW16 Charts and Charting in Excel 2 May 14th 08 08:56 AM
I want to use a fill series to copy down a pattern of dates. DEQhl Excel Discussion (Misc queries) 1 December 20th 07 09:18 AM
inserting a pattern fill in a chart in excel2007 ~Mandy~ New Users to Excel 4 May 17th 07 09:53 PM
Auto Fill Links with a Pattern Gayla Excel Discussion (Misc queries) 1 November 9th 06 10:44 PM


All times are GMT +1. The time now is 05:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"