How to Print Only Certain Columns in Google Sheets (3 Ways)

Printing in Google Sheets is multifaceted. Usually, we print the current sheet we are working on. However, sometimes we only need to print certain columns that are important and we try to avoid printing unnecessary columns. Even we print certain columns only to maintain a specific font size due to the limitation of the page size. In this article, we are going to demonstrate how to print only certain columns in Google Sheets.

How to print only certain columns in Google Sheets


A Sample of Practice Spreadsheet

You can download the spreadsheets from the link below. The spreadsheets contain a dataset we use here. After downloading you can print only certain columns as we do in this demonstration.


3 Easy Ways to Print Only Certain Columns in Google Sheets

Printing certain columns in Google Sheets is simple but useful. In this article, we demonstrate three different ways to print only certain columns in Google Sheets using the dataset below.

Dataset to print certain columns in Google Sheets


1. Using Keyboard Shortcut

The keyboard Shortcut is the easiest way we can employ to print only certain columns in Google Sheets. In this, method a single keyboard shortcut takes us from selected columns to the printing window.

📌 Steps:

  • First of all, we have to select certain columns to print. Here we select Column C and Column D to print.

Selecting certain columns to print in Google Sheets

  • Next, we press Ctrl+P to print the selected columns only. As a result, we got the following Print settings tab.
  • Afterward, we select the Print box from the Print settings tab as indicated.

Use of keyboard shortcut to print certain columns

  • From the Print box, we select Selected cells(C:D) to print Column C and Column D only.

Changing the Print option to Selected cells

  • Then we customize the Paper size as A4 and choose the Portrait page orientation for a better printing layout.
  • Finally, we select Next.

Changing Paper size and Page orientation

  • Selecting Next opens the following window with a printing preview. Now we just click on Print to print the selected columns.

Clicking on Print to print selected columns

Read More: How to Print Google Sheets on One Page (2 Distinct Scenarios)


Similar Readings


2. Utilizing File Menu

The next way of printing certain columns involves the utilization of the file menu. The file menu is easily accessible and it’s the first menu of the menu bar.

📌 Steps:

  • Initially, we select Column C and Column D as earlier.

Selecting certain columns to print in Google Sheets

  • Then we go to File >>Print from the menu bar like the image below.

Selecting Print from file menu

  • As a result, we will get the following Print settings tab. Afterward, we select the Print box from the tab as indicated.

Use of file menu to print certain columns

  • We select Selected cells(C:D) from the Print box to print Column C and Column D only.

Changing the Print option to Selected cells

  • Then we customize the Paper size as A4 and choose the Portrait page orientation for a better printing layout. Lastly, we select Next.

Changing Paper size and Page orientation

  • Once we select Next we get the following window with a printing preview. At last, we click on Print to print the selected columns.

Clicking on Print to print selected columns

Read More: How to Print Notes in Google Sheets (with Quick Steps)


3. Using Print Icon

The Print icon is the last way we’ll discuss for printing only certain columns in Google Sheets. The Print icon is an easily visible icon and one of the fastest ways of printing certain columns in Google Sheets.

📌 Steps:

  • At the very beginning, we select Column C and Column D as usual.

Selecting certain columns to print in Google Sheets

  • Afterward, we click on the Print icon of Google Sheets as indicated. This usually appears just below the menu bar.

Clicking on Print Icon to print certain columns in Google Sheets

  • Consequently, we get the Print settings. Then we select the Print box from the tab as indicated.

Use of print icon to print certain columns

  • Next, we select Selected cells(C:D) from the Print box to print Column C and Column D only.

Changing the Print option to Selected cells

  • Then, we change the Paper size to A4 and choose the Portrait page orientation for a better printing layout as earlier. Finally, we select Next.

Changing Paper size and Page orientation

  • Once we select Next we get the following window with a printing preview. Finally, clicking on Print prints the selected columns only.

Clicking on Print to print selected columns

Read More: How to Print Row Numbers in Google Sheets (4 Useful Methods)


Things to Remember

  • Make sure the selected columns are contiguous if you select multiple columns for printing.
  • Your printer needs to be connected to the computer.

Conclusion

Printing certain columns is a simple task. I believe from now on you can implement all the ways to print only certain columns in Google Sheets. Furthermore, If you have any queries or suggestions regarding this article feel free to comment below and I will try to reach out to you soon. Visit our website OfficeWheel for the most useful articles.


Related Articles

Laku

Laku

Hey, I'm Zahidul Islam Laku. I completed my graduation from Bangladesh University of Science and Technology (BUET). I write articles about a variety of tech topics. I enjoy using my abilities as a creative thinker and problem-solver to develop original solutions to issues.

We will be happy to hear your thoughts

Leave a reply

OfficeWheel
Logo