If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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" wrote in message ... 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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Code to delete rows and column cells that have formulas in. | GarToms | Worksheet Functions | 1 | January 18th, 2006 01:04 PM |
How do I find duplicate rows in a list in Excel, and not delete it | Matthew in FL | General Discussion | 2 | June 15th, 2005 09:11 PM |
Protect Worksheet but allow to insert or delete rows | Bob L Hilliard | General Discussion | 2 | June 9th, 2005 02:08 PM |
delete extra columns and rows | matt charlton | General Discussion | 1 | June 7th, 2005 08:46 PM |
delete extra/duplicate rows of table data | JV | Tables | 2 | May 27th, 2004 09:13 PM |