The range should read 1:1000 indicating you are applying the conditional formatting to all 1000 rows. Right click in the spreadsheet to choose “Conditional formatting.” This will open up a side panel to define the rules for formatting. Conditional formatting will automatically fill the cell with a color the student defines the number to match with.Ĭlick on the awesome box to select all of the cells. Students can type in numbers into the cells to create the patterns they desire. Just to get crazy, students can do spreadsheet pixel art paint by numbers style. Filling a cell with a color and then going back to the paint can and choosing “custom” allows the student to fine tune the fill color.Ĭonditional Formatting – Paint by Numbers Using the paint can in the toolbar students can click on a cell and fill the cell with a color. The number of columns you highlight is the number of columns you can insert. Highlight the columns and right click to insert additional columns. Insert ColumnsĪfter I click on the “awesome box” and resize the columns to create a grid of squares for my pixel art I realize I need the spreadsheet to have more columns. Resizing one column will resize all of the columns to the same width.Ĭlicking on the “awesome box” to the left of the column indicators will highlight ALL of the cells in the spreadsheet. You can resize columns by highlighting the columns and placing your cursor in between the column indicators. To create pixel art you need all of the cells to be squares instead of rectangles. Make Your Pixel Art Grid – Resize Columns in Spreadsheet This is not only a fun activity, but a good excuse to get students started with spreadsheets… a valuable life skill. Students can draw and represent objects as pixel art by coloring cells in the spreadsheet grid. A fun use of spreadsheets is to create Pixel art.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |