Cannot Delete A Cell Without Deleting A Row

May 23, 2006

I am using Excel on a work computer that someone else may have changed the settings on.

I want to simply delete a cell, without deleting the entire row the cell belongs to. Yet when I highlight the cell, and go to Edit -> Delete, the program asks me if I want to delete the entire row, and only gives me two options: OK or Cancel. So I can't delete just one cell (and have all of the lower cells shift up one).

When I right click, the 'delete' option is not present either. I tried changing the menu properties to add the 'delete' function, but it will not delete a cell without taking out the whole row.

View 3 Replies


ADVERTISEMENT

Delete The Contents Of Every Cell Without Deleting Any Code From My Module

Apr 16, 2009

I want to delete the contents of every cell without deleting any code from my module. The reason I ask is, I'm reading from a text file into excel.

I want to run my code to read text into excel one time through. Then i want to delete all the text, make some alterations to my code, and run the code again. That way each time the worksheet is fresh and clear before i run the code.

View 4 Replies View Related

Can't Delete A Table Without Deleting The Data?

Jul 8, 2009

I have Work book that is quite big and I was silly and put in tables, but this ultimately slows down excel so much so that I have to wait 20-30secs while it performs a single task (PC is i7 with 4g of ram).

B/c I have been working on this Workbook for a long time it has multible sheets all interconnected and I can't go through all the sheets and redo the equations , as that wouyld just take too much time. Is there a way of leaving the data the way it is and deleting the table? This is an example below of the type of table I am talking about.

View 3 Replies View Related

Delete Rows Without Deleting Validation?

Jan 7, 2014

I have a long spreadsheet with multiple dependent lists. If a change is made to the spreadsheet such as deleting a row, the validation is removed. I have to re-do the validation each time I make a change. Is there a way to "lock" the validation so that whatever changes are made to the spreadsheet, the validation stays?

View 2 Replies View Related

Deleting Duplicates-Delete The Correct One

Apr 18, 2006

I have some Job numbers that are duplicates. I can't just do a loop and delete any duplicates that come across because I have to be sure the right one is deleted.

I want the old data to be deleted if there is a duplicate..I just don't know how to verify which one is the old one using VBA. I was thinking of maybe using an advanced filter, but I don't know enough about them.

Is there code that will check both duplicates and delete the old one?

View 5 Replies View Related

Delete Picture When Deleting Rows

Feb 24, 2008

I have made an excel document that I use as a order form. I have size columns; qty columns; style number columns etc. After I enter in qtys to a sheet I than sort the sheet by the qty column which than brings all of my ordered styles to the top of the order form. I than delete everything that is below the last column that has qtys in it.

I have added pictures on the side of the worksheet which fit into the grids of each row that corridinates with the appropriate style number. I can sort the worksheet and all of the pictures stay in the appropriate columns; so far so good.

The problem that I run into is now when I go to delete all of the other columns that the customer didnt order none of the pictures delete. They jsut pile on top of each other and I cant figure out how to embed each picture to the appropriate row so that when I delete the row the picture deletes as well. At this point I have to go through and delete picture by picture and there are way to many pictures to do this.

How do I imbed the pictures into the row so that when i delete the row the picture deletes as well

View 9 Replies View Related

Delete Every Formula For A Sheet Without Deleting The Contents

Oct 31, 2009

How can i delete every formula for a sheet without deleting the contents?

View 5 Replies View Related

Loop To Delete Worksheets Stops After Deleting One Sheet

Mar 17, 2014

Sub DeleteSheetsPlease()

Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
Application.StatusBar = "checking " & ws.Name

[code] .......

This skips "Parameters" and "About", then it deletes a single sheet (that does not match "Parameters" or "About"),

BUT THEN IT STOPS, leaving "deleting [WSNAME]" in the appstatus. It's like it skips the "Next ws" statement altogether after deleting a sheet.

I want it to keep looping on all the sheets, but that delete action seems to kill the looping...

View 2 Replies View Related

Macro - How To Remove Delete Prompt When Deleting A Sheet

Jul 22, 2013

I have a Macro which deletes a sheet called "Pre selection" with:

Sheets("Pre selection").Select
ActiveWindow.SelectedSheets.Delete

It asks me every time if I am sure and I have to click to continue. Is there any way to remove this prompt or set it to continue without my intervention?

View 3 Replies View Related

Avoid Delete Prompt Deleting Sheets/Worksheets

Aug 9, 2006

whenever you want to delete a sheet, excel would prompt you to ask you if you are sure you want to delete the sheet. im making a vba so that the sheets will delete upon workbook close, but i dont want to be prompted everytime to be sure to delete it when running the vba macro. Also, i would like to avoid being asked to save any changes to my workbook

View 2 Replies View Related

Macro To Filter And Delete Row Not Deleting Visible Filtered Rows

Jun 6, 2013

I'm working through a filter macro to delete unecessary rows of data from my dataset.

- I have a Dynamic Range for my dataset called "CanadaData"
- I'm trying to delete rows from the 5th column of my dataset for cells containing "DIRECTSHIP"

The macro filters the range fine, but when if comes to deleting the row, the macro stops.

Sub CanadaWarehouseFilter()
x = Range("E" & Rows.Count).End(xlUp).Row
If Application.WorksheetFunction.CountIf(Range("E22:E" & x), "DIRECTSHIP") > 0 Then

With Range("CanadaData")

[Code] ......

View 2 Replies View Related

Deleting Rows Macro :: Keep Full Time Sales People Delete Else

Mar 3, 2008

I am working on a sales sheet for my business. I have a worksheet that has the names of everyone in my store that has sold anything in column A. I want to create a list that has just my full time sales people and will delete everyone else.

View 9 Replies View Related

Excel 2010 :: Delete Filtered Rows Without Deleting The Hidden Rows?

Sep 25, 2012

How do I delete filtered rows without deleting the hidden rows in excel 2010?

View 8 Replies View Related

Delete Adjacent (hidden) Data When Deleting Visible Data

Dec 10, 2009

I have 3 columns of data that are being copied from a .csv file. The data is pasted into Columns B, C, & D. Columns C and D are hidden. So that the user does not have to unhide the columns in order to delete the data, I would like to make it so that when the data in column B is deleted, the data in columns C and D is also deleted.

View 14 Replies View Related

Delete Blank Rows (formula Not Deleting All Rows)

Sep 30, 2008

I have the following codes to delete all blank rows in column A

Dim lastrow As Long
lastrow = Sheet1.Range("A" & Rows.Count).End(xlUp).Row
MsgBox lastrow

With Sheet1
For t = 1 To lastrow
If Cells(t, 1) = "" Then
Rows(t).Delete
End If
Next t
End With

End Sub

Although it is working , it is not deleting all the blank rows at once, I have to keep pressing on the macro button running the macro several times, until all blank rows are completely deleted.

View 9 Replies View Related

Deleting Cell Content Based On Entry In One Cell?

Mar 22, 2014

I have a sheet that I fill out with customer data then print and start over with the next customer. This requires me to tab and delete through the sheet before starting the next entry and I am wondering if there is some way to auto clear the unlocked cells based on a single entry IE when we entered new data in the 1st field this would clear the unlocked cells and make them ready for new data?

View 14 Replies View Related

Deleting Row/cell

Mar 31, 2007

In Excel 2007, when I delete a row/cell, text is associated with deleting row/cell but some lines, polygon ... can not associate with deleting row/cell . So the lines, polygon ... in mistake location.

View 12 Replies View Related

Deleting Value From A Cell

Oct 8, 2008

I am using this code to populate column J with a date when yes is selected in colum I.

Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Column = Columns("I").Column Then
If .Value = "Yes" And IsEmpty(.Offset(, 1)) Then .Offset(, 1) = Date
End If
End With
End Sub

However i also want any value entered in J to be deleted when No is selected.

View 2 Replies View Related

Deleting Third Value In Cell

Sep 21, 2006

My original datasheet had two separate columns, First Name & Last Name. I've combined the two columns into one so it appears Last Name, First Name. Some of the names have middle names. Is there anyway to delete the middle name.

Example: Cope, David Simon

Trying to get: Cope, David

View 7 Replies View Related

Deleting Incorrect Cell Name?

Jun 24, 2014

I have a lot of calculations going on so I thought I would name some of the cells where factors come from to make it easier to follow.

I made a typo and named a cell wrong, is there a way to delete it? Right now I have a correct and incorrect name attached to the cell.

View 3 Replies View Related

Deleting Last Cell In A Specific Row

Feb 24, 2009

hey everyone

i'm using a table like this one :

A B C D

1 Main | value | value | value
2 Extra | value | value | value
3 Main | value | value | value
.
.
n Extra | value | value | value

i want to delete every cell in column "D" only when cell in column "A" contains "Extra" value.

View 6 Replies View Related

Deleting Columns Where A Cell Within Contains A Value

Jan 28, 2010

I want to delete columns that contain a 0 value in row 2 of the column.

In my case, I have headers in row 1 and values in rows 2 and below. I eventually want to filter out the columns that contain no values below the headers.

Let me know if you need any more information for clarification.

View 10 Replies View Related

Deleting A Cell When Linked?

Oct 27, 2011

I was wondering if ther is a way to delete what is in one cell, once something has been enterted in another?

Example A1 has In-progress written in the cell.

Once B1 has Completed.

So once B1 has been entered, the info in cell A1 will be deleted.

View 4 Replies View Related

Deleting Row At Active Cell

Nov 8, 2013

Creating macros in excel. I am looking for a way to delete a row at the active cell. So far this code does the job for me:

Code:

Sub slet()
ActiveSheet.Unprotect
ActiveCell.EntireRow.Delete
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFormattingCells:=True
End Sub

But I want to make it impossible to use this code on the first 4 rows.

View 3 Replies View Related

Finding A Value In A Cell And Deleting A Row

Feb 10, 2009

I'm looking to do a search and delete in Excel 2007 and I'm having a great deal of difficulty trying to do this. I've attempted to modify some code I found on the internet and not having very good luck with it. Here is the scenario, I've got a spreadsheet with 5 columns (A to E). In column C, there is a product name with certain identifiers that set it apart. An example of this product name with identifier is "product XXX_type 2_attribute ". I want to search for "type 2" in Column C of each row and then delete the row.

Here is what I have written so far and I'm not having any luck.

Sub RowDel()
Dim cell As Range
For Each cell In Range(Range("c4"), _
Range("c65536").End(xlUp))
If cell = "_GPnl_" Then
Range(cell, _
Cells(Rows.Count, 1)).EntireRow.Delete
Exit For
End If
Next cell
End Sub

View 9 Replies View Related

Deleting Part Of A Cell

Apr 5, 2002

I want to delete part of a cell in Excel. For example if a cell had the data "BlueGreen" how would I delete the "Blue" bit just to leave the "Green" bit behind? Surely there is an easier way then physically deleting the first part in each cell? I have about 4000 cells to work on!

View 9 Replies View Related

Deleting Indented Cell

Jan 17, 2010

I have a pretty good sized Database and all the rows that are indented are not needed. Anyone know a way to delete all the text within a cell that is indented?

View 9 Replies View Related

Deleting When Cell Has More Words

Jan 31, 2007

What I am trying to do is go through a large form and remove everything except for a certain set of cells, I am using this code

For i = 10000 To 1 Step -1
Set rng = Range("A" & i)
If rng.Value <> "Employee" Or rng.value <> " Total" Then
rng.EntireRow.Delete
End If
Next i

What I want it to do is go through the sheet and delete anything that doesnt have Employee or Total in column A, but my problem is that they dont JUST say Employee or Total, its more like Employee: Team A or Employee Group 1. The Total part always says "Total of " and a number, but the number is always different. How do I make it not delete it if it has Employee or Total anywhere in the cell?

View 3 Replies View Related

Coverting Cell To Number Without It Deleting Zero's

Feb 22, 2009

I have column of numbers used as item codes, they appear with a small green triangle in each cell. When I select all cells a little blue square pops up with drop down options to convert to number- after doing this the green triangles disappear but then numbers I had listed as eg '043340' appear as 4334. Is there way to make sure zero's are not deleted as some of my results from formulas end up being incorrect.

View 3 Replies View Related

Deleting Cell Values But Not Formulas?

Aug 24, 2013

I work for a bank and we use an excel spreadsheet that has an in depth payment calculator used for creating monthly payment arrangements or calculating settlements on bank loans. I would like to add the following feature and I'm not quite sure exactly how to do it.

For example, imagine cell A1 will contain the full payoff of a loan. I want to be able to put a settlement offer in B1 and have C1 populate the percentage of the payoff that is. At the same time, I want to be able to delete the settlement offer in B1 and put a percentage in C1 and have it calculate that settlement offer in B1. The calculations/formulas to do these problems is simple, but what I need is to not lose the formulas in B1 and C1 if I were to go back and forth entering settlement offers vs settlement percentages.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved