Help, tips, tricks and tutorials for Microsoft Office 2007 - The New Paperclip
9th January
2009
written by The New Paperclip




So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, or there is a much more environmentally friendly, and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP ;)



Leave a Reply

--> 1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|27|28|29|30|31|32|33|34|35|36|37|38|39|40|41|42|43|44|45|46|47|48|49|50|51|52|53|54|55|56|57|58|59|60|61|62|63|64|65|66|67|68|69|70|71|72|73|74|75|76|77|78|79|80|81|82|83|84|85|86|87|88|89|90|91|92|93|94|95|96|97|98|99|100|101|102|103|104|105|106|107|108|109|110|111|112|113|114|115|116|117|118|119|120|121|122|123|124|125|126|127|128|129|130|131|132|133|134|135|136|137|138|139|140|141|142|143|144|145|146|147|148|149|150|151|152|153|154|155|156|157|158|159|160|161|162|163|164|165|166|167|168|169|170|171|172|173|174|175|176|177|178|179|180|181|182|183|184|185|186|187|188|189|190|191|192|193|194|195|196|197|198|199|200|201|202|203|204|205|206|207|208|209|210|211|212|213|214|215|216|217|218|219|220| take zyloprim cheap order compazine pills purchase generic exelon clomid buy take zovirax cheap purchase cheap bactrim order online without a prescription calcium carbonate buying protonix no prescription buy femara without a prescription buy cephalexin online without prescription no prescription tetracycline buy zyprexa online uk pharmacy online pharmacy provera no prescription purchase motilium free delivery calcium carbonate no prescription buy orlistat next day delivery purchase biaxin online without prescription cefixime buy online netherlandsAccutane Online Doxycycline online Buy Cheap Lexapro Online No Prescription Prednisone Online Buy Accutane No Prescription