I am creating an Excel document detailing the demographics of equipment that my unit owns. As some of the devices do not have an exact acquisition date, I would like to add a footnote to the last printed page indicating that identified item acquisition dates are estimated. However, I do not see a way to add a footnote only to the last page; my footnote appears on every page.
Also, I would like the document to print the individual cell borders/lines. However, when I preview the document, no lines are included.
Can someone please share how I can add footnotes to the last page and ensure cell borders/lines are printed using Excel 2002 (SP3)?
Users like you can add images, links and other relevant information about this topic.
posted: Aug. 31, 2013 @ 3:57p
Click to copy code and go to .
posted: Aug. 31, 2013 @ 4:30p
I was able to print cell borders via Page Setup > Sheet > "Xing" the gridlines box.
Is there a "best fit" option in formatting cell widths? I recall in previous Excel editions that a "best fit" box could be clicked. I can't find such an option in Excel 2002.
posted: Sep. 1, 2013 @ 8:36a
For 'best fit' on cell widths, you just double click the line between the column headers. In other words, if you have a bunch of data in column A, double click the vertical line between 'A' and 'B' in the column headers and it will make column A as wide as it needs to be based on the data that you've entered in that column.
To print the cell borders (gridlines), File > Page Setup > Sheet > Gridlines.
I don't think you can add a footnote to just the last page. Of course you could save two versions and add the footnote on one of them, only printing the last page of that version. Not exactly what you want, but a possibility. If it were me, I'd just add the footnote at the end of my data in whatever row that is and then it would print on the last page only.
Disclaimer: By providing links to other sites, FatWallet.com does not guarantee, approve or endorse the information or products available at these sites, nor does a link indicate any association with or endorsement by the linked site to FatWallet.com.
Members of our community may attach files to a post in accordance with the User Agreement. FatWallet is not responsible for the content, accuracy, completeness or validity of any information contained in any attached file. Files have *not* been scanned for viruses. Be especially wary of Excel files which may contain malicious content.
Earn Cash Back while you shop - just 3 simple steps.
1. Sign Up so we know who to pay! (It's FREE.)
2. Shop through FatWallet for deals from your favorite stores. Your online purchases earn Cash Back that builds in your FatWallet account.
3. Get Paid by requesting a payment via check or PayPal.
FatWallet coupons help you save more when shopping online. Use our Coupons Search to browse coupons and offers from thousands of stores, gathered into one convenient location.
As part of our FatWallet Community, you can share deals with almost a million shoppers in our forums. Forum content is generated by consumers for consumers. Share deals, money-saving tips, and more. It's FREE, fun, and addicting.
Our customer experience team is here around the clock - real people ready to assist.