A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how do I delete rows,



 
 
Thread Tools Display Modes
  #1  
Old July 12th, 2006, 06:00 AM posted to microsoft.public.excel.setup
socalmichelle
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  
Old July 12th, 2006, 11:50 AM posted to microsoft.public.excel.setup
Paul B
external usenet poster
 
Posts: 459
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  
Old July 12th, 2006, 12:03 PM posted to microsoft.public.excel.setup
Pete_UK
external usenet poster
 
Posts: 8,780
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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:27 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.