How can i delete unused row and columns ???
 

Hi Experts,


Can i delete usnused row and columns in a particular sheet ???

How can i delete unused row and columns ???
 

Hi Irfan,

You can surely delete the un used rows by sorting your data. Select the data
that needs to be sorted/Data/Sort/ Sort by the relevant catgory.
for e.g if you have attendance data in your worksheet and there 1000
employee working. Assume that the worksheet is the report generated for a
particular date and there are 3 shifts
'G" for general, "M" Morning & "N" for Night
Now when the report is generated in excel you will get all three shifts and
some of the employees might be on leave or some of them might have left the
company in both the case the cells contianing in/out time will be vacant and
there might some more rows that are vacant and there is no use.
So you can simply select the entire arrange of the table go to data and sort
by in time.
This will give you the data that has in/out time only and the rest can be
deleted.

Then select the rows/columns to be deleted. Got to Edit/Delete/Row or columns.
--
Thanks
Suleman Peerzade


"Irfan Khan" wrote:

Hi Experts,


Can i delete usnused row and columns in a particular sheet ???

How can i delete unused row and columns ???
 

Irfan Khan wrote:
Hi Experts,

Can i delete usnused row and columns in a particular sheet ???


You can delete the CONTENTS of rows and columns

You can HIDE the rows and columns you don't want to see

You CAN'T delete the rows or columns themselves

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200801/1

How can i delete unused row and columns ???
 

Irfan Khan wrote:
Hi Experts,

Can i delete usnused row and columns in a particular sheet ???


You can delete the CONTENTS of rows and columns

You can HIDE the rows and columns you don't want to see

You CAN'T delete the rows or columns themselves

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200801/1

How can i delete unused row and columns ???
 

Irfan Khan wrote:
Hi Experts,

Can i delete usnused row and columns in a particular sheet ???


You can delete the CONTENTS of rows and columns

You can HIDE the rows and columns you don't want to see

You CAN'T delete the rows or columns themselves

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200801/1

How can i delete unused row and columns ???
 

Francois wrote:
Hi Experts,

Can i delete usnused row and columns in a particular sheet ???

You can delete the CONTENTS of rows and columns

You can HIDE the rows and columns you don't want to see

You CAN'T delete the rows or columns themselves


Sorry I didn't mean to multiple post my PC went bizwack

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200801/1

How can i delete unused row and columns ???
 

Can't delete, but can hide.
--
David Biddulph

"Irfan Khan" wrote in message
...
Hi Experts,


Can i delete usnused row and columns in a particular sheet ???

How can i delete unused row and columns ???
 

You cannot "delete" unused rows and columns, but you can Hide them instead.

Suppose you only wanted to see A1:H30 as a range
Highlight column Ihold down Shift+Control and use the Right cursor movement
button. This will highlight all columns from I through IV (XL2003 and
earlier).
Right click and choose Hide.
Similarly for rows, select row 21Shift+Control+Cursor down will select rows
21:65536Right ClickHide


--

Regards
Roger Govier

"Irfan Khan" wrote in message
...
Hi Experts,


Can i delete usnused row and columns in a particular sheet ???

How can i delete unused row and columns ???
 

You can delete blank rows and columns. For example, if you have a blank
row(s) with row(s) below that are not blank, you can delete the blank row(s)
by selecting the row(s), right clicking and select delete. The same applies
to blank columns that have columns with data to the right of them. Otherwise
you can hide rows and columns you don't want to see

Tyro

"Irfan Khan" wrote in message
...
Hi Experts,


Can i delete usnused row and columns in a particular sheet ???