vertically

Hello! Is there a way to merge vertically cells in a range? (i.e. merge together the cells of all the select rows within the same column) Merging the left column cells and dragging the formatting to the right does not work well, because it does not keep only the top cell value, but it retains...

Hello there! Some time ago I found 2 VBA code blocks on the internet that allow me to do the following: * automatically merge all cells with the same value in the active worksheet * automatically unmerge all merged cells in the active worksheet without data loss (the original value of the merge...

I have a textbox on a worksheet that I want to autosize, but ONLY vertically. I see in its properties the option for AutoSize, but this will adjust the box both horizontally and vertically. How can I lock its width?

Here's the setup. I can send the spread sheet over as well. Column A: Listed vertically an infinite amount: Harden, Westbrook, Jokic, George, Irving, Mitchell, Gobert, Walker, Gasol, Faried Column B: Listed vertically an infinite amount: Salary associated with player in column A: 12900, 11000...

When I amke a bar chart with the dates listed vertically in column A and the values listed vertically in column B the bars are showing series 1 point 2 for example when I hover over the bar. I want it to show the date/year and the value when I hover over it. Why is it not showing that like it...

I have index formula =INDEX($A$2:$F$2,ROW(A1)). I am able to autofill that vertically in column K1 to k6. Then I enter in k7 =INDEX($A$3:$F$3,ROW(A1)) and autofill down. This becomes work intensive with more rows get added or my range changes to A2 to G2 or H2. Is there a way to do this with a...

using number separator (have commas) automatically wraps text vertically when using from the ribbon oddly, using currency, accounting, or even ctrl + 1 then clicking "sepators" doesnt do the same thing ...please help i even tried clearing the entire sheet's formatting then trying again but to...

Hi all, In A2:A32, I have a list of Toyota vehicle names. In subsequent columns from B:S, I have model years. Each vehicle name does not have the same quantity of model years, some have only 1 other have 11. My question is this: A2 (Camry) has 4 model years (B2: E2) to the right of it. In Z2:Z5...

Hi I need help on coding of prefix on invoice numbering as well as merging cells horizontally and vertically, Thanking you in anticipation Sincerely Yours Mfana

I want to make a report with multiple queries within the two separate area of a same report without influencing each other. For instance UNION function merge two queries vertically. Is there any way to do the same Horizontally?

Hi Folks, So need a bit of help. I have hh/raw electricity data that goes horizontaly and i need a vba loop to transpose it vertically. If that makes sense. EG. raw data Day-00:30 next column 01:00 etc I need it to go vertically (not being lazy) but this is over 5,000 odd rows. Any help...

I am currently working on an excel project for school and I am unable to figure out how to align the form control buttons to the left and then vertically distribute it. I have tried adding the options to the quick ribbon but they are grayed out...

Hello everyone! I am having problems figuring out a way to stack images or place images vertically on excel. When saying that, I want to insert a picture and have it move directly below the previous image that was inserted. Usually this wouldn't be a problem, however the images have a...

Hi everyone, Im trying to vlookup a value from another tab (same workbook) with multiples values return vertically. Please help For example: Tab 1 <tbody> A 123 A 111 B 100 </tbody> Tab 2 <tbody> A 123 111 </tbody> Please help!

<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }</style>...