Click either Outside Borders or Thick Box Border. Next, click the drop-down triangle next to the Borders button on the Formatting toolbar.Make sure that the cell you want to format is selected.(Later, you'll use a special tool on the toolbar to repeat the format of this cell elsewhere in the spreadsheet.) To add a dark border around the cell: Before you repeat these steps to format the other cells in the same way, format the cell so that it has a dark border around it.On the Font tab, select a small font size such as 8, and then click OK.On the Alignment tab, select Left (Indent) from the list under Horizontal, and select Top from the list under Vertical.First, click in a cell where a number belongs.To insert a tiny number in the top-left corner of a cell: After you have set up the columns and rows, format the cells that will include the small numbers indicating crossword puzzle clues.An average height is 24.00 (or taller for younger students). As you drag, note that the height of the rows pops up. (Your mouse pointer will change to a double-sided arrow when you are in the right place.) Drag down to make all of the selected rows taller. Point between the row numbers for two selected rows.Click the row number (on the left edge of the spreadsheet) for the first row that will be part of your puzzle, and drag down to include as many rows as you need.To change the height of many rows at the same time: For example, in the samples above, rows 3-12 are taller than the other rows. Next, change the rows of your puzzle to be taller.A good width for a crossword puzzle is about 4.00 (or larger for younger students, so that the fill-in boxes are bigger). As you drag, note that the width of the columns appears just above the column headings. (Your mouse pointer will change to a double-sided arrow when you are in the right place.) Drag left to make all of the selected columns smaller. Point between the letters at the top of the columns, where two selected columns meet.For example, select columns A-U if your puzzle will be that many columns wide. Click on a column letter at the top of the spreadsheet, and drag the mouse across as many columns as you need for your puzzle.To change the width of several columns at once: Begin by making a group of columns very narrow these will be the columns for your crossword puzzle.Start Microsoft Excel, and make sure a new, blank worksheet is open.On graph paper, sketch out a crossword puzzle to go along with any curriculum area or lesson.Using the Format Painter tool to repeat formatting.Formatting a number in a cell so that it is not only small, but also positioned at the top left of the cell.Changing multiple column widths at the same time.The Excel features that will be used in this exercise are: Puzzle with extra formatting and two columns of clues next to each other Students can write a crossword puzzle, then trade with a classmate to solve each other's puzzle - a great way for students to review before a test. Because of the unique column and row layout in Excel, as well as its cell formatting features, students can design a crossword puzzle to learn vocabulary words, definitions, and concepts that are relevant to practically any area of the curriculum. Students design their own crossword puzzle. Use special formatting features to design a crossword puzzle. How-To: Design a crossword puzzle in Microsoft ExcelĮnglish/ Mathematics/ Studies of Society and
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |