ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I delete Rows from my woorksheet? (https://www.excelbanter.com/excel-worksheet-functions/7957-how-do-i-delete-rows-my-woorksheet.html)

Leslie

How do I delete Rows from my woorksheet?
 


Dave R.

One way is to right click on the row number label on the left hand side, and
choose "delete".


"Leslie" wrote in message
...




Frank Kabel

Hi
you can't. Excel will always have 65536 rows. But you can hide them

--
Regards
Frank Kabel
Frankfurt, Germany
"Leslie" schrieb im Newsbeitrag
...




Don Guillett

Look in HELP index for delete

--
Don Guillett
SalesAid Software

"Leslie" wrote in message
...




Leslie

Thank you Frank. I do know how to delete rows, of course, but I wanted to
only have 58 instead of the 65536. You hit the nail on the head with your
answer.
Thanks anyway.

"Frank Kabel" wrote:

Hi
you can't. Excel will always have 65536 rows. But you can hide them

--
Regards
Frank Kabel
Frankfurt, Germany
"Leslie" schrieb im Newsbeitrag
...





Leslie

Thanks but I was talking about the 65536 rows that are in excel. I only
wanted 58 and it seems as though I can't "delete" the rows as you stated.
Thanks anyway

"Dave R." wrote:

One way is to right click on the row number label on the left hand side, and
choose "delete".


"Leslie" wrote in message
...





Leslie

Not in there. I was trying to delete 65478 of the 65536 rows in the
worksheet. Excel wont let me. It always has the 65536 rows. Otherwise, I
know how to DELETE.

"Don Guillett" wrote:

Look in HELP index for delete

--
Don Guillett
SalesAid Software

"Leslie" wrote in message
...





Dave R.

You're welcome - in the future you might expand upon what you're looking for
in the body of your message, otherwise it's (more of) a toss up what you'll
receive as answers.



"Leslie" wrote in message
...
Thanks but I was talking about the 65536 rows that are in excel. I only
wanted 58 and it seems as though I can't "delete" the rows as you stated.
Thanks anyway

"Dave R." wrote:

One way is to right click on the row number label on the left hand side,

and
choose "delete".


"Leslie" wrote in message
...







Don Guillett

As was pointed out, better questions get better answers. But
It was in there. At least on my xl2002.
Delete cells, rows, or columns
1.. Select the cells, rows, or columns you want to delete.
2.. On the Edit menu, click Delete.
3.. If you are deleting a range of cells, click Shift cells left, Shift
cells up, Entire row, or Entire column in the Delete dialog box.
Note Microsoft Excel keeps formulas up to date by adjusting references to
the shifted cells to reflect their new locations. However, a formula that
refers to a deleted cell displays the #REF! error value.


--
Don Guillett
SalesAid Software

"Leslie" wrote in message
...
Not in there. I was trying to delete 65478 of the 65536 rows in the
worksheet. Excel wont let me. It always has the 65536 rows. Otherwise,

I
know how to DELETE.

"Don Guillett" wrote:

Look in HELP index for delete

--
Don Guillett
SalesAid Software

"Leslie" wrote in message
...








All times are GMT +1. The time now is 03:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com