![]() |
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. |
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. |
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. |
All times are GMT +1. The time now is 12:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com