Zig+or+Zag?+In+Excel

Zig or Zag? In Excel

If you've got this huge worksheet in MS Excel that you're trying to print and it seems that the pages are coming out completely scrambled. What as gone wrong? Honestly, nothing. It's all in the Page Setup choices you make. You insist that you did not make any choices in Page Setup that would cause this chaos Well, that could be the problem right there. With all of the other options available in Excel, you may not have realized that you can tell it how to print the data. That is, you can decide if Excel prints down the first page of columns, then moves right to the next set of columns, or if Excel should print across the rows of data, then move down to the next set of rows. Zig or zag?

At some point before you print, go to the File menu, Page Setup choice. When the Page Setup window opens, go to the Sheet tab.

You are looking for the Page Order section at the bottom. Here you'll find two choices: "Down, then over" and "Over, then down."

Pay a close attention to the preview picture. When you make a selection, the arrow changes directions to let you see the page printing order. This makes a huge difference

By selecting the correct direction, your page numbering will be correct and you won't have to spend time redoing the sequence of the pages.

"Down, then over" prints in this direction ( Down then up to go down again)

This one seems to be good for data that is arranged in columns. The "Over, then down" option prints in this order:

This one works well when my data for each item is arranged in rows. Whatever your needs, make a selection and then click OK. Voila!

Please post your comments in :- [|Queries and Comments]

To print off for your Crib Sheet:- Copy and Paste to Word.doc then Print  