merged cell

  1. E

    auto Filter a merged cell

    hi Please confirm that I cannot filter a merged cell in excel 2010? cheers RM
  2. L

    Automaticaly expand merged cells height

    Hi, How can I set merged cells (with wrap text option activated) to automatically expand when current height is exceeded ? I've unsuccessfully tried many ways. Can somebody help ? :confused:
  3. E

    Data Validations Circles aroung Merged Cells

    I have data entry validations set for some merged cells. However, when I click the "Circle Invalid Data", it circles the merged cell and all individual cells. Is there any way to circle only the merged cell and not the individual cells with it? Thanks in advance!!! :)
  4. M

    Merged cells won't alphabetize

    I've merged each group of 5 rows of Column B to make a larger text box. Other columns don't have merged rows. There's a header row with titles for the columns that has an up-down arrow to alphabetize A-Z or Z-A or numerically. When I try to use this feature, I get an error message: "All...
  5. L

    VBA/Formula to copy a cell and paste it down column A

    Hi, I have a spreadsheet which is downloaded in the following format: (if this doesn't work go to http://tinypic.com/view.php?pic=v8jle&s=6) I need whatever is in the grey merged cell to be copied into column A in all cells above it (see pic for explanation), then delete the merged cell...
  6. C

    Renaming a merged cell

    Hello, I'm trying to rename a merged cell and I'm getting the following error and the last line of the code is highlighted when I debug: Run-time error '70' : Permission denied Sub RenameCell() ' ' ' Sheets(Sheets.Count).Select Cells.Find(what:="general ledger"...
  7. Futile Crush

    Getting a Line Break inside a cell

    Hey guys, I'm having problems with formatting. I'm trying to get text to go to the line below in a merged cell, to no avail, and was wondering if anyone could help. :)

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