I'm an Excel noob, can I make it do the following somehow.... - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 06-27-2007, 11:57 AM   #1 (permalink)
True Techie
 
Join Date: Jul 2005
Posts: 160
Default I'm an Excel noob, can I make it do the following somehow....

Hey guys.

So basically in my spreadsheet I have a bunch of blue "blocks" of numbers in between a black sheet of numbers.

(basically my important data is in blue)

My teacher wants me to delete all the black text on the spreadsheet except for one black field above and below every blue block.

It looks like this

Black
Black
"Black"
Blue
Blue
"Black"
Black
Black

I have to delete the Black, but keep the "Black" and the Blues.

So I have to do Right Click --> Delete --> Shift Cells Up --> OK, like 100 times.

Is there anyway I could make Excel do that, but the command be:
Right Click --> Tab button

and have it do the same thing?

Thanks a lot, some shortcut like that would save me HOURS.

Please help. Thanks in advance!
__________________

rocket1406 is offline  
Old 06-27-2007, 12:15 PM   #2 (permalink)
Lord Techie
 
Hefemeister's Avatar
 
Join Date: Feb 2004
Location: Sweden
Posts: 9,093
Default Re: I'm an Excel noob, can I make it do the following somehow....

You can delete muliple lines at one time. Holding the Ctrl button while clicking will allow you to select multiple lines that are not in order to delete at one time. If the data you need is smaller than what you want to delete you could select the lines you want to keep copy them and paste them in a new sheet.
__________________

__________________
ASUS P6T Deluxe V2 :: INTEL i7 920 @3.4 :: XFX GTX260 :: 6gb Corsair 1600 :: Corsair 750TX :: TRUE 120 :: Samsung T240 24" :: Windows 7 X64

I do not accept support questions via PM

"Those who would give up essential liberty to purchase a little temporary safety deserve neither liberty nor safety."
Hefemeister is offline  
Old 06-27-2007, 01:21 PM   #3 (permalink)
True Techie
 
Join Date: Jul 2005
Posts: 160
Default Re: I'm an Excel noob, can I make it do the following somehow....

I tried that, but across multiple rows and columns, when I do control, and then delete, at the end one of the columns is always one or two rows higher than it should be.

(It's not a proper delete)
rocket1406 is offline  
Old 06-27-2007, 01:29 PM   #4 (permalink)
Newb Techie
 
Join Date: Jun 2007
Posts: 28
Default Re: I'm an Excel noob, can I make it do the following somehow....

try selecting the rows and do a right click then delete and a box should come up and you select the radio button that says delete entire row... that should get rid of it.... at least from my understanding
npettit is offline  
Old 06-27-2007, 01:31 PM   #5 (permalink)
True Techie
 
Join Date: Jul 2005
Posts: 160
Default Re: I'm an Excel noob, can I make it do the following somehow....

The problem is every 2 or 3 columns I need that data as well.

It is all scattered.
rocket1406 is offline  
Old 06-27-2007, 01:36 PM   #6 (permalink)
Newb Techie
 
Join Date: Jun 2007
Posts: 28
Default Re: I'm an Excel noob, can I make it do the following somehow....

ok so.... you have info that you want deleted from your excel file but you want all the other info to stay in the same place.... if you press ctrl and select the seperate cells you want to delete then you can right click and go to clear contents.... then again im using office 2000 and 2003 so maybe urs is different... let me know if it works...
npettit is offline  
Old 06-27-2007, 01:37 PM   #7 (permalink)
Lord Techie
 
Hefemeister's Avatar
 
Join Date: Feb 2004
Location: Sweden
Posts: 9,093
Default Re: I'm an Excel noob, can I make it do the following somehow....

can you post a pic of the spreadsheet. I am having difficulty understanding what you are trying to accomplish.
__________________
ASUS P6T Deluxe V2 :: INTEL i7 920 @3.4 :: XFX GTX260 :: 6gb Corsair 1600 :: Corsair 750TX :: TRUE 120 :: Samsung T240 24" :: Windows 7 X64

I do not accept support questions via PM

"Those who would give up essential liberty to purchase a little temporary safety deserve neither liberty nor safety."
Hefemeister is offline  
Old 06-27-2007, 01:47 PM   #8 (permalink)
True Techie
 
Join Date: Jul 2005
Posts: 160
Default Re: I'm an Excel noob, can I make it do the following somehow....

Putfile - Uploaded Picture
rocket1406 is offline  
Old 06-27-2007, 01:51 PM   #9 (permalink)
True Techie
 
Join Date: Jul 2005
Posts: 160
Default Re: I'm an Excel noob, can I make it do the following somehow....

so

red
black - del
black - del
black
blue

and if it's

blue
black
black - del
black
blue

basically delete all black that is NOT touching a blue. if it's touching a blue, I can't delete it because I need those values.
rocket1406 is offline  
Old 06-27-2007, 01:53 PM   #10 (permalink)
Newb Techie
 
Join Date: Jun 2007
Posts: 28
Default Re: I'm an Excel noob, can I make it do the following somehow....

but you want everything to stay where they are? or are they allowed to move?
__________________

npettit is offline  
Closed Thread

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where is Microsoft Excel in the Office? heguru Microsoft Windows and Software 4 06-10-2007 06:34 AM
Make an AVI Smaller sir nerdalot Computer Audio and Multimedia 14 05-31-2007 08:27 AM
Nero 6 to make VCD sir nerdalot Computer Audio and Multimedia 0 05-21-2007 04:42 AM



Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 11:13 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.