How can i delete unused row and columns ???

S

Suleman Peerzade

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.
 
F

Francois via OfficeKB.com

Irfan said:
Hi Experts,

Can i delete usnused row and columns in a particular sheet ???
Click to expand...


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
 
F

Francois via OfficeKB.com

Irfan said:
Hi Experts,

Can i delete usnused row and columns in a particular sheet ???
Click to expand...


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
 
F

Francois via OfficeKB.com

Irfan said:
Hi Experts,

Can i delete usnused row and columns in a particular sheet ???
Click to expand...


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
 
F

Francois via OfficeKB.com

Francois said:
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
Click to expand...


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

Roger Govier

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 I>hold 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 21>Shift+Control+Cursor down will select rows
21:65536>Right Click>Hide
 
T

Tyro

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
 
Top