Print Cells to Every Page in Microsoft Excel

You may wondering how to create title which able to be shown in every page (not Header).

Here we go..

  1. Click View –> Page Break Preview. Now your active sheet is now divided onto pages.
    Drag blue border line to customize your print area.
  2. Click File –> Page Setup from the menu, clicking the Sheet tab, and telling Excel which row and column titles you want to appear at the top and/or left of every printed page.
  3. Click File–>Print Preview.
  4. Tada! Now you got what do you want.

Good luck and have a nice Excel.😉

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: