Click and hold on A1 then drag the define box to include all your rows and columns then release. Click on the Page Layout tab at the top, click on Print Area drop down and choose define print area. That's always worked for me. This still allows you to have values or tables outside the print area but only prints the rows and columns you want.
Computer type PC/Desktop System Manufacturer/Model Number Built 2/11/2011 OS Windows 7 Pro-x64 CPU i7-2600 3.4GHz - 3.8GHz Turbo Motherboard Intel DH67BL-B3 Memory 8Gb - 2x4GB, Muskin 991770 PC3-1333 Graphics Card Integrated Intel HD 2000 Sound Card Integrated Intel 10.1 HD, RealTek ALC892 Monitor(s) Displays Asus LCD VH222H, Haier HL24XSL2a Screen Resolution 1920x1080, 1920x1080
Keyboard Logitech EX100 Wireless Mouse Logitech EX100 Wireless PSU Seasonic 650W 80+ Gold Modular Case Rosewill Defender Cooling Stock CPU, Four 120mm case fans, PCH fan added Hard Drives Crucial C300-128Gb,
Western Digital WD5002AALX - 500Gb,
Western Digital WD7501AALS - 750Gb Internet Speed 2.5/1.5 Mbs Antivirus Microsoft Security Essentials Browser Microsoft Internet Explorer 10 Other Info Antec Veris Premier-Multimedia IR Station,
Cyber Accoustics-3602 Speakers,
AFT XM-5U Card Reader,
Hauppauge TV-HVR-2250,
Sony LX300 USB Turntable