how do I delete rows, socalmichelle 12.07.2006 05:00:01 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.

Re: how do I delete rows, "Paul B" <to_much_spam_to_list[ at ]nospam.com> 12.07.2006 10:50:39 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[ at ]discussions.microsoft.com> wrote in message news:37F9DE24-3CAD-47F1-8A3B-FA290AAA323D[ at ]microsoft.com... [Quoted Text] > 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.

Re: how do I delete rows, "Pete_UK" <pashurst[ at ]auditel.net> 12.07.2006 11:03:59 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: [Quoted Text] > 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.