sodcalculator

10 Tech How-To

Pixel Art in Excel: Cell Formatting Guide

Guide 10-48831 · Updated · Step by step

This guide shows you how to turn an Excel worksheet into a pixel art canvas. By resizing cells into a grid and using the Fill Color tool, you can create detailed images that are easy to edit and share. No prior Excel experience is needed, just a computer with Excel and a picture or design in mind.

What You’ll Need

  • Microsoft Excel (2010 or newer works fine; the steps are the same for Windows and Mac)
  • A reference image (optional, but helpful for complex designs)
  • Basic familiarity with selecting cells and using the mouse

Step-by-Step

  1. Open a blank workbook. Launch Excel and create a new blank worksheet. You’ll see the familiar grid of rows and columns.
  2. Decide on your grid size. Pixel art is made of squares. The number of squares you want wide and tall determines your grid. For a simple icon, 20×20 is good. For a detailed character, 50×50 or more works. Write down your chosen width and height.
  3. Set the column width. Click the letter at the top of column A to select the entire column. Right-click and choose Column Width. Enter a number like 4 (this makes each cell roughly square). Repeat for column B, C, etc., until you have as many columns as your grid width. A faster way: select all columns you need (click and drag across their letters), then set the width once.
  4. Set the row height. Click the number at the left of row 1 to select the entire row. Right-click and choose Row Height. Enter the same number you used for column width (e.g., 4). Again, select all rows you need and set the height once. Now your cells are perfect squares.
  5. Create a color palette (optional but recommended). In a separate area of the sheet (like columns AA and AB), list the colors you plan to use. Type a label in one cell and fill the adjacent cell with that color. This gives you a quick reference and lets you copy exact fills.
  6. Start coloring. Click a cell, go to the Home tab, and click the Fill Color paint bucket icon. Choose a color. Click the next cell and repeat. For large areas, select a block of cells (click and drag) and apply the fill to all at once.
  7. Use a reference image. If you have a picture, place it in a separate worksheet (or keep it on your screen) and copy the colors cell by cell. Zoom out (Ctrl+minus or Cmd+minus) to see the whole grid while you work.
  8. Refine edges. After the main shapes are filled, go back and adjust individual cells to smooth curves or fix mistakes. Click a cell and choose a different fill color to correct it.
  9. Hide gridlines (optional). To see your art without the cell borders, go to the View tab and uncheck Gridlines. This makes the image look cleaner.
  10. Save and share. Save the file as an .xlsx. To share as an image, take a screenshot of the colored area, or copy the cells and paste into a graphics program (paste as picture).

Common Mistakes

  • Cells not square. If you set column width and row height to different numbers, your pixels become rectangles. Always use the same value for both.
  • Too many cells. Starting with a 100×100 grid when you’re new can be overwhelming. Begin smaller (20×20) and scale up.
  • Forgetting to hide gridlines. The default gridlines can make your art look busy. Turn them off for a cleaner finish.
  • Using the font color instead of fill. The paint bucket icon fills the cell background. The ‘A’ icon changes text color, which won’t show unless you type something.

Tips

  • Use a consistent grid size. If you set columns A-F to width 4, keep that for all rows and columns in your art area.
  • Zoom in (Ctrl+plus or Cmd+plus) for fine detail work, then zoom out to check the overall look.
  • For symmetrical designs, color one half, then copy and flip it. Select the half, copy (Ctrl+C), click the starting cell of the other half, and paste. Then use the rotate/flip options in the Paste menu.
  • Use the Format Painter tool to copy a fill color from one cell to another quickly. Select the colored cell, click the paintbrush icon, then click the target cell.
  • If you make a mistake, use Ctrl+Z (undo) immediately. You can also select a range and clear the fill by choosing ‘No Fill’ from the color palette.

Troubleshooting

  • My cells aren’t square after setting width and height. This happens when you set width and height to the same number but the units differ. In Excel, column width and row height are measured in different units (characters vs. points). A width of 4 and a height of 4 won’t be square. Instead, use the View > Page Layout mode and set both in inches or centimeters, or just eyeball it and adjust until they look square.
  • The fill color won’t apply. Make sure you have selected the cells first. If you’re trying to fill a merged cell, unmerge it first. Also check that you’re not in ‘Edit’ mode (double-clicking a cell) – press Esc to exit.
  • My grid is too small to work with. You can zoom in to see individual cells better, or increase the row height and column width. Note that increasing the size will make your final image larger on screen.
  • I want to change a color across the whole image. Use Find & Select (Ctrl+G) > Special > Constants, then choose the color you want to replace. However, this is limited. A simpler way is to use the ‘Replace Fill Color’ feature in some Excel versions, or just manually recolor cells.
  • The image looks distorted when I share it. If you take a screenshot, make sure the zoom level is set to 100% for accurate proportions. Alternatively, copy the cells and paste as a picture into another program – it will retain the square cells.

Frequently Asked Questions

Can I use this technique for animated pixel art?

Excel doesn’t support animation natively. You can create multiple sheets, each with a frame, and then use a macro or manual switching to simulate animation, but it’s not a built-in feature.

How do I export my pixel art as a PNG file?

Excel doesn’t export directly to PNG. Take a screenshot (Windows: Win+Shift+S, Mac: Cmd+Shift+4) and save the image, or copy the cells and paste into Paint or Photoshop, then save as PNG.

Is there a way to import a picture and automatically convert it to pixel art in Excel?

Not directly. You can insert a picture and trace over it manually, but Excel lacks an automatic pixelation tool. Third-party add-ins exist, but they’re not standard.

Can I print my pixel art?

Yes. Go to File > Print. Adjust the scaling to fit the art on one page. Set margins to narrow and uncheck gridlines in Page Setup to avoid printing the cell borders.

What’s the maximum grid size I can use?

Excel has a limit of 1,048,576 rows and 16,384 columns, so you can create huge grids. Practically, a 200×200 grid is manageable, but performance may slow down with very large grids.

Can I use conditional formatting to make pixel art?

Yes, you can use conditional formatting rules based on cell values to assign colors. This is useful for algorithmic art or when you have a data matrix. The manual fill method is simpler for hand-drawn designs.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →