| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| Help with grouping columns | New Users to Excel | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
