PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Setup
how do I delete rows,
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Setup
how do I delete rows,
![]() |
how do I delete rows, |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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. |
|
|
|
#2 |
|
Guest
Posts: n/a
|
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 -- 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 "socalmichelle" <socalmichelle@discussions.microsoft.com> wrote in message news:37F9DE24-3CAD-47F1-8A3B-FA290AAA323D@microsoft.com... > 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. |
|
|
|
#3 |
|
Guest
Posts: n/a
|
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 socalmichelle wrote: > 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. |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

