Hi,
How do I do a list of numnbers or dates without typing in each cell i.e 1 2 3 4 or 22/01/09, 23/01/09 etc etc
Do you know what I mean??
Thanks
Hi,
How do I do a list of numnbers or dates without typing in each cell i.e 1 2 3 4 or 22/01/09, 23/01/09 etc etc
Do you know what I mean??
Thanks
use the fill handle: demo here
http://communityclips.officelabs.com...9-fc9bb2b57366
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hi,
Enter the first few items of the list.
Highlight all the cells you just entered the list into.
In the bottom cell, put your cursor in the bottom right corner till it becomes a small black cross.
Click and drag the list down to the required length.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks