|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 16th, 2005, 06:35 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Deleting columns
Has anyone had this problem: I have a spreadsheet with multiple tabs. On the first tab I can select a group of cells within a column, lets say B12 -- B45 and right click on them, get the option 'Delete...' and it asks if I want to shift left, up, entire row, or entire column. Now, on the second tab I select the same group of cells except now when I right click it will only let me delete rows. Any ideas as to what I am missing here? -- surg4u1975 ------------------------------------------------------------------------ surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718 View this thread: http://www.excelforum.com/showthread...hreadid=494209 
|
|
#2
December 16th, 2005, 06:50 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Deleting columns
Do you have an autofilter active on that sheet? If yes, Excel will only let
you delete entire rows. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "surg4u1975" wrote: Has anyone had this problem: I have a spreadsheet with multiple tabs. On the first tab I can select a group of cells within a column, lets say B12 -- B45 and right click on them, get the option 'Delete...' and it asks if I want to shift left, up, entire row, or entire column. Now, on the second tab I select the same group of cells except now when I right click it will only let me delete rows. Any ideas as to what I am missing here? -- surg4u1975 ------------------------------------------------------------------------ surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718 View this thread: http://www.excelforum.com/showthread...hreadid=494209
|
|
#3
December 16th, 2005, 06:58 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Deleting columns
That definitely helps, and makes me feel a little stupid. Thanks for the help, and for putting up with infantile questions. -- surg4u1975 ------------------------------------------------------------------------ surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718 View this thread: http://www.excelforum.com/showthread...hreadid=494209
|
|
#4
December 16th, 2005, 07:09 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Deleting columns
You're very welcome....
and please don't apologize. After all, you DID post the question in the New Users forum, right?  *********** Regards, Ron XL2002, WinXP-Pro "surg4u1975" wrote: That definitely helps, and makes me feel a little stupid. Thanks for the help, and for putting up with infantile questions. -- surg4u1975 ------------------------------------------------------------------------ surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718 View this thread: http://www.excelforum.com/showthread...hreadid=494209
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| adding three consecutive columns | Darin Gibson | Worksheet Functions | 1 | November 22nd, 2005 08:50 PM |
| deleting columns | c_new | General Discussion | 4 | October 26th, 2005 02:46 PM |
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | foofoo | General Discussion | 1 | April 2nd, 2005 12:02 AM |
| Received vs. Sent Columns | Bill G | General Discussion | 2 | March 9th, 2005 04:17 PM |
| template for deleting columns..... | Jeff | General Discussion | 1 | February 18th, 2005 11:42 PM |
Linear Mode
