PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup how do I delete rows,

Reply

how do I delete rows,

 
Thread Tools Rate Thread
Old 12-07-2006, 06:00 AM   #1
=?Utf-8?B?c29jYWxtaWNoZWxsZQ==?=
Guest
 
Posts: n/a
Default how do I delete rows,


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 With Quote
Old 12-07-2006, 11:50 AM   #2
Paul B
Guest
 
Posts: n/a
Default Re: how do I delete rows,

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.



  Reply With Quote
Old 12-07-2006, 12:03 PM   #3
Pete_UK
Guest
 
Posts: n/a
Default Re: how do I delete rows,

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.


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off