how do I delete rows,

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

socalmichelle - 12 Jul 2006 06:00 GMT

I only want rows A through G, how do delete rows H through whatever. I do
not want them on my screen, I want to totally delete the rows.

Reply to this Message

Paul B - 12 Jul 2006 11:50 GMT

socalmichelle, rows or columns? you can not delete them, but you can hide
them, click on H then Ctrl+shift+right arrow key to select all the columns
to the right, then format columns hide

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> I only want rows A through G, how do delete rows H through whatever. I do
> not want them on my screen, I want to totally delete the rows.

Reply to this Message

Pete_UK - 12 Jul 2006 12:03 GMT

I'm a bit confused - rows are numbered and columns use letters.

You can't delete the rows, but you can hide them. Click on the row
identifier for row 8 so that the whole row is highlighted, then hold
down the <SHIFT> key and press <End> once followed by <down_arrow),
then release <SHIFT> - this will have highlighted all the rows to the
bottom. Then click Format | Rows | Hide.

If you want to hide columns, then click on the "H" at the top of the
column to highlight that column, then holding the <SHIFT> key down
press <End> followed by <right_arrow> then release <SHIFT> and Format |
Columns | Hide.

Hope this helps.

Pete

> I only want rows A through G, how do delete rows H through whatever. I do
> not want them on my screen, I want to totally delete the rows.

Reply to this Message