vertical

While typing in a cell, there are automatic vertical lines between each latter. The lines disappear when exiting the cell. This started happening recently. Please help, this is driving me nuts. Microsoft Office 2010 (I had to paste the image, sorry about the resolution)

Hi, I am producing new excel timesheet for our monthly employees. I need a SUMIF for vertical if possible? What I need it to do is if I place a PL in a cell with an amount eg 7.6hours I want that to show up in the column at the end of the spreadsheet. I tried SUMIF but that only works...

Hi I've got an Excel (2013) Gantt with the following Axis settings (which already display the date, however, not every single day which is what I need): Bound Min 42020.0 Max 43510.0 Unit Maj 10.0 Min 1.0 vertical axis crosses - automatic Display units - none. Which boxes do I change in order...

Hello, I have a chart that updates based on the drop down selection of accounts. The problem I am having is that some of the data is in percentages some in regular number format (wide range of numbers). The VBA seems to work for most of the data but when a selection is made were the data is...

Hi all. I read this post by Bill Jelen explaining how to do this for a one record: Spreadsheets: The Vertical-Horizontal Flip In my case, I have a record containing 10 items arranged vertically in one column. The records repeat, so record two is rows 11-20 and so on. I can't figure out how to...

I have a database which I have to enter about 5K line items in a specific format. I am not sure how to translate my raw data into the acceptable format. I have only moderate Excel skills, and know little about macros/VBA. Any help is greatly appreciated! Current format: <tbody> Customer/Fcst...

Hello, I have a data set that looks like this: In the first data table, the columns named 1-5 are essentially feedback from sales people on information for Companies 1-7 (but goes to around 220 Companies in my RL spreadsheet). <tbody> 1 2 3 4 5 <tbody> Company1 </tbody> ProductA...

I have a really great formula (not my own design) which does 99% of what I want but falls at the last hurdle. My spreadsheet is basically a 2 column list of things, for example fruits, with a corresponding attribute, such as colours. So A:A might contain apple, apple, banana, banana... and the...

Hello, So, I have a relatively simple request. I have the following table. <tbody> Sizes: Red Blue Green Yellow Black White Purple Orange Brown Total 5 1 16 15 21 12 7 9 1 Item 1 2 0 1 8 8 1 1 9 0 Item 2 0 0 0 0 1 0 0 0 0 Item 3 0 0 0 0 0 0 0 0 0 Item 4 1 1 14 7 12 11 6 0 1 Item 5...

<tbody> Acct Symbol Shrares 123 AAPL 300 123 GOOG 200 567 AAPL 600 567 GOOG 400 </tbody> End Result: Acct Security Shares Acct Security Shares 123 APPL 300 567 AAPL 600 123 GOOG 200 567 GOOG 400 I'm a VBA beginner and am trying to write a code to...

Hi, I have values on the same workbook that I need to copy from (horizontally) B15:Y15 to (vertically) B99:B122. What formula would be best for accomplishing this? Thanks for your help! Matt

I cant really explain this well so here is an example. I need a formula to populate Column B. Any ideas would be super

Hey guys, I've been following a book on how to create a pivot table using VBA. The code in the book works fine and it's doing what it's supposed to be doing. But i don't understand how to change how the Datafields are displayed. It's listing the datafields horizontally one on top of the...

I am trying to cut data from a site, (i.e. Name, address, city, etc) that is in a vertical column. I want to paste it in a horizontal manner so I can do mail outs. I try the past special under the paste tab in 2007 and all it gives me is the option to paste html, text and something else with...