ADVERTISEMENT

How to set a print area in Google Sheets, so you can print selected cells or sheets

You can set a print area in Google Sheets to print selected cells or sheets.

Woman using Apple Mac laptop over colorful background
  • Google Sheets is part of the Google suite of online office programs. It's a spreadsheet program similar to Microsoft 's "Excel" or OpenOffice "Calc."
  • The print area is how much of your spreadsheet will be printed, and in what way.
  • .
ADVERTISEMENT

You can change the print area of Sheets in one of two ways by printing only certain cells, or by changing the layout on the page.

Here's how to do both.

ADVERTISEMENT

1. Open the Sheets document you wish to print.

3. Hit Ctrl + P on a PC, or Command + P on a Mac, or go to File, then select Print at the very bottom of the list.

ADVERTISEMENT

5. This will only print the highlighted region of the current sheet. Highlighting cells across sheets will not group them together.

If that doesn't work, then you can adjust the scale more precisely by setting Scale to "Custom number" and entering the preferred scale as a percentage number. Larger numbers make the sheet or cell bigger on the page and smaller numbers take up less space on the page.

ADVERTISEMENT

See Also:

ADVERTISEMENT

SEE ALSO: The best Google Assistant smart speakers you can buy

FOLLOW BUSINESS INSIDER AFRICA

Unblock notifications in browser settings.
ADVERTISEMENT

Recommended articles

10 African countries that waste the most food in 2024

10 African countries that waste the most food in 2024

US troop withdrawal from Niger hangs in the balance

US troop withdrawal from Niger hangs in the balance

Detained Binance executives sue Nigerian authorities for human right violation

Detained Binance executives sue Nigerian authorities for human right violation

Nigeria's central bank increases minimum capital base for banks

Nigeria's central bank increases minimum capital base for banks

Sony’s creators convention redefines the creative landscape for content creators

Sony’s creators convention redefines the creative landscape for content creators

Exploring the popularity of progressive jackpot slots in Indonesia

Exploring the popularity of progressive jackpot slots in Indonesia

Egypt, Nigeria, and South Africa ranked as Africa's most polluted countries in new report

Egypt, Nigeria, and South Africa ranked as Africa's most polluted countries in new report

10 African countries with the lowest life expectancy according to the World Bank

10 African countries with the lowest life expectancy according to the World Bank

Kenyan women are more obese than their men - here’s why

Kenyan women are more obese than their men - here’s why

ADVERTISEMENT