Search Results

Search found 4326 results on 174 pages for 'excel workbook'.

Page 16/174 | < Previous Page | 12 13 14 15 16 17 18 19 20 21 22 23  | Next Page >

• How to re-arrange Excel database from 1 long row, into 3 short rows of unequal lengths and automatically repeat the process?

  - by user326884

  This question is an extension/continuation of my previous question at How to re-arrange Excel database from 1 long row, into 3 short rows and automatically repeat the process? which was answered by Jason Lewis of which I'm grateful. But being a dummy in "Indirect' Excel function, I need assistance again : For example :- In Sheet A, Row 1 has…

  Read the article

• Using Excel as front end to Access database (with VBA)

  - by Alex

  I am building a small application for a friend and they'd like to be able to use Excel as the front end. (the UI will basically be userforms in Excel). They have a bunch of data in Excel that they would like to be able to query but I do not want to use excel as a database as I don't think it is fit for that purpose and am considering using…

  Read the article

• How to Transpose Rows and Columns in Excel 2013

  - by Lori Kaufman

  You’ve setup your worksheet with all your row and column headings and you’ve entered all your data. Then, you discover that it would look better if the rows were the columns and the columns were the rows. How do you accomplish this easily? There is an easy way to convert your rows to columns and vice versa using the Transpose feature in…

  Read the article

• Aggregating Excel cell contents that match a label [migrated]

  - by Josh

  I'm sure this isn't a terribly difficult thing, but it's not the type of question that easily lends itself to internet searches. I've been assigned a project for work involving a complex spreadsheet. I've done the usual =SUM and other basic Excel formulas, and I've got enough coding background that I'm able to at least fudge my way…

  Read the article

• Deploying Excel 2003 VSTO Workbook using Sharepoint for versioning control

  - by KClough

  I have an excel 2003 vsto workbook that I would like to make available via sharepoint for version control. Ideally it could be checked in/out by non-developers for tweaking excel equations, and I would be able to deploy the compiled dlls somewhere else when I need to update the managed VSTO code. I understand I may need to use some…

  Read the article

• Keyboard shortcut in excel for expanding the pivot table row?

  - by Martin Vobr

  I'm able to expand/collapse the row in the pivot table with mouse by: right clicking on cell in the first column of the row + selecting "Expand/Collapse"/"Expand" from context menu. or double clicking on the cell in the first column of the row Is there a keybord shortcut for same action? I'm using Excel 2010.

  Read the article

• Excel 2013: Is it possible to collapse rows only in a specific column?

  - by h7u9i

  In my spreadsheet, I'm trying to figure out a way to collapse rows in a specific column. Right now, if I do Data - Group - Group... - Rows, it'll collapse the entire row. I want to collapse rows only in a specific column. Example: |---------|----------| | hi | + data | |---------|----------| | hello | + data2 |…

  Read the article

• Excel for programmers

  - by Rohit

  Recently as part of my job I have had to edit and create a lot of excel spreadsheets. I am familiar with some Excel formulas but while editing the spreadsheets I don't feel that I'm using the full potential of excel. Are there any books/online resources which guide someone with a programming background in Excel?

  Read the article

• Excel Data Organization: Array Formulas? Tables? Named Range?

  - by Joe Arasin

  I'm trying to make a huge Excel sheet reasonably maintainable, but it's huge in the "hundred-table-db" direction, rather than the "hundred-thousand-row-table" direction. I want to have a baseline data table that looks something like this: | Indicator | Units | 2010 | 2015 | 2020 | 2025 | Source | …

  Read the article

• How to sum numbers in a range that only have a particular cell color [Excel]?

  - by jason

  I would like to put a formula in Excel that would sum all the numbers of a specific range that have a specific cell background color.

  Read the article

• MS Excel not installed after uninstalling Crystal Reports Viewer

  - by PowerUser

  I recently tried out the free Crystal Reports Viewer. I installed it on my work computer, but it didn't load (crashed on the EULA agreement of all places). After uninstalling the viewer, however, MS Excel 2003 does 3 things: "An error occurred initializing the VBA libraries (1004)" "Microsoft Excel has not been installed…

  Read the article

• Table Formatting in Excel 2007: How do I remove it?

  - by Mike

  I've used the new Table Formatting option in Excel 2007. Now I can't remove it. I've dragged the little blue square up to the last cell on the top left, but it just won't go any further. In fact it just won't go at all. Clear all doesn't remove it. What does? I want my table back! Thanks Mike

  Read the article

• Remove password from an Excel Document

  - by Ben Confino

  I'm providing internal support and one of our users has managed to put a password on an excel file by accident, I've done the proper checks to make sure that the user should have access to the document and now want to know what the recommendation for removing a password from an Excel document. For what its worth, the…

  Read the article

• Huge excel sheet taking too long to update links or calculate formulae

  - by user7231

  I have Excel sheet with 5000 rows and columns till AY (size 12MB). Except for the first 6 columns, rest contain either vlookups or formulae. All the vlookups are in separate Excel sheet. I have changed the Excel setting to manually update the links and calculate formulae. Now everytime I try to update the links,…

  Read the article

• Color drop down in Excel cell (with no text)? e.g. bgcolor = Red-Green-Amber-unknown

  - by adolf garlic

  I have an Excel sheet that I'm using to keep track of the status of certain things. I want to have a column which consists of cells containing a repeated drop down that allows you to select (as background) red amber green unknown I don't want any text in this cell, I just want a coloured block. Is this…

  Read the article

• How do you update an Excel file (Data Refresh and update formulas) WITHOUT opening the file?

  - by Alex

  I have an Excel file that want to update and save automatically with out having to open it or manually interact with. Manually, I open the file up and hit data refresh which goes and does a SQL query and then hit F9 for the formulas to update and then I just close/save. (I then would mail the file out…

  Read the article

• Excel - Possible to create a sorted view of a column in one sheet on another sheet?

  - by Cumbayah

  Hi; I'm trying, in Excel 2007, to populate a column in one sheet with the data contained in a column on another sheet, so that I may provide another sorting on the data, related to that sheet only. I've tried to boil it down to being able to have a column on sheet2 automatically being populated with all…

  Read the article

• Excel VBA - How to copy/transpose multiple columns record into individual single row

  - by larry

  I'm working on data migration, need some help on doing a macro to copy/transpose multiple columns record into individual single row. There are also a "tag" in the first row, which indicates the columns that should not be included in the copy/transpose. From: Tag x Name Jan Feb Mar …

  Read the article

• how to get data in sheet2 from sheet1 in excel

  - by romen-leung

  I have two worksheets, Sheet1 Column A = Deptname Column B = Headname Column C = Username Sheet2 Column A = Headname (???) Column B = Username Column C = UserID "Headname" column in Sheet2 is blank and what I wanted to do is to get "Headname" from Sheet1 by using "Username". I have tried to use…

  Read the article

• Excel Match Bug in a sparse range with duplicate keys

  - by DangerMouse

  Data in TheRange is {1,"",1,"",1,"",1,"",2} =Match(2, TheRange, 1) returns 9 as expected =Match(1.5, TheRange, 1) returns 7 as expected =Match(1, TheRange, 1) returns 5 which is not expected Anyone come across this ? Anyone got a fix? Additionally if I use Worksheet.Function.Match in VBA I get…

  Read the article

• Excel Prorated SUMIF

  - by Pete Michaud

  I have a worksheet with 2 columns, one is a dollar amount, and the other is a day of the month (1 through 31) that the dollar amount is due by (the dollars are income streams). So, I use the following formula to SUM all the income streams due on or before a certain day: =SUMIF(C5:C14,…

  Read the article

• excel formula problem

  - by Santosh

  Kindly check the below written formula, if the formula is not correct then please provide me the correct one that is related to this. IF(A1:AV7000=F1,vlookup(f2,B1:C7000,2,0),0) As I have tried above written formulas, but it's not working.

  Read the article

• excel formulas..........................................

  - by Santosh

  Dear Experts, Kindly check below written formulas ,if the formulas is not correct then pls provide me correct one releted to this. IF(A1:AV7000=F1,vlookup(f2,B1:C7000,2,0),0) As i have tride above written fromluas,but its not working. Pls help. Regards sant

  Read the article

• excel 2007 vba: how to refer to HPageBreaks

  - by notnot

  I'm trying to write a macro which can look into the list of horizontal page breaks that a worksheet keeps, and it seems like HPageBreaks should be exactly that. I can add or remove page breaks from it, but I can't seem to isolate the collection itself to look at its contents. Even…

  Read the article

• c#-excel interop - create chart on workbook as opposed to in a sheet

  - by david.barkhuizen

  Using c# MS Excel interop library, I would like to programmatically create a new chart on the workbook, as opposed to on an a sheet. The code below allows me to create a chart on an existing _Worksheet (sheet). using using Microsoft.Office.Interop.Excel; _Worksheet sheet; …

  Read the article

< Previous Page | 12 13 14 15 16 17 18 19 20 21 22 23  | Next Page >