In Excel for Windows PC, how can you delete a whole row from a spreadsheet that contains a preformated?

Question

calculation formulas (like a check-book ledger spreadsheet, just for instance)and not mess up the remaining calculations? Every time I try to delete a row in the middle of my ledger, the entries below read "#REF" and I get that its because I deleted the need information from the row but, isn't there a way for excel to just skip the missing row and continue on, fixing all the remaining entries as necessary? Please, help! Thank you.

Answer 1

Are you deleting the row entries or the row completely? Highlite the row on the far left of the page on the grey row number. One left click of the mouse should highlite the entire row (if done properly). After it's highlited, right click the mouse and select delete row. This should not give you the #ref entry.

Answer 2

This should work assuming Excel does not have a built in feature to do it. In an unused column put sequential numbers to be used to return the sequence at the end. In another column put 1 and then 2. Propagate it down so you have 1,2,1,2,1,2...... Now sort the sheet on the 1 and 2 column and every other row will be grouped together. Do the formatting. Resort using the sequential number column. Remove the two columns. ✩

Answer 3

You can write VBA code to delete the row your cursor is in and then fix the equations. Then just position the cursor and run the macro.

You could highlight the rows below plus one blank row at the bottom, copy, move up one row, paste.

Answer 4

This can get complicated. Send me that puppy and I'll fix it for you and tell you what the problem was.

Send to [e-mail]

OK?

Answer 5

JUST SELECT THE ONE YOU WANT TO CUT AND CLIP AND CUT IT EASY