I often find that I've spent way too much time trying to find out how to do something that takes only a few seconds! So I'd like to share in the hopes that maybe I'll save someone a little time. I'm working on the card exchange with 3rd grade and I wanted to print my excel list of names and address on one sheet of paper so it would be easy to use.I knew there should be a way to print only the columns I needed, but I couldn't figure out how to do it. So of course I spent too much time figuring it out, but I finally did. So here goes -
How To Print Only Certain Columns in an Excel Spreadsheet:
- Click the view tab.
- Click custom view.
- Click add.
- Then, type a name for your full spreadsheet as it currently is, for example, name this view "normal".
- Click OK.
- Then, go to each letter heading of the column you DO NOT want to print, right click and select hide.
- Then go back to custom view.
- Add.
- Type a name for this view, for example "print".
- To switch between the two views, go to custom view and double click the one you need.
Seems like a bit of a workaround to me to be honest. As far as i know, you could just set the print area to whatever you want to have printed. http://www.excel-aid.com/excel-print-area-setting-and-clearing-print-areas.html provides a prety good beginners guide for that, and for more specific stuff google usually finds good stuff,too :) Although to be honest, im not sure if your method isnt a little bit faster. I am almost tempted to test it (and no, i am definetely NOT bored :P ).
ReplyDelete