+- Forums (http://lottopost.co.uk/forum)
+-- Forum: Lotto & Excel Discussion (/forumdisplay.php?fid=44)
+--- Forum: Excel Discussion (/forumdisplay.php?fid=46)
+--- Thread: Excel tips (/showthread.php?tid=2080)
Excel tips - Frank - 04-29-2013 06:04 AM
Tip 1.
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.
RE: Excel tips - Frank - 05-10-2013 12:03 AM
Well it seemed like a good idea at the time. It would have got better, had anyone shown any interest. Another thread bites the dust.
RE: Excel tips - valelli - 05-10-2013 12:09 AM
it would appear that there is alot of shy people out there who like to look at the threads but not actually contribute which is a shame
RE: Excel tips - Frank - 05-10-2013 12:42 AM
Thanks Val for taking the trouble to reply. Its one of those threads where interaction is required. I need to know whether people already knew it, whether they tried it and failed, whether they learned something new, whether anybody at all is interested. It does take up valuable time writing these things, so if nobody cares, I'll go watch telly instead.
RE: Excel tips - valelli - 05-10-2013 06:43 AM
am a lone voice frank, when u look at how many views this thread has got u would think at least one person would contribute but no...off to watch telly myself!!