Chapter 2: Print settings

Exercise 9: Make a long, wide table ready to print

Task

Set up the monthly sales detail to print in landscape, with all columns on one page and row 1 on every page.

Moves 0 (target 3)3 difference(s) from the model

File

Font

Alignment

Number

Styles

Cells

A1Press and release Alt to show KeyTips (Windows). Ctrl + 1 opens Format Cells, Ctrl + Z undoes.

	A	B	C	D	E	F	G	H
1	Branch	Apr	May	Jun	Jul	Aug	Sep	Total
2	Store 1	800	1160	1520	1880	1070	1430	7860
3	Store 2	1790	980	1340	1700	890	1250	7950
4	Store 3	1610	800	1160	1520	1880	1070	8040
5	Store 4	1430	1790	980	1340	1700	890	8130
6	Store 5	1250	1610	800	1160	1520	1880	8220
7	Store 6	1070	1430	1790	980	1340	1700	8310
8	Store 7	890	1250	1610	800	1160	1520	7230
9	Store 8	1880	1070	1430	1790	980	1340	8490
10	Store 9	1700	890	1250	1610	800	1160	7410
11	Store 10	1520	1880	1070	1430	1790	980	8670
12	Store 11	1340	1700	890	1250	1610	800	7590
13	Store 12	1160	1520	1880	1070	1430	1790	8850
14	Store 13	980	1340	1700	890	1250	1610	7770
15	Store 14	800	1160	1520	1880	1070	1430	7860
16	Store 15	1790	980	1340	1700	890	1250	7950
17	Store 16	1610	800	1160	1520	1880	1070	8040
18	Store 17	1430	1790	980	1340	1700	890	8130
19	Store 18	1250	1610	800	1160	1520	1880	8220
20	Store 19	1070	1430	1790	980	1340	1700	8310
21	Store 20	890	1250	1610	800	1160	1520	7230
22	Store 21	1880	1070	1430	1790	980	1340	8490
23	Store 22	1700	890	1250	1610	800	1160	7410
24	Store 23	1520	1880	1070	1430	1790	980	8670
25	Store 24	1340	1700	890	1250	1610	800	7590
26	Store 25	1160	1520	1880	1070	1430	1790	8850
27	Store 26	980	1340	1700	890	1250	1610	7770
28	Store 27	800	1160	1520	1880	1070	1430	7860
29	Store 28	1790	980	1340	1700	890	1250	7950
30	Store 29	1610	800	1160	1520	1880	1070	8040
31	Store 30	1430	1790	980	1340	1700	890	8130
32	Store 31	1250	1610	800	1160	1520	1880	8220
33	Store 32	1070	1430	1790	980	1340	1700	8310
34	Store 33	890	1250	1610	800	1160	1520	7230
35	Store 34	1880	1070	1430	1790	980	1340	8490
36	Store 35	1700	890	1250	1610	800	1160	7410
37	Store 36	1520	1880	1070	1430	1790	980	8670
38	Store 37	1340	1700	890	1250	1610	800	7590
39	Store 38	1160	1520	1880	1070	1430	1790	8850
40	Store 39	980	1340	1700	890	1250	1610	7770
41	Store 40	800	1160	1520	1880	1070	1430	7860
42
43

Set up the monthly sales detail to print in landscape, with all columns on one page and row 1 on every page.

This drill is for computer screens. On a phone you can review the steps.

Page Layout → "Orientation" → "Landscape"
Page Layout → set "Width" to "1 page"
Page Layout → "Print Titles" → $1:$1 in Rows to repeat at top
Press Ctrl + P and check where the pages break

Key takeaway

Before printing, check the page breaks and headers in the Ctrl + P preview.

See how to make a table in Excel for details.

← Back to all exercises