Excel
Browse school help by topic, or search for a device, account, or learning platform.
Help by category
8 articlesUse this simple example for classroom resources or practice data. Check important totals against an independent calculation. Enter sample numbers in cells B2 to B6.
Read article Excel: display dates consistently in a planning sheetDate appearance depends on formatting and regional settings. A date typed in an ambiguous format may be interpreted differently on another device. Use a copy of the planning sheet for testing.
Read article Excel: filter a resource table without deleting rowsFiltering hides rows temporarily; it does not remove them. Use a copy to practise if the sheet contains important records. Check the table has clear column headings and no unrelated data mixed into its range.
Read article Excel: investigate a formula error without hiding itAn error can indicate a missing value, changed reference or unsupported calculation. Replacing every error with zero can hide a real problem. Keep a copy and select the affected cell.
Read article Excel: keep column headings visible while scrollingFreeze Panes keeps headings visible without changing the data. This is useful for long resource lists and planning sheets. Open the correct worksheet and identify the row containing your headings.
Read article Excel: make a chart from classroom practice dataUse a small, non-sensitive table to practise charts. Choose a chart that explains the learning point without displaying unnecessary personal information. Create a clear table with headings and a few sample values.
Read article Excel: print a worksheet without cutting off columnsCheck the preview before printing a spreadsheet. Fitting everything onto one page can make the text too small. Select the worksheet you need and open File, Print.
Read article Excel: show long notes using Wrap TextWrap Text displays a cell contents over several lines. It changes the presentation rather than the stored words. Select the cells containing long notes.
Read article