Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel introductory

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel introductory

Excel introductory

ResolvedVersion 2007

Alaisdair has attended:
Excel Introduction course
Excel Intermediate course

Excel introductory

When setting up a page as you are going along can you set an option to let you know if it will be too big to print onto a single page using a certain text size? Alternatively, do you have to format for printing after you have finished spreadsheet?

RE: Excel introductory

Hello Alaisdair

Thank you for your question; and welcome to the forum.

If you go into Print Preview, and then exit it, you will see dotted lines on your spreadsheet which show where the edges of the pages will fall when you print.

If your spreadsheet goes over one page, you should be able to see this on your screen.

You can change the scaling in the Page Setup features (File - Page Setup - Page) in order to fit more on one page, however this may affect readability when the spreadsheet is printed out.

Amanda

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.