Don't panic if you accidentally hit your keyboard and find that all the cells in Excel are displaying its formula instead of their results.
All you need to do is to press Ctrl + ` Note: ` <- this symbol refers to the key on the left side of 1.
Have fun!
I learn Microsoft Excel - From Basics to Advanced
This blog is dedicated to all who wants to learn Excel, epecially the beginners. I will randomly post topics from the basics to the more advanced functions like how to create a Macro to automate your work. Drop me any comments if you have questions using Excel. Happy reading:)
Thursday 6 December 2012
Wednesday 28 November 2012
Powerball lucky numbers generator
Hi, I have added a lucky numbers generator for Powerball using excel.
I have uploaded the file to skydrive and you can access it and try out using this link:
https://skydrive.live.com/redir?resid=F0F21B96ADB9B690!114
A screen shot looks like this:
Good luck!
I have uploaded the file to skydrive and you can access it and try out using this link:
https://skydrive.live.com/redir?resid=F0F21B96ADB9B690!114
A screen shot looks like this:
Powerball lucky number generator |
Singapore Toto lucky number generator
For TOTO fans in Singapore, here is a spreadsheet to help to generate lucky numbers!
Gambling is bad, this is just for fun :)
Coding for TOTO is much harder than 4D. This is because the lucky numbers should not repeat. However, I have found a way to code that. Enjoy!
I have uploaded the excel file and you can try out 'live' using this link:
https://skydrive.live.com/redir?resid=F0F21B96ADB9B690!114
Sample looks like this:
Singapore Toto Lucky number generator |
Good luck!
Thursday 10 May 2012
Singapore 4D lucky number generator
For 4D fans in Singapore, here is a spreadsheet to help to generate lucky numbers!
Gambling is bad, this is just for fun :)
All you have to do is use
=RANDBETWEEN(1,9999) in all the winning numbers cells
and then format the cells to custom -> type = 0000
I have uploaded the excel file and you can try out 'live' using this link:
https://skydrive.live.com/redir?resid=F0F21B96ADB9B690!109
Sample looks like this:
:
Good luck!
Gambling is bad, this is just for fun :)
All you have to do is use
=RANDBETWEEN(1,9999) in all the winning numbers cells
and then format the cells to custom -> type = 0000
I have uploaded the excel file and you can try out 'live' using this link:
https://skydrive.live.com/redir?resid=F0F21B96ADB9B690!109
Sample looks like this:
Singapore 4D lucky number generator |
:
Good luck!
Wednesday 9 May 2012
Excel random number generator
Creating a random number generator is easy:)
All you need to know are the functions RAND( ) and RANDBETWEEN ( )
Let me show you an example on how to create a lucky number generator using the concept of random number generator in Excel.
RAND ( ) gives you a number from 0 to 1
RANDBETWEEN ( ) gives you a number between the range you want. In this case from 1 to 9999.
All you need to know are the functions RAND( ) and RANDBETWEEN ( )
Let me show you an example on how to create a lucky number generator using the concept of random number generator in Excel.
RAND ( ) gives you a number from 0 to 1
RANDBETWEEN ( ) gives you a number between the range you want. In this case from 1 to 9999.
excel random number generator |
Monday 7 May 2012
Excel VBA Macro hang due to endless loop
To address Excel VBA Macro hang due to endless loop, all you have to do is to press CTRL + Break
done!
done!
Insert Euro, Pound, and other symbols in Excel
If you want to insert any special symbol in Excel, all you have to do is to click the insert tab -> symbol -> the symbol you want -> insert
Done!
Other ways include:
Alt+0128 using numeric keypad (the one at the right)
or
Select a cell and type = CHAR(128) in the formula bar
Fancy symbol like € © £ ¥ ® ™ ± ≠ ≤ ≥ ÷ × ∞ µ α √ ? you can just do the same!
Insert Euro Symbol in Excel |
Done!
Other ways include:
Alt+0128 using numeric keypad (the one at the right)
or
Select a cell and type = CHAR(128) in the formula bar
Fancy symbol like € © £ ¥ ® ™ ± ≠ ≤ ≥ ÷ × ∞ µ α √ ? you can just do the same!
Subscribe to:
Posts (Atom)