vertical

I have lists of vacation times in a spreadsheet with multiple vacation columns that need to be placed, with other data, into a vertical data formatted spreadsheet. This now requires multiple cut/paste into another sheet, then upload to Microsoft Access to create relationships in a query that is...

Hello All, I need some help with the following: I have a list of codes in column A in which some are repeated. Then I have specific codings across the top horizontally that are individual, but will not always be in the same order. I need to be able to pull the sum by matching both. I'll...

I copied data from webpage that were presented in horizontal, and I want to paste them in Excel sheet in vertical. I tried (Transpose) but it did not work

Hi Is there a way to add Text to the numbers on a Line Charts Vertical Axis i.e. Current Label To 50 50 psi 40 40 psi 30 30 psi 20...

hi why I can not insert a vertical boarder that will divide a cell vertically or inserting a horizontal boarder that will divide a cell horizontally. Both option are available when I go to Boarder-->more boarders. I can insert any other boarders except these 2. Why I can not and why they are...

I have twelve cells of vertical data in a worksheet which I would like to put into a different worksheet in a horizontal fashion with all the correct data and formulae attached within the same excel workbook. I have used paste options transpose but this didn't work.

Folks, I have to add both vertical and horizontal scrollbars in a userform, so far I have this code below for horizontal scrollbars only. Private Sub UserForm_Activate() With Me .ScrollBars = fmScrollBarsHorizontal .ScrollWidth = .InsideWidth * 1.5 End With End Sub The...

Hi all, Using Excel 2016. I have 2 series Clusters Columns I added an XY Scatter with Lines on Combo Chart on secondary Y and Secondary X Axis Not bad, but the vertical line is plotted over a column. Is there any way to get the vertical line to plot immediately to the right of of the column...

Hello I have a vertical column that I want to add and have a total at the bottom. How do I set up the formula so I can just do it once and copy it down the rest of the column so I don't had to manual click on every one of them? Thank you

Hi, I'm not an expert in VBA but I'm trying to learn. I have the following code ( I get inspired from other posts ) : Sub WorkSheet_Activate() Application.ScreenUpdating = False Unprotect "" Range("C8:AC28").Columns.AutoFit Dim cl As Range, rtest As Range Set rtest = Range("F28"...

How can I make a table vertical instead of horizontal?

Hi, I'm looking for a macro to flip horizontal cells to vertical that also keeps the formulas. Does anyone have one in store? Could be basic, and start in active sheet in A1 etc. Thanks in advance!

Hi All, I hope someone can help to solve my problem with using AVERAGEIFS if the multiple criterias is on horizontal and vertical cells, here link of my file. Sorry for my bad English.

Hi all ! I was trying to insert a secondary vertical axis in my graph but unfortunately I'm not able to proceed after step 3 for Excel. https://support.office.com/en-us/article/Add-a-secondary-axis-to-a-chart-025f91b8-d70a-4d4c-b645-1431ec1c8c97 Please tell me how to go about it. i cant see...

I searched this forum and many others with the same results. I am unable, using the attached sheet, to place a vertical perpetual moving date vertical line. Many different tutorials explain ways to achieve this but I believe I am unable to replicate because of how my Gantt chart is designed...

I am working in Excel 2010 and I am having trouble displaying the count and percentages of grand total on a vertical bar chart based on a pivot table. I would like each bar to display both the count and percentage. [/IMG]

Can I compare a range value like 33-54 to a value like 47 and come back with answer of yes or no? I have a vertical look up formula returning a range of values that I would like to compare to another value and state whether that student has met their goal or not. If the student is within the...

Hello, I am creating a 90-year proforma for a ground lease residential real estate deal, and I would like to know how to add vertical lines every 12 months in order to better separate the years for when I am presenting the proforma. Since this proforma is dynamic, and dates change when I...

Hey, I have a format data selection code. What I need now from it is to: Add vertical borders across each column in the selected range. Horizontal AND vertical across row(1) and last row of selected range. Throughout the selected range, if a cell is blank I don't want a vertical border E.G. \...

Hi, I have been using a SUMPRODUCT(SUMIF)-based function with INDIRECT function pointing to a table with named sheets to sum up information across multiple sheets. Example =(SUMPRODUCT(SUMIF(INDIRECT("'"&Projectlist&"'!BK4:BK16");R5!;INDIRECT("'"&Projectlist&"'!BO4:BO16")))) I now wish to...