ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   how do I delete rows, (https://www.excelbanter.com/setting-up-configuration-excel/98775-how-do-i-delete-rows.html)

socalmichelle

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.

Paul B

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.




Pete_UK

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