Extensions

In this extension, you will remove extra rows and columns from your spreadsheet to frame your pixel art image.

To begin, open your spreadsheet project.

Then, turn on the gridlines to see your cells.

Next, delete an empty row above or below your image to shift your entire image upward by one row.

You can delete rows one-by-one, but manually deleting rows is time-consuming and requires a lot of effort.

It’s more efficient to delete a large number of rows at once.

To delete all the rows beneath your image and remove any remaining empty space, click on the first row beneath your image.

Then select all the rows below it through the final row in your sheet.

And delete all the empty rows beneath your image.

Next, delete any extra columns to eliminate the empty space on the sides of your image...

And turn off the gridlines.

Now, it’s your turn.

Open your project, Turn on the gridlines, Remove all empty rows below your image, Remove all empty columns from the sides of your image, And turn off the gridlines.

In this extension, you will resize your columns and rows to create an exact grid with perfectly square cells.

This will ensure that the pixels in your image are even and that your final image is completely uniform.

You will use row height… ...and column width to change the dimensions of the cells in your image.

To begin, open your spreadsheet pixel art project.

Then, turn on the gridlines to see your cells.

Now select and resize the rows.

You may need to right-click on the selected rows to do this.

Enter a pixel dimension for the height of your rows.

Then select your columns and resize the column width.

Set the same pixel dimension for your column width that you set for your row height to ensure that all cells are even, exact squares.

Finally, hide the gridlines to see your updated image.

You can resize rows and columns in other ways, too.

For instance, you could make the row height bigger to stretch your image vertically or make the columns wider to stretch your image horizontally.

Try out different dimensions to see how your image looks.

Now, it’s your turn.

Open your project, Turn on the gridlines, Resize the row height, Resize the column width with the same pixel dimension, And turn off the gridlines.

In this extension, you will apply a color scale to change the colors in your project.

To do this, you’ll set a conditional formatting rule that adds a new set of colors to a copy of your project in Google Sheets.

A color scale allows you to assign a range of different colors to all the numbers in your image with a single conditional formatting rule.

With a color scale, you won’t need to set individual rules for every color, and you can automatically assign colors to an unlimited number of values.

To begin, make a copy of your project and rename it.

Turn on the gridlines.

Then, open conditional formatting.

Next, delete your original conditional formatting rules...

...and clear the sheet’s formatting to ensure that your previous image’s formatting is completely removed and only the numbers remain.

Then add a new rule....

...and select Color scale.

Confirm that the range is correct...

...and select a default color scale to use.

Then select new colors to customize the default color scale.

This will apply each base color to your minimum, midpoint, and maximum values.

The minimum value is the smallest number in your sheet.

The maximum value is the largest number.

The midpoint is the middle value in your color scale.

The percentile refers to how far between the minimum and maximum values your midpoint is.

A midpoint of 50 sets your median color exactly halfway between your minimum and maximum value colors.

Each base color then fills cells with your minimum, midpoint, and maximum values.

The numbers between these values are shaded with colors between the base colors that you selected.

Currently, the numbers are visible in your image.

To hide these values in the color scale, match the text colors with the fill colors by adding additional conditional formatting rules.

Minimum, midpoint, and maximum value colors are the exact colors you selected earlier.

Your color scale automatically uses custom colors for values between your minimum, midpoint, and maximum values.

You will find these colors in the custom color part of the palette.

It’s okay if you can’t find the exact color to match your text.

When you’ve matched all values and fill color settings as closely as possible, exit the conditional formatting panel...

...and remove the gridlines.

Enjoy experimenting with color scales to update your image! Now, it’s your turn.

Copy and rename your project, Turn on the gridlines and open conditional formatting, Add a new rule using color scale, Match text with colors, And remove gridlines.