#1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1
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.
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 709
Default 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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 8,856
Default 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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
easy way to delete all rows with no text in them? george edgar New Users to Excel 2 May 13th 06 07:54 PM
delete rows Jack Sons Excel Discussion (Misc queries) 5 November 22nd 05 04:30 PM
Delete Rows where cells does not meet criteria Danny Excel Worksheet Functions 1 September 12th 05 05:08 PM
Want to delete rows Farooq Sheri Excel Discussion (Misc queries) 6 September 12th 05 12:46 PM
How can we delete rows permanently from excel sheet Nehal Shah Excel Discussion (Misc queries) 1 August 1st 05 01:58 PM


All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"