Excel 2007

Apa khabar semua?

Coretan kali ini sekadar sebagai panduan untuk mereka-mereka yang mengalami masalah dengan Excel 2007, fokusnya kepada Page Break Preview.

Yesterday, I encountered a problem whereas if I wished to move the blue dotted line in page preview to make sure that every cell fit in one single page, I couldn't do it. Let say if I moved to few cells to the right, it will not move or worst come to worst every single cell will be each single page. Just imagine if you have 30 rows and 30 columns, how much page should it automatically be? Wow... berjuta-juta lemon :).


I came through a useful website www.excelforum.com. One of guru there suggested this to me. Special thanks to Rob Brockett.

1. In case the blue dotted line in the page break preview is very stubborn to be moved. Do check the Page Layout>Page Setup>Scaling. Try select Adjust to or Fit to option.
2. Or make sure that you already installed the printer first. Install any printer should do.

These are some of the simple solution suggested. Hope this will a little bit solve the stubborn blue dotted line problem. Have a try.

Wah, speaking gitu aku. Apa-apa pun, selamat mencuba.