Posted to microsoft.public.excel.worksheet.functions

Scott Hemphill Scott Hemphill is offline

external usenet poster

Posts: 6

Sequential Numbers

I have a worksheet where i want to number a column sequentially but not every
row. I put number 1 in column A1 and then put the formula A1+1 and copy it
down, sometimes i have blank rows where i don't need any numbers, sometimes i
delete and add rows. Is there a way without just copy and paste to achieve
the same results?
--
Scott Hemphill

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Sequential numbers when printing	Marilyn, Training Coordinator	Excel Worksheet Functions	3	August 7th 06 06:24 PM
Sequential Numbers	abcdexcel	Excel Discussion (Misc queries)	3	January 18th 06 11:06 AM
sequential numbers	Harley	Excel Worksheet Functions	1	January 12th 06 09:57 PM
sequential numbers	AndrewRichardWood	Excel Discussion (Misc queries)	2	July 20th 05 05:00 PM
sequential numbers on invoices	Tony	Excel Worksheet Functions	2	December 2nd 04 11:05 PM

All times are GMT +1. The time now is 06:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us