I'm an Excel noob, can I make it do the following somehow.... - Page 2 - 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, 01:57 PM   #11 (permalink)
True Techie
 
Join Date: Jul 2005
Posts: 160
Default Re: I'm an Excel noob, can I make it do the following somehow....

They can shift up as long as only the correct pair is shifting. For example, Column A/B is independent of Column D/E.

If Column A/B shifts up, Column D/E should NOT.

I've been doing Right Click --> Delete --> Shift Cells Up

Eventually all that should be left is red, a little bit of black, and mostly blues.

So it will end up something like:

Red
Black
Blue
Blue
Blue
Blue
Black
Black
Blue
Blue
Blue
Blue
Blue
Black
Black
Blue
Blue
Blue
Blue
Black
Red
Black
Blue
Blue
Black
Black
Blue
Blue

etc...
__________________

rocket1406 is offline  
Old 06-27-2007, 02:05 PM   #12 (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 looking at ur pic columns m&n are independent from column p&q..... it seems like selecting all of the cells you want to delete and then move them up will work
__________________

npettit is offline  
Old 06-27-2007, 02:05 PM   #13 (permalink)
True Techie
 
Join Date: Jul 2005
Posts: 160
Default Re: I'm an Excel noob, can I make it do the following somehow....

If it helps, I can change the colors of the black cells that I don't want to be deleted to another color, Purple.

Then can we do a command that can do:

Right click Delete --> Shift Cells Up --> Ok

for ANY and every black text cell?
rocket1406 is offline  
Old 06-27-2007, 02:18 PM   #14 (permalink)
Newb Techie
 
Join Date: Jun 2007
Posts: 28
Default Re: I'm an Excel noob, can I make it do the following somehow....

there isnt any command that will automatically delete all the black cells.... the find and replace function could blank out the cells but you would have to delete them to make it look nice.... the only way that would decrease the number of clicks you use would be to press and hold the ctrl button and click on the cells you want out (or you can click and drag on multiple cells in a column) and then right click > delete > shifts cells up > ok.... then again i am not a expert on microsoft office so someone might know of a way to do it...
__________________

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 03:39 PM.


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