add blank line

  1. L

    Macro Creation - Sort Rows, Add blank row, conditional format text

    I'm looking for assistance in setting up a macro to do the following. 1. Add a blank row in between each set of value from Column G. Column G is named "Handler (Job)" and may have different values on different tabs. Let's say it comes looking like this - Bob Susie Susie Lauren Bob Lauren...
  2. U

    VBA: Add blank cells based on Specific date

    Hi Gurus, Can you share your idea on how to automate this? I have below data usually long set. Account Country Score Date 1 France 1000 09/30/2021 2 Norway 500 05/31/2019 I wanted to separate and add 2 blank cells if the date is more than 1 year. Let's say macro will ask for...
  3. N

    Add blank cells

    Good afternoon, I am trying to create a Macro to add a blank cell in-between line. Every month when we do this there is no way to know how many lines we will have. Manually doing these I do the following: Number the cells next to the date and auto fill all the way down. Copy the numbers. Paste...
  4. S

    Code to put blank line before text in each cell of column

    I have text that is pasted in cells in column G of page 2. In each of those cells containing text, I need a code that would place a blank line before the text and in essence, place the text in the cell on line 2 within the cell. Can anyone help with this one?

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
Back
Top