how do i print off a copy of my spreadsheet with row and collumn headings? and how do i print the excel document to fit one page?
2006-09-15 01:20:17 · 10 answers · asked by jame_football 5 in Computers & Internet ➔ Software
Do you mean A1, A2.. etc
Go to file, page set up, then click on the 'sheet' tab. Then tick the box that says 'rows and column headings', then click ok.
2006-09-15 01:30:19 · answer #1 · answered by Chazza xx Baby born 7/11/09 4 · 0⤊ 1⤋
Goto file menu, choose page setup, select fit to 1 page, then print.
Row and column headings should print automatically if you have them. If you are talking about the row/column A,B,C...1,2,3's then you can't, i've tried and can't find a way round it yet. You could however try to do a print screen (screen dump) if your spreadsheets not to big.
Hope this helps.
2006-09-15 01:38:22 · answer #2 · answered by LP 2 · 0⤊ 0⤋
In the file menu, when you go to page set up you can choose to fit on one page. With regards to row and column headings they should just print automatically
2006-09-15 01:24:08 · answer #3 · answered by LADY__LUCK 2 · 0⤊ 0⤋
Go into page set up, you can specify rows and columns to print on each page on the Sheet tab.
You can also adjust the scaling in page set up to get it to print on one page
2006-09-15 01:23:52 · answer #4 · answered by Ben H 2 · 0⤊ 0⤋
File-Page Setup.
2006-09-15 02:04:44 · answer #5 · answered by Siu02rk 3 · 0⤊ 0⤋
In the file menu, choose page setup and choose portrait or landscape and lower or raise the percentage until the doc is inside the break line.
2006-09-15 01:25:33 · answer #6 · answered by cybtrker 3 · 0⤊ 0⤋
1: click file----> page setup----> select sheet tab----> tick box in the mddle with row and column headings.
2: highlight what you want to print---> file print--->tick selection & tick pages 1 to 1
2006-09-15 01:34:04 · answer #7 · answered by stuio 3 · 1⤊ 0⤋
try what all these other people have said...Also go to file and click select print area (under page setup i think) and then select the area you want to print.
2006-09-15 01:26:00 · answer #8 · answered by teeeck5 3 · 0⤊ 0⤋
If you go to "File" on your tool bar and choose "Print Preview" and then in the preview go to "Setup", you can make the changes there.
2006-09-15 01:25:20 · answer #9 · answered by Spud55 5 · 0⤊ 0⤋
I purchased Excel from "Video Professor" to learn it. However that won't help you now, because you need to print immediately. I found this site, that gives you the step-by-step for free:
http://spreadsheets.about.com/cs/printinginexcel/f/faqep1page.htm
-------------------------------------------------------
Keep this link for future use, cost $3.60
Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Excel 2003.
http://www.beezix.com/Merchant2/merchant.mvc?Screen=PROD&Product_Code=Excel2003Intro&Category_Code=O3&gclid=CPyv487Sr4cCFRuiQQodfxkb7w
2006-09-15 01:37:01 · answer #10 · answered by Excel 5 · 0⤊ 0⤋