Clue: A Cross____ is a popular type of puzzle (4 letters). Excel doesn't fit try WORD. A Word table is much better for creating a crossword. In Word you can make the whole thing in to a form, fillable on-line while ensure that input is restricted to one letter per square in upper case. Alternatively you can embed hidden answers and send the document to friends.
If you must use Excel use alternate rows for numbers and letters. To make a 13x13 grid, format 13 columns to a width of 4.4. format 26 rows alternately to height of 9 or 15. Each square of the crossword grid will be two cells high to be capable of accommodating a number and a letter. Within the grid area the cells in the smaller rows should be formatted to use 8 Point Courier New and aligned top right. In the larger rows cells should use Arial 16 and be aligned to 'center' both vertically and horizontally.
Put borders to define the grid squares, remembering that vertically there are two cells to a square. Hide the gridlines on the worksheet. Create black squares by changing the pattern in the two cells of a square to black.
Either choose a grid pattern first and find words and clues to fit or make up the pattern as you go along. Fill in the answers and make sure you number each square correctly. Save the result and then remove the answers and save the file under a different name.
Chat with our AI personalities