When you need to print only specific cells from your Google Sheets on your iPhone, you might find yourself wondering how to do it. While Google Sheets doesn't directly support printing selected cells, there's a handy workaround that allows you to achieve this. Let's delve into a step-by-step guide to help you accomplish this task with ease.
Before we dive into the process, ensure you have the Google Sheets app installed on your iPhone. If not, you can download it from the App Store. Once you're set, let's explore two methods to print selected cells: using the ' Freeze Panes' feature and the 'Copy and Paste' method.
Method 1: Using Freeze Panes
The 'Freeze Panes' feature in Google Sheets allows you to keep specific rows or columns in view while scrolling through the rest of the data.
To use this method, you'll first need to froze the columns or rows containing the cells you want to print.
Freeze Rows
To freeze the top rows containing the cells you want to print, follow these steps:
1. Open the Google Sheets app on your iPhone.
2. Navigate to your spreadsheet and tap 'Edit' in the top-right corner.
3. Tap 'Freeze' and then select the number of rows you want to freeze (it should include the cells you want to print).
4. Now, when you scroll down, only the frozen rows will scroll up and down, keeping your selected cells in view.
5. To print, tap the three vertical dots (⋮) in the top-right corner and select 'Print'. Ensure your iPhone is connected to a printer, and then follow the on-screen instructions to print the selected cells.
Freeze Columns
If you want to freeze the columns containing the cells you want to print, follow these steps:
1. Open the Google Sheets app on your iPhone.
2. Navigate to your spreadsheet and tap 'Edit' in the top-right corner.
3. Tap 'Freeze' and then select the number of columns you want to freeze (it should include the cells you want to print).
4. Now, when you scroll to the right, only the frozen columns will scroll left and right, keeping your selected cells in view.
5. To print, tap the three vertical dots (⋮) in the top-right corner and select 'Print'. Follow the on-screen instructions to print the selected cells.
Method 2: Copy and Paste
Another method to print selected cells is to copy them into a new Google Sheets document and then print the entire document.
Here's how to do it:
Copy and Paste into a New Document
1. Open the Google Sheets app on your iPhone.
2. Navigate to your spreadsheet and select the cells you want to print by tapping and dragging over them.
3. Tap 'Copy' in the top-right corner or use the 'Copy' shortcut (Ctrl + C on an external keyboard).
4. Tap the plus (+) icon in the bottom-right corner to create a new Google Sheets document.
5. Tap inside the new document and then tap 'Paste' in the top-right corner or use the 'Paste' shortcut (Ctrl + V on an external keyboard). This will paste the copied cells into the new document.
6. Now, to print, tap the three vertical dots (⋮) in the top-right corner and select 'Print'. Follow the on-screen instructions to print the selected cells.
Printing selected cells from Google Sheets on your iPhone can be a breeze once you know the tricks. Experiment with these methods to find which one works best for you, and enjoy the convenience of printing only the information you need. Happy printing!