Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
easy way to delete all rows with no text in them? | New Users to Excel | |||
delete rows | Excel Discussion (Misc queries) | |||
Delete Rows where cells does not meet criteria | Excel Worksheet Functions | |||
Want to delete rows | Excel Discussion (Misc queries) | |||
How can we delete rows permanently from excel sheet | Excel Discussion (Misc queries) |