To share a sheet as a clean PDF, hide or group the helper columns, remove personal details, make sure gridlines and row and column headings are not set to print, add a header or footer, and then check every page of the preview before you save. Work in that order, because the preview is where leftovers show up.
Which columns count as helper columns?
Helper columns are the working columns that make the sheet function but mean nothing to the person reading the PDF. They also widen the page, which forces smaller print.
- A month number pulled out of a date so a SUMIFS can use it.
- A flag column, such as Y for a one-time expense, that only your formulas read.
- Lookup keys, duplicate-check columns and half-finished calculations.
- Notes to yourself, like "ask about this charge".
Select the columns, right-click and choose Hide. A better habit is Data, Group, because the small plus sign above the sheet reminds you that something is tucked away, and you can expand it when you edit later.
Is hiding enough if I send the Excel file itself?
No. Hidden columns and rows are still inside the file, and anyone can unhide them. For a PDF that does not matter, since hidden columns are left out of the printout. If you are sending the workbook, copy the sheet, paste as values into a new workbook, and delete the helper columns there.
How do I remove personal details before sharing?
Do a search rather than trusting your eyes. Press Ctrl+F, set Within to Workbook and Look in to Values, and try these in turn:
- Your phone number, and the first digits of any account or card number.
- UPI handles or names typed into a note column, such as "paid to Ramesh".
- The word "salary" or an employer's name, if the reader does not need to see it.
- Cell comments and notes, which can print if the page setup says so.
Under File, Info, the Inspect Workbook option can also list document properties such as the author name. Remove what you do not want to travel with the file.
How do I stop gridlines and headings printing?
On the Page Layout tab, the Sheet Options group has Gridlines and Headings, each with a View box and a Print box. View only changes what you see on screen. Print decides what lands on paper or in the PDF. If your PDF shows grey lines or the A, B, C letters, the Print box is ticked. Untick it.
Once gridlines are off, a table can look floaty. Give the table block a thin border and a shaded header row so the reader can follow a line across.
What do I put in the header and footer?
Insert, Header and Footer. A title on the left, the date or period in the middle and the page number on the right is enough. Use the Page Number and Number of Pages buttons so the footer reads like Page 1 of 3, which helps if someone prints it and the pages get shuffled.
The final check, before you hit save
- Export through File, Export, Create PDF, and under Options choose Active sheet(s) so you do not send the whole workbook.
- Open the PDF and scroll through every page, not just the first one.
- Use the PDF reader's search box for your phone number and the first digits of any account number. Nothing should turn up.
- Check that the last page is not a lonely half page with one orphan row; adjust the print area or scaling if it is.
- Name the file with the period, for example Household_Apr-Sep, not "final2".
If you share these summaries regularly, SpendixAI keeps ready-made reports that can be downloaded as CSV, so the part you tidy for sharing can be a small sheet rather than your whole working file.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


