Printing selected columns/rows .

[s_ojha]

Placed below is an image .I want to print Column B,C,D & K altogether leaving column E,F,G,H,I&J .I do not want to take help of columns to repeat or rows to repeat . I selected column B & C by "CTRL" key and column K by CTRL, but the last column is printed on next page . Similarly, I also want to print the selected rows by using "CTRL key .PLEASE HELP .

A1.xls
	B	C	D	E	F	G	H	I	J	K
3	NAME	PROJ	Dt.ofBirth	SC/ST	Quali.	Appt.	Gr.II	Gr.I	Spl.	Gr.A
4	A.B.RAO	HQR	04-05-1947		Matric	31-03-1970	05-05-71	12-03-76	28-04-84	30-06-1989
5	P.K.PAUL	KKR	31-12-1951		B.Com.	03-02-1975	03-02-75	12-07-80	30-04-86	25-09-1990
6	S.P.SHARMA	HQR	01-02-1951		B.Sc.	12-12-1974	12-12-74		19-04-86	25-09-1990
7	TARAKNATHSAHA	CAL	01-12-1946		B.Com.	24-09-1975	24-09-75	26-12-80	19-04-86	25-09-1990
8	T.K.RAVINDRAN	NSC	30-05-1951		B.Com.	08-10-1974	08-10-74	22-04-78	19-04-86	25-09-1990
9	R.K.NIGAM	AML	01-01-1952		MA(S)	21-07-1974				25-09-1990
10	S.D.SINGH	DCH	02-08-1960		MA(S)	04-05-1982	04-05-82	01-05-86	02-09-93	10-02-1994
11	A.K.SHARMA	JNT	13-03-1953		B.Com.	15-11-1975	15-11-75	17-12-82	25-08-89	08-04-1994
12	HARINAMRAM	NSC	08-07-1953	SC	MA	01-11-1980	01-11-80	23-05-84	25-08-89	08-04-1994
13	AJAYKUMARJHA	HQR	19-04-1964		B.Com./ICWA(I)	27-09-1988	21-12-89	02-09-93		10-01-1995
14	ANANDPRAKASHSINGH	AML	09-09-1963		MA(S)	29-10-1988				17-02-1995
ACCT

 

[Whisperer14]

The easiest way to achieve what you want is to hide the columns and rows that you do not wish to print.

Set the Print Area such that it encompasses the first and last column that you wish to print, do the same for the first and last row, then hide any column within the print area that you do not wish to print, do the same with hiding the rows

HTH