Excel background

  • Thread starter Thread starter Peter Downes
  • Start date Start date
P

Peter Downes

I have quotation form in Excel. I would like to remove all of the unused
cells (column H onwards; row 30 onwards) that are visible, and only show
what will be printed on the page. This will make it look like a proper
form.

How can I do this?
 
Hi Peter

One way would be to hide the columns and rows
Click on the H of Column H then hold down Shift + Control as you press the
Right Arrow.
This will select columns H:IV, then Right click and choose Hide.

Repeat procedure for the rows by clicking on row 30, Control + Shift and
press down arrow.
 
Go to Format>Column>Hide and hide those columns

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top