# "Excel" spreadsheet Question

**URL:** <https://boards.straightdope.com/t/excel-spreadsheet-question/665665>\
**Category:** Factual Questions\
**Created:** [August 8, 2013, 2:33am UTC](https://boards.straightdope.com/t/excel-spreadsheet-question/665665 "2013-08-08T02:33:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thinktank](https://avatars.discourse-cdn.com/v4/letter/t/6a8cbe/32.png) [@Thinktank](https://boards.straightdope.com/u/Thinktank)\
**Post date:** [August 8, 2013, 2:33am UTC](https://boards.straightdope.com/t/excel-spreadsheet-question/665665/1 "2013-08-08T02:33:52Z")

</div>

Hi, technically it’s just a spreadsheet program in general since I use Openoffice mostly to view spreadsheets that others have made. I’ve been going out to allot of sites lately having first referenced a list of sometimes hundreds of names compiled with user information on them when only 1 row of info applies to me.

For the life of me I have yet to figure out how to print all the info in just 1 row and leave the rest in the trash can. If I select a whole row it prints as far as it can fit on a standard page then doesn’t print the rest of the info in the row. I could care less about formatting, yet can’t seem to take that info out of the cells either (read-only document).  
Because of the situation I usually just end-up hand writing the info down on paper, but would be most grateful if someone knew a way I could print it all on one page. Thanks in advance.

---

<div class="post-metadata">

**Author:** ![zoid](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/zoid/32/336_2.png) [@zoid](https://boards.straightdope.com/u/zoid)\
**Post date:** [August 8, 2013, 2:36am UTC](https://boards.straightdope.com/t/excel-spreadsheet-question/665665/2 "2013-08-08T02:36:28Z")

</div>

[Set a print area](http://office.microsoft.com/en-us/excel-help/set-a-print-area-on-a-worksheet-HP010342418.aspx)

---

<div class="post-metadata">

**Author:** ![Keeve](https://avatars.discourse-cdn.com/v4/letter/k/f07891/32.png) [@Keeve](https://boards.straightdope.com/u/Keeve)\
**Post date:** [August 8, 2013, 10:51am UTC](https://boards.straightdope.com/t/excel-spreadsheet-question/665665/3 "2013-08-08T10:51:14Z")

</div>

> [@Thinktank](#):
>
> I could care less about formatting,

So why not just select the row, copy it, paste to any word processor, and print!

---

<div class="post-metadata">

**Author:** ![gigi](https://avatars.discourse-cdn.com/v4/letter/g/a587f6/32.png) [@gigi](https://boards.straightdope.com/u/gigi)\
**Post date:** [August 9, 2013, 2:56am UTC](https://boards.straightdope.com/t/excel-spreadsheet-question/665665/4 "2013-08-09T02:56:26Z")

</div>

If OpenOffice has the same functionality as Excel, when you go to Print and see the settings like orientation, paper size, etc., there would be an option for “scaling” -\> Fit All Columns on one Page.