How To Print First Row Or Column On Every Excel Page

• Add a header to print your company name, address, logo, etc., on every page.
• Use Freeze panes to lock the 1st row and 1st column of an Excel sheet.
• Uncheck Headings (View > Show pane) to hide Column name and Row numbers.

Print the First Row or Column on Every Excel Page

Step 1: On your workbook, select the desired sheet and navigate to the Page Layout tab on the ribbon.

Step 2: Then, click on the icon for Page Titles under the Page Setup section.

Step 3: In the Page Setup modal window, switch to the Sheet tab and spot the section for Print titles . It includes row and column options.

Note: Though we focus on the header row, the setting can also be applied to columns.

Step 4: To set up printing of the top row on each page, click on the Arrow up button in front of ‘Rows to repeat at top’ text box. For columns, take the second one.

Step 5: That will take you to the Excel sheet along with a dialog box. Click row number 1 (on the sheet) and press the arrow-down button in front of it.

Here, you can select multiple rows on each page if you wish to repeat them. Generally, you would want the top row and, in rare circumstances, the leftmost column.

Step 6: Back in the Page Setup modal window, you will see the text boxes populated with the row/column values to repeat on each page. You can choose Print Preview to ensure the print includes a header or columns on all pages.

In the print preview, check whether the settings work. Note that the settings are sheet-specific and do not apply to the workbook.

If you cannot print, check out the guide on Excel printing fixes .

How Do You Print Row and Column Numbers When Printing in Excel?

Sometimes, you also want to print row headings 1, 2, . . . and column headings A, B, . . . To achieve this, navigate to Page Layout > Sheet Options and check the Row and column headings box in the Print section.

Why Is Print Titles Button Greyed Out?

If you cannot access the Print Titles button, it might be because you are editing a cell or have a chart selected. Similarly, if you cannot use the Rows to repeat at the top spreadsheet icon, it could be because you have selected multiple worksheets within your workbook.

Was this helpful?

• Corrupted Excel files, faulty add-ins, and outdated printer drivers are some of the most common causes of this issue.
• Try printing another Excel file to ensure the issue is not limited to a specific spreadsheet.
• You can try running the Microsoft Office repair tool if nothing else works.

Fix 1: Save Your Excel File in XPS Format and Try Again

If Excel can’t respond to print requests, save your file in the XPS format and try again. Several users on Microsoft Community post reported fixing the issue with this simple workaround. So, if you’re in a rush, try this method.

Step 1: Open the Excel file you wish to print and click the File menu at the top left corner.

Step 2: Navigate to the Print tab and use the drop-down menu under Printer to select Microsoft XPS Document Writer . Then, click the Print button.

Step 3: When the Save Print Output As dialog appears, save your Excel file in the XPS format. It should print without issues.

Fix 2: Open Excel in Safe Mode

You can try printing an Excel file in safe mode to see if one of the third-party add-ins is causing the problem. For that, press the Windows key + R to open the Run dialog. Type excel -safe in the box and press Enter .

Check to see if Excel prints your file in safe mode. If it does, one of the third-party add-ins is to blame. You can disable all add-ins and re-enable them individually to isolate the culprit.

Step 1: Open Microsoft Excel and go to File > Options .

Step 2: In the Excel Options window, switch to the Add-ins tab from the left column. Select COM Add-ins in the Manage drop-down menu and click the Go button.

Step 3: Uncheck all the Add-ins and click OK .

After this, restart Excel and enable your add-ins one at a time. Print a test page after enabling each add-in to identify the one causing the issue.

Fix 3: Update Printer Driver

Issues with your printer driver can affect Excel’s ability to print spreadsheets and lead to problems. To avoid this, you should ensure that your printer driver is up to date and functioning properly.

Step 1: Right-click on the Start icon and select Device Manager from the menu that appears.

Step 2: Double-click on Print queues to expand it. Right-click on your printer and select Update driver .

Follow the on-screen prompts to finish updating the printer drivers. After that, try printing your file again.

Fix 4: Remove and Reinstall Your Printer

If Microsoft Excel still can’t print, try removing your printer and re-adding it on Windows. Here’s how to do it.

Step 1: Press the Windows key + I to open the Settings app.

Step 2: Select Bluetooth & devices from the left sidebar and go to Printers & scanners .

Step 3: Select your printer from the list.

Step 4: Click the Remove button at the top to delete your printer.

Step 5: After that, return to the Printers & scanners menu and click on Add device . Then, follow the on-screen prompts to add your printer again.

Fix 5: Repair Microsoft Office

Microsoft Office offers a handy repair tool for any issues with Office apps. If nothing else works, consider repairing Microsoft Office by following the steps below.

Step 1: Right-click on the Start icon and select Installed apps from the list.

Step 2: Scroll down to locate the Microsoft Office product on the list. Click the three-dot menu icon next to it and select Modify .

Step 3: Select Online Repair and hit Repair .

Was this helpful?

• Add a header to print your company name, address, logo, etc., on every page.
• Use Freeze panes to lock the 1st row and 1st column of an Excel sheet.
• Uncheck Headings (View > Show pane) to hide Column name and Row numbers.

Print the First Row or Column on Every Excel Page

Step 1: On your workbook, select the desired sheet and navigate to the Page Layout tab on the ribbon.

Step 2: Then, click on the icon for Page Titles under the Page Setup section.

Step 3: In the Page Setup modal window, switch to the Sheet tab and spot the section for Print titles . It includes row and column options.

Note: Though we focus on the header row, the setting can also be applied to columns.

Step 4: To set up printing of the top row on each page, click on the Arrow up button in front of ‘Rows to repeat at top’ text box. For columns, take the second one.

Step 5: That will take you to the Excel sheet along with a dialog box. Click row number 1 (on the sheet) and press the arrow-down button in front of it.

Here, you can select multiple rows on each page if you wish to repeat them. Generally, you would want the top row and, in rare circumstances, the leftmost column.

Step 6: Back in the Page Setup modal window, you will see the text boxes populated with the row/column values to repeat on each page. You can choose Print Preview to ensure the print includes a header or columns on all pages.

In the print preview, check whether the settings work. Note that the settings are sheet-specific and do not apply to the workbook.

If you cannot print, check out the guide on Excel printing fixes .

How Do You Print Row and Column Numbers When Printing in Excel?

Sometimes, you also want to print row headings 1, 2, . . . and column headings A, B, . . . To achieve this, navigate to Page Layout > Sheet Options and check the Row and column headings box in the Print section.

Why Is Print Titles Button Greyed Out?

If you cannot access the Print Titles button, it might be because you are editing a cell or have a chart selected. Similarly, if you cannot use the Rows to repeat at the top spreadsheet icon, it could be because you have selected multiple worksheets within your workbook.

Was this helpful?

Excel

Every keyboard, whether external or laptop, comes with a print screen button abbreviated as PrtScr. Pressing the print screen button will capture the whole screen that you can later paste in an app like Paint . It is one of the fastest ways to take a screenshot on Windows. For some users, PrtScr key is unresponsive or just not working. In that case, you can use a keyboard shortcut or an app for taking screenshots. Why would you do that when you have a dedicated screenshot key on the keyboard?

The print screen is a universal button that’s available on all Windows 10 computers and works the same way. Typically, it is located at the top row after the function keys. Way before browser extensions and third-party apps were available, there was a print screen option, and many people still prefer to use it because it’s quick and works everywhere. So when it stops working, that inconvenience often irks.

Let’s find how we can fix the print screen not working error on your Windows 10 computer.

1. Use Keyboard Shortcuts

There are other ways to take screenshots using a combination of PrtScr buttons. Try using Alt+PrtScr shortcut instead. That will take a screenshot of the currently selected window instead of the whole screen—no need to crop or remove unwanted background now.

When you use the Windows key+PrtScr shortcut, the screenshots of the fullscreen gets saved to the Pictures > Screenshots folder. If you use a keyboard or a laptop with Fn key, then you are in luck. You can use it along with Windows or Alt key combination.

Some keyboards come with an F Lock key instead of the Fn key. If that’s the case, you don’t have to press and hold it. Just press it once to activate it as you do with caps lock.

Pro Tip: Press Windows key+Shift+S to launch a new, flexible way to take screenshots. Your screen will fade, and you will notice a floating bar at the top. Use your mouse to select an area on the screen to take a screenshot of. The feature was earlier part of OneNote, but Microsoft included it with the Windows 10 Creators Update.

2. Taken Over as a Third-Party App Shortcut

The shortcut may have been associated with a third-party app like Dropbox, as noted by one user named gbbay in Microsoft support forums. It could be an app that you recently updated or installed. So, check if any third party app has taken over it.

3. Keyboard Hardware

Did you try with another keyboard? There may be something wrong with your current keyboard, and it needs fixing . Make sure everything is working with keyboard hardware and software. Connect your keyboard to another computer to check or borrow a friend’s keyboard for your computer instead. At times, the USB port may not be able to detect the keyboard properly.

4. Hardware Troubleshooter

All Windows 10 editions come with a hardware troubleshooter that will check for errors in external devices like mice, keyboards, printers, etc.

Step 1: Press Windows key+I shortcut to launch Settings. Once it opens, search for ‘Find and fix keyboard problems’ and click to open it.

Step 2: Select ‘Apply repairs automatically’ option at the bottom and click on Next to continue.

Windows will now look for problems and suggest a solution as required. It will then apply the solution if within its rights.

5. Registry Editor

Unlike Group Policy Editor, which comes preinstalled in Windows Pro and higher versions only, Registry Editor is available in Windows Home.

Step 1: Search for and open it from the Start menu. Make sure you run it with admin rights, as shown in the screenshot below.

Step 2: Drill down to the folder structure below.

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer

Step 3: Find a file named ScreenshotIndex in the right pane of the window. You don’t have to do anything if the file already exists. If the file is missing, right-click on a space in the right window-pane and select DWORD (32-bit) Value under New. I have the file, as shown in the screenshot below.

Step 4: Name the newly created file as ScreenshotIndex and double-click to open it. The Hexadecimal Value data should be set to 4.

Step 4: Navigate to this folder now.

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders

Step 5: Locate and open this file.

{B7BEDE81-DF94-4682-A7D8-57A52620B86F}

Step 6: Double-click on the file to ensure that the Value data is set to %USERPROFILE%\Pictures\Screenshots . If the file is missing, create a String Value file instead of the DWORD file as we did above and enter the value as discussed.

If that doesn’t work, try 695 instead of 4 as the value in step 4 and try again.

6. Try Third-Party Apps

There are plenty of apps available that you can use to take screenshots. Microsoft has been offering the Snipping Tool for years now. Then there are browser extensions that you can use with additional built-in features like screen recording.

Put It on the Screen

I continue to use the print screen feature on my Windows 10 laptop. It helps me take screenshots of screens where other apps don’t work. For example, the Start menu. It disappears the moment you click on anything else. The print screen feature solves this issue, but so does some other apps and options discussed above.

Next up: Are you using a multi-monitor setup? Click on the link below to learn how to take screenshots on a specific monitor on Windows 10.

Was this helpful?

• You can’t directly save emails as PDFs in Outlook or Gmail apps for iOS.
• Use the Print function and redirect it to create a PDF.
• Select Save to Files and choose a location to save the PDF.

Print Emails to PDF in Outlook for iOS

Step 1: Open the email you want to convert.

Step 2 : Once it loads, tap the three-dot icon and follow up by tapping Print Conversation .

Step 3 : Perform a Zoom Out gesture over any generated thumbnails within the Printer Options screen. That will convert the email to PDF format immediately.

Step 4: Share the PDF with a third-party app or save it locally using the Save to Files option.

How to Print Emails to PDF in Gmail for iOS

Step 1: Open the email you want to save as a PDF file.

Step 2 : Next, tap the three-dot icon next to the Reply icon. On the menu that shows up, tap Print .

Step 3: Tap AirPrint to continue. On the Printer Options screen, perform a Zoom Out gesture over any listed thumbnails to convert the email to PDF format.

Step 3: Tap the Share option on the PDF preview screen and share the converted email to a third-party app or save it to the Files app.

Converting emails to PDF format while using Outlook for iOS or Gmail for iOS is easy. You can also do the same on any other email client, be it Spark, Airmail, or Edison Mail, using the same Print gesture within the Printer Options screen as long as you can find the Print option.

Was this helpful?

Have you been told to take a screenshot using the Print Screen key on your Windows 10 computer? And now you are left wondering where the Print Screen button is? Even if you found the button and pressed it, nothing would have happened. So you are more confused now. Don’t worry. We are here to help. By the end of the post, you will be a champ in using the Print Screen button to take screenshots on Windows 10.

Questions like where is the Print Screen button, how to enable Print screen, and how to use the Print screen button are answered in this post. We have also covered how to take a screenshot in Windows 10 without the Print screen button.

Let’s get started on discovering the superpowers of the Print Screen button in Windows 10.

Where Is the Print Screen Button

The Print Screen button is usually present at the upper right side of your keyboard. You will see one of the text labels on the key:

• Prt sc
• PrtSc
• PrtScn
• PrntScrn

If something else is mentioned along with the print screen button, then you will have to trigger it with the function key (fn) on your keyboard. That is, hold the fn key and the Print screen buttons together to take a screenshot.

Tip : If your keyboard doesn’t have the Print Screen button , use the Function (fn) + Windows key + Spacebar to take a screenshot. In case the Print screen isn’t working , check out various ways to fix it.

How to Use Print Screen Button to Take Screenshot in Windows

There are several ways to take a screenshot using the Print screen button on Windows 10. Let’s check them out.

Method 1: Capture Entire Screen With Print Screen

This is the simplest method to take a screenshot on Windows 10. Pressing the Print Screen key on your keyboard copies the entire (active) screen to your clipboard . Even though a screenshot is technically captured, it’s not saved anywhere on your computer.

The screenshot resides in your computer’s clipboard for a temporary period till you copy something else. You need to paste the copied content (the screenshot) in a supported app such as MS Paint, Paint 3D, etc. Use Ctrl+V keyboard shortcut to paste the image. Once pasted, save the image using the app’s save button. It’s not necessary to paste the screenshot in photo-editing apps, you can even paste it in Microsoft Word or Google Docs .

Note: Use fn + Print screen combination if nothing is copied to the clipboard.

Typically, when you take a screenshot on your mobile phone, the screen will dim for a second, which indicates that a screenshot is taken. However, nothing will happen to the screen using this method. The screen won’t dim when you simply press the Print Screen button. So don’t get scared, just open any supported app and paste the copied screenshot.

Tip: If you use OneDrive, your captured screenshots will automatically be saved in your OneDrive folder. In case you are notified that screenshots are saved in OneDrive, find out how to turn off that notification and how to disable storing of screenshots in OneDrive .

Method 2: Capture and Save Entire Screen Using Print Screen

The above method doesn’t save the screenshot directly to your computer. To save screenshots on your PC without pasting them first, press the Windows key + Print screen button simultaneously. The screen will dim for a second, indicating that a screenshot has been taken. In this method, the entire screen is captured.

You will find the captured screenshots in the Pictures > Screenshots folder. If you don’t find that, follow this path C:\Users\username\Pictures\Screenshots.

Method 3: Capture Active Window With Print Screen

Instead of capturing the entire screen, this method will help you take a screenshot of an active window. Let’s say you want to take a screenshot of the minimized Word screen. You can do it by using the Alt + Print screen keyboard shortcut. Press both buttons simultaneously to take a screenshot of your active window.

Similar to method 1, the screenshot will not be saved directly. You will need to paste it into a supported app such as MS Paint and then save it.

Method 4: Assign the Snipping Tool to Print Screen Key

If the above methods do not meet your requirements, you can assign the Windows 10 Snipping tool to the Print screen key. When you do so, the Snipping tool will get activated when you press the Print screen key on your keyboard.

With the Snipping tool, you can take custom screenshots. You can choose the area whose screenshot you want to take, capture the selected window, and perform other advanced tricks. The screenshots will open in the Snipping Tool where you can annotate and draw on them. Finally, save the screenshot. Check out various tips and tricks related to the Windows 10 Snipping Tool .

To assign the Snipping tool to the Print screen key, follow these steps:

Step 1: Open Settings on your Windows 10 PC from Start Menu. Alternatively, use Windows + I keyboard shortcut to open settings. Go to Ease of Access.

Step 2: From the left sidebar in Ease of access, scroll down and click on Keyboard. On the right side, you will find Keyboard settings. Scroll down and enable the toggle for Print Screen shortcut.

Bonus: How to Take Screenshot Without Print Screen on Windows 10

If you don’t want to remap the Print screen key to the Snipping tool or use Print screen to take a screenshot, you can still open the Snipping tool using the Windows key + Shift + S keyboard shortcut. Alternatively, open the Snipping tool from the Start Menu. You can also use the Snip and Sketch tool of Windows to take a screenshot without the Print screen button. Find out what’s the difference between the Snipping Tool and Snip and Sketch on Windows 10.

The Best Method

Methods 2 and 4 are convenient for taking and saving screenshots both. I mostly settle for Method 4 on my computer where I use the Snipping tool with the help of the Print screen button. It lets me take a screenshot with the ability to draw on them.

Next up: If for some reason, you are unable to take screenshots on your Windows 10 PC, check out 4 ways to fix it from the next link.

Was this helpful?

• You can print photos from your iPhone without requiring a Wi-Fi connection.
• Open the Photos app > choose your photo > Share icon > Print > printer name > choose Printer name > Print.
• You can create a hotspot between your printer and iPhone if you don’t have Wi-Fi access.

Print From iPhone Using Wi-Fi

iPhones have a feature called AirPrint that allows you to print from your iPhone over Wi-Fi . However, to make this feature work, you’ll need to ensure your printer also supports Wi-Fi connectivity. Once you confirm that, here’s how to print photos using an iPhone with a Wi-Fi connection.

Step 1: Connect your printer with your Wi-Fi network.

Step 2: Open the Photos app on your iPhone.

Step 3: Open the photo or document that you wish to print and tap on Share at the bottom.

Step 4: Tap on Print . A new window with different print options will open on your screen. Tap on the Printer option at the top to see available printers.

Step 5: Select your printer from the list. After this, you will see some more printing options, such as Presets, Number of Copies, Paper Size, and Media and quality .

Step 6: After selecting your options, tap on Print .

Print From iPhone Using Hotspot

There are two ways to print from an iPhone without Wi-Fi. The first one is by creating a hotspot between your printer and iPhone. This means that there is no Wi-Fi network around you. But ensure your printer supports Wi-Fi connectivity.

Before we begin the steps, ensure your printer has a blinking LED indicator next to the Wi-Fi logo. We used an HP Printer for this article.

Step 1: Open Settings on your iPhone > tap on Wi-Fi .

Step 2: Tap on your printer name from the list > enter the password to connect.

You can check for the printer password by going to the Wireless menu of your printer.

Step 3: Open the Photos app > tap on the photo or document that you wish to print > tap the Share icon .

Step 4: Scroll down and tap on Print . Choose your printer, printing options , and then tap Print .

This is how you can print from your iPhone without a Wi-Fi connection.

Print From iPhone Without Wi-Fi Using an OTG Cable

Lastly, we have a method where you can connect your iPhone and printer with a USB OTG cable. After connecting your iPhone, follow these simple steps.

Step 1: After connecting your iPhone , tap on Yes on the pop-up menu appearing on your screen.

Step 2: Open the Photos app > choose your photo > tap on Share > Print > choose your options > tap Print .

This is how you can print from an iPhone if your printer doesn’t support Wi-Fi connectivity. However, you need a USB OTG cable to connect to your iPhone.

Was this helpful?

• You may start by enabling the Microsoft Print to PDF feature.
• Running the printer troubleshooter will fix any underlying problems that cause this printer issue.
• If the issue is caused by outdated or corrupt drivers, uninstalling and reinstalling the printer should work.

Fix 1: Ensure Print to PDF Is Enabled in Windows Features

Microsoft Print to PDF integrates into the Print dialog box on your PC. Sometimes, the feature no longer appears when you open the Print dialog box for a certain file. Whatever the reason, you can ensure the feature is enabled with the following steps.

Step 1: Click the Start button, type Windows Features , and click the first result .

Step 2: Find and check the box for Microsoft Print to PDF .

Note : If it’s already enabled, disable it and wait a few seconds. Then, repeat the steps to open Windows Features and enable the feature again.

Step 3: After that, click on OK .

If you need to install it, follow the on-screen instructions and proceed. Reboot your PC and open the Print dialog once again. You should see the Print to PDF option back.

Now, you can save images and perform other functions using Microsoft Print as PDF.

Fix 2: Run the Print Troubleshooter

Using the built-in print troubleshooter would resolve most problems and is a good fix when Microsoft Print to PDF is not working on Windows 11.

Step 1: Click the Start button, type Control Panel , and press Ente r to open the Control Panel on your Windows 11 PC.

Step 2: Click on View devices and printers under Hardware and Sound.

Step 3: Click Printer & scanners .

Step 4: Click Microsoft Print to PDF .

Step 5: Click on Run the troubleshooter and follow the wizard to complete the process.

Step 6: Click Next and follow the wizard to complete the troubleshooting.

Fix 3: Uninstall and Reinstall Print to PDF Drivers

Your PC comes with Microsoft Print to PDF drivers pre-installed by default. If you haven’t updated these drivers recently, they could have become obsolete, preventing the feature from functioning. Uninstall the drivers and reinstall them using the steps below.

Step 1: Click the Start button, type Control Panel , and press Ente r to open the Control Panel on your Windows 11 PC.

Step 2: Click on View devices and printers under Hardware and Sound.

Step 3: Click Printer & scanners > Microsoft Print to PDF .

Step 4: Lastly, click on Remove .

Now, you may reinstall it by following the steps below.

Step 5: Click the Windows button, type Windows PowerShell , and select Run as Administrator from the right pane.

Step 6: Type the following command and hit Enter :

Enable-WindowsOptionalFeature -online -FeatureName Printing-PrintToPDFServices-Features -All

Step 7: You should see the text True next to Online. This confirms that the feature has been re-enabled.

Step 8: Finally, restart your computer and check if Print to PDF works as intended.

Fix 4: Set Print to PDF as Your Default Printer

Print to PDF is essentially a software feature that emulates the presence of an actual printer. Hence, setting it as your default printer might be a good option. This way, giving the print command on any document should automatically trigger Print to PDF. Here’s how to set it as your default printer on Windows 11.

Step 1: Click the Start button, type Control Panel , and press Ente r to open the Control Panel on your Windows 11 PC.

Step 2: Click on View devices and printers under Hardware and Sound.

Step 3: Click Printer & scanners .

Step 4: Disable Let Windows manage my default printer .

Step 5: Click Microsoft Print to PDF .

Step 6: Lastly, click Set as default .

Was this helpful?