Save Excel Data as a Picture with Row and Column Headers
Question details
Save an Excel worksheet or data range as an image that includes its row and column headings.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to share or reuse worksheet data as a picture while keeping the worksheet headings visible.
- Observed behavior
- The desired image should show column letters such as A, B, and C and row numbers such as 1, 2, and 3.
Open the worksheet and make sure the data and the relevant row numbers and column letters are visible. If headings are hidden, turn on View > Headings in Excel.
Capture the Excel worksheet with headings visible
Use a screen capture when the data and headings fit on the screen.
In Excel, open the View tab and select Headings if the row numbers and column letters are hidden.
Use the zoom control at the bottom of the Excel window and scroll until the data and its headings are visible together.
On Windows, press Windows key + Shift + S and drag a rectangle around the data, column letters, and row numbers. On a Mac, press Shift + Command + 4 and drag around the same area.
On Windows, open the Snipping Tool notification and select Save. On a Mac, find the screenshot on the desktop or in the location set in Screenshot options.

Print Excel headings to PDF before creating an image
Use this method when you want a printable layout with worksheet headings included.
Capture spreadsheet data with headings in WPS Sheets
Open your Excel workbook in WPS Sheets, display the row and column headings, and use your device's screen capture tool to save the visible data as an image.
- 1. Open the workbook: Launch WPS Office, choose Open, and select your Excel workbook to open it in WPS Sheets.
- 2. Display the headings: Open the worksheet and check that the row numbers and column letters are visible. If they are hidden, use the headings option on the View tab.
- 3. Arrange the view: Use the zoom control and scroll bars to fit the data and its headings on screen.
- 4. Capture and save: On Windows, press Windows key + Shift + S, select the area, and save it from Snipping Tool. On a Mac, press Shift + Command + 4 and select the area to create a screenshot.

Frequently Asked Questions
Why are the row and column headings missing from Copy as Picture?
Excel's Copy as Picture feature may copy only the selected cells, not the worksheet headings. To include the letters and numbers, show them under View > Headings and capture the worksheet with a screenshot tool.
How do I show hidden row numbers and column letters in Excel?
Open the View tab and select Headings. The row numbers and column letters should appear around the worksheet.
Can I print row and column headings in Excel?
Yes. On the Page Layout tab, select Print under Sheet Options > Headings, then check the result in File > Print.
What if my data does not fit in one screenshot?
Reduce the zoom using Excel's zoom control, or capture the range in multiple screenshots. You can also set a print area, enable printed headings, and check the scaling in File > Print.




