http://lottopost.co.uk/forum/ Sat, 01 Aug 2026 13:02:42 +0000 MyBB http://lottopost.co.uk/forum/showthread.php?tid=2080 Sun, 28 Apr 2013 20:04:32 +0000 http://lottopost.co.uk/forum/showthread.php?tid=2080 Heres a basic tip. If you want to create a column of numbers going 1 to anything with a difference of 1:-

Enter 1 in the top cell
Enter 2 in the cell below
select BOTH cells, left mouse click
move mouse pointer over the bottom rhs corner of the bottom cell and when pointer changes to a crosshairs over the dragbar, left click and hold the button down, pull mouse downwards.

This will create 1,2,3,4,5,6,7,,,,,,,,,,,,,, etc downwards.

The same method works horizontally but the first 2 cells are side by side before you select both and drag.

If you want only odd numbers in the list, then enter 1 then 3 in the first 2 cells.

If you want to go up in 50's then enter 0 then 50 in the first 2 cells.

It works for any difference, you just set it in the first 2 cells.

If the second number is less then the first number, the list reduces in value and will go negative if you wish.

You could equally copy LEFT or UP to extend the list that way.]]> Heres a basic tip. If you want to create a column of numbers going 1 to anything with a difference of 1:-

Enter 1 in the top cell
Enter 2 in the cell below
select BOTH cells, left mouse click
move mouse pointer over the bottom rhs corner of the bottom cell and when pointer changes to a crosshairs over the dragbar, left click and hold the button down, pull mouse downwards.

This will create 1,2,3,4,5,6,7,,,,,,,,,,,,,, etc downwards.

The same method works horizontally but the first 2 cells are side by side before you select both and drag.

If you want only odd numbers in the list, then enter 1 then 3 in the first 2 cells.

If you want to go up in 50's then enter 0 then 50 in the first 2 cells.

It works for any difference, you just set it in the first 2 cells.

If the second number is less then the first number, the list reduces in value and will go negative if you wish.

You could equally copy LEFT or UP to extend the list that way.]]> http://lottopost.co.uk/forum/showthread.php?tid=2075 Thu, 25 Apr 2013 17:59:43 +0000 http://lottopost.co.uk/forum/showthread.php?tid=2075 If anyone would like to talk about excel sheets
please feel free to post in this thread.]]> If anyone would like to talk about excel sheets
please feel free to post in this thread.]]>