Hiding Columns for printing

Highlight columns B through P and then go to Format, Click Column, Click Width, input a 0, "zero", in the box and click ok. Columns A, Q and R will print on one sheet.

If this is not what you are looking for you can also group columns B through P and close that group.

excelpower:cheers:

Highlight your columns B to P by putting your cursor on columnB header and dragging to column P. Your selected columns will be highlighted . Now from the Format menu select Columns>Hide. Your columns will be hidden and you will be able to print the remainder.
To unhide, simply select Columns>Unhide

Hi chickenflicker,

Welcome to the borad.

Just for clarification, Window -> Hide is used to hide the entire worksheet.

If you want to hide a particular column(s)
then Click on the Column header(s), then
Format -> Column -> Hide
(OR Just select the columns, press right mouse key and select hide)

Hi chickenflicker

As an added help to the abov suggestions. Once you have hidden your columns, go to Data>Custom Views and save the view as any name. Then unhide and save that view as another name. Next time you need to print, just go to Data>Custom Views and nominate the view.

Your Print width for Columns A, Q, and R could be wider than the printable area of your page.

To save some trees, as well as frustration, it is a good idea to do Print_Preview before printing -- this way you will know how your printout will look like. You can also do Page_Break_Preview by accessing this via the VIEW menu -- this will allow you to change column widths, insert/delete Page_Breaks and so forth.

So, you see there are a number of helpful features built into Excel -- I am sure as you make use of these you will have an enjoyable experience working with Excel.

Quote

Originally posted by chickenflicker
However, when I followed the instructions and the columns merged, a yellow line appeared after column A.

Did you merge or hide the columns?

can you post your spreadhseet in your next reply, someone will fix it for you - it sounds like something (or a lot) is getting lost in translation

ending up with 3 columns for printing is a pretty easy task

post it up and someone will do it for you

Quote

Originally posted by chickenflicker
When I used the page-break to try to move the line to the right, nothing happened.

Which line did you try to move? The blue dotted line or the solid line? You have to move the blue dotted line.

click on "post reply"

you get a box to write in and a load of smilies to the right of it

underneath the box, you have :

Helpful Info For Question Askers

Disable smileys?
Use signature?
Turn BBCode off?
Receive email notification of new replies?

underneath this is a box which says :

Attachment : [_______] Browse

click the browse button, choose your saved file then when it's loaded, click on "post reply"

obviously, just post an example, maybe just the relevant sheet, not the whole 7 megabyte workbook

also, see attached, where I apply my Art A level to good use

Hi ChickenFlicker

Can you attach your spreadsheet and I will be glad to look at it to see what is causing the sheet to print on more than 1 sheet. I don't understand why this is happening.

Excelpower:cheers:

I had a look at your file & can't see the problem. i did this:

1) highlight col B by clicking on the column letter at the top.
2) press & hold down the shift key
3) scroll along to column ae & highlight it. (you should now have cols b thro' ae highlighted).
4) with the cursor over the selected area, right click, select hide.

...am I missing something?

Hi

I have downloaded your Workbook and cannot get your error.

I placed my cursor in the Head of column AE and dragged across to C. Then Format >Columns>Hide. No problem

I have re-attached your workbook with a couple of buttons to hide and unhide your columns. Xee if you still get the same problem using these.