insert cells

  1. H

    insert cells/shift down and entire row gets inserted...

    highlighting 4 cells/in columns AA6-AD6 to insert cells/shift down and entire row from far left keeps getting inserted. nothing merged. unfreezed everything. no hidden columns. Lots of data - shared document - Excel 10. any ideas? Thanks! Holly:confused:
  2. M

    rearranged cells in Excel insert and crash

    Hello all, I use Excel for Mac 2011 on a 3 year old MacBook Pro 17". A few months ago, I had open two Excel worksheets that were a tab-delimited text (.txt) file and a regular file (.xlsx) (a Word document file [.docx] was open in the background). I copied around 850 cells from the .xlsx...
  3. S

    Adding Cells in Column O based on value on Column K

    I need help writing VBA code to add a cell within a column based on a value in another column. Basically, if cell "K2" is greater than 0, I want to run a code that would insert a blank cell into that same row (cell "O2"), which would shift the current contents in O2 downward. I would like this...
  4. D

    Dynamic Column Selection and Insertion

    Hello, I am new to macros and VBA so I apologize for my poor explanations. The issue is that the spread sheet I'm working with has dates which are incorrectly read and filtered improperly. When I go to filter the dates, it lists every single date in the column instead of by year, month, and...
  5. M

    Changing Default in a command in Excel 2003

    I put the default toolbar button to insert a cell on a worksheet. However, I want to insert it horizontally and not vertically. If I use the menu, it gives me the option to change it to horizontally for that instant. But if I use the toolbar button, then it does it vertically automatically. Is...

Some videos you may like

This Week's Hot Topics

  • Use Filter function with 2 criteria to return a specific value
    I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
  • Loop stopping at row 10
    Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
  • Numerical Order Code for Macro
    I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
  • Calculate time in excel
    I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
  • VBA
    Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
  • Help with formula to sum numbers prior to date
    Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top