| Welcome |
| Distance and Open Staff |
| Enrolment |
| DE Courses/Units |
| Study Materials |
| Study Processes |
| Assignment Submission |
| Resources |
| Feedback |
| Useful Terms |
 |
Excel Hints and Tips
Sheets separate information. You may wish to answer different questions of your assignment on different sheets. When you open a new spreadsheet in Excel, you are automatically given three sheets. These are shown by white tabs at the bottom of the screen. Initially these sheets are named "Sheet 1", "Sheet 2" and "Sheet 3".
To move between sheets, simply click on the tab (at the bottom of the screen) of the sheet you wish to display. How do I rename my sheets?To rename your sheets, right click on the tab for that sheet and choose the option 'Rename'. Type the new name of the sheet into the tab, hit enter and the sheet's name will be changed.
You can also rename sheets by going to
To add a new sheet, right click on the tab for that sheet and choose the option 'Insert'.
You can also go to
Your new sheet will be added before the one you are currently working on. Sheet names are always initially given as 'Sheet 4', 'Sheet 5', etc.
How do I change the order of my sheets? To change the order of your sheets, click on the sheet you wish to move and drag it to its new position. Rightclick on the tab of the sheet you wish to delete and choose the option 'Delete'.
Alternatively you can go to
A dialogue box will prompt you to confirm the deletion. Once a sheet has been deleted, it cannot be recovered.
How do I hide my sheets so that my workings will not be displayed on the screen or printed? Click on the tab of the sheet you wish to hide. Go to
To display the sheet again (so that you can add or change data) go to
You will be prompted to choose which sheet you wish to display. How do I view the print preview? To view the print preview, either click on
You can also check the print preview from the print dialogue box by clicking on the button titled "Preview". To exit the print preview screen click on the 'Close' button. How do I adjust my margins in the print preview screen? To adjust your margins, click on the 'Margins' button to display them and then click and drag the margin lines (black dotted lines) to move them. Remember to keep at least 1cm margin around all four sides of your page to ensure no data is lost when printed. How do I adjust the page orientation in the print preview screen? Click on the 'Setup' button. Choose between landscape and portrait orientation. What is the page break preview? The page break preview shows you where page breaks will fall when your document is printed and allows you to adjust them to display text within the correct screens. Access the Page Break Preview by going to
To exit the page break preview go to
What are the dashed blue lines? The dashed blue lines indicate where page breaks will fall within your document as specified by Excel. When you move these lines they will become solid blue lines. What are the solid blue lines? Solid blue lines indicate page breaks you have inserted yourself. How do I move the page breaks? To move set page breaks, click and drag the dashed or solid line to the desired position. Keep in mind that if you make your document too long or too wide, Excel will scale down the size of your text when your document is printed. Where do I go for further help? For further help, view the Excel help file by clicking on
|
or go to
or pressing F1 whilst in Word.