Search Results

Search found 5003 results on 201 pages for 'excel charts'.

Page 72/201 | < Previous Page | 68 69 70 71 72 73 74 75 76 77 78 79  | Next Page >

• How do I prevent users from entering a blank value in an Excel sheet?

  - by Tola Odejayi

  I want to restrict users to entering either just 0 or 1 in an Excel 2007 sheet. I use the Data Data Validation dialog to do this, but I'm finding that it doesn't stop them from entering blanks. What I would like is for there to be a prompt when they enter blanks, just like the one that appears when they enter any other non-blank data that is not…

  Read the article

• Excel Macro To Lookup a User Entered String, and return data from the field next to it

  - by CJG

  On worksheet A, a user is prompted to enter a product number, such as BCI610. On worksheet B somewhere, that value exists. I want excel to lookup/find that value, and then return the data in the cell that is right next to it one column to the right, by copying that data, and pasting it somewhere in worksheet A. If I enter BCI610, it should…

  Read the article

• how to make Excel/Access data have more than one quantity in a table?

  - by Xrave

  Sorry for the confusing question, I'm not sure how to word it right: here's a mock sample of my data Name: Cheeseburger Date: 1/20/2011 Stock: 30 Price: 200 Name: Hamburger Date: 1/20/2011 Stock: 12 Price: 180 Name: Cheeseburger Date: 1/21/2011 Stock: 31 Price: 210 ... I will have to make a table in excel or access capable of looking up…

  Read the article

• What function should I use in Excel for searching a (multiple) text string?

  - by Alenanno

  The title is a bit unclear, but I'll be explaining it now for better clarity. I have this: When I type in the Input field, I'd like Excel to show me the result in the Output field. For example, if I write Four, I'd like it to output 20, or if I write one of the other three words, then 12. The problem is that... I can't make it to work.…

  Read the article

• How to select all ActiveX objects in an area using a mouse in Excel?

  - by enderland

  Because of this problem with ActiveX objects changing size, I am not grouping my ActiveX objects in my Excel worksheet. Grouping them causes my solution hack to not work which is quite annoying. However, I often times want to be able to essentially use the mouse and select a region and then select all ActiveX objects contained in the…

  Read the article

• How to reference or vlookup a list of values based on a comma separated list of column references within a cell in excel?

  - by glallen

  I want to do a vlookup (or similar) against a column which is a list of values. This works fine for looking up a value from a single row, but I want to be able to look up multiple rows, sum the results, and divide by the number of rows referenced. For example: A B C D E F G …

  Read the article

• Handling "No cells were found." Error in Excel

  - by Sathish

  I am working on Excel VSTO application and finding error cells in the worksheets using the below code Excel.Range rngTemp; Excel.Range rngErrorRange; Excel._Worksheet Sheet1 = (Excel._Worksheet)xlCTA.Sheets["Sheet1"]; rngTemp = wsCTAWK11.UsedRange; rngErrorRange = rngTemp.SpecialCells(Excel.XlCellType.xlCellTypeFormulas,…

  Read the article

• How to manipulate and print a chart in MS Excel from AppleScript?

  - by Stu Thompson

  With an existing chart in a MS Excel for Mac 2008, in AppleScript, I am trying to do two things: Rotate a 3D chart 1° Save the chart as a image (png) From what I've found on the Intertubes, it seems possible. But AppleScript's awkward verbosity and the lack of non-trivial MS Excel AppleScript examples on the web are…

  Read the article

• Determining actual args an Excel UDF was called with.

  - by Frederick

  I'm adding a user defined function to Excel with varargs-based signature in C++: XLFUNCTIONIMP(MyFunction)(...); When Excel calls MyFunction, it passes it 30 arguments regardless of how many the user entered in the sheet. The extraneous ones are blank strings. MyFunction, however, is designed to accept empty string…

  Read the article

• How do I shim a Excel automation addin that implements IDTExtensibility2 but is not a com add in?

  - by Shane

  I found this article http://blogs.officezealot.com/whitechapel/archive/2005/05/21/4728.aspx but the example given is a straight automation add-in that does not implement IDTExtensibility2. My add in implements IDTExtensibility2 to get access to the excel object model but is not installed as a COM add in so…

  Read the article

• Is it possible to return a list of all ranges from all worksheets in an Excel 2002 workbook?

  - by generalt

  Hello all. I want to extract "special" data from an Excel 2002 (client requirement, cannot change) workbook and worksheets contained therein. I have classified ranges in this "special" data category. I would like to acquire a list of all ranges in, ideally, all worksheets in a workbook. The attributes…

  Read the article

• How to copy a formatted cell in Excel to a table cell in Word using .NET?

  - by Harry Nath

  I'm attempting to copy cells, one at a time, from an Excel 2003 (or 2007) spreadsheet to a Word 2003 (or 2007) table. I'd like the code to be version-agnostic, and so am using late binding. The formatting of the contents of the Excel cell, such as color, underline, strike-through, needs to be preserved.…

  Read the article

• How to copy from C# control and paste link into excel.

  - by Steve H.

  I have an application that I want to link to excel. I have no preference which control is used as long as I can copy the data or control, and paste link into excel. When the data changes in my application, I want the cell to change in excel. I have a client that claims it is possible and he has seen…

  Read the article

• VSTO: Attach meta-data to a cell in Excel?

  - by Gustav

  Hi! I'm using VSTO to create an Excel Add-on. This add-on retrieves and display alot of data from a sql-server. This works great, but later on I plan to access some of the data inside excel and modify it in some ways. My problem is that I need a way of classify cells that I want to modify. Is there…

  Read the article

• .NET Excel Interop - Why aren't my Footers displaying in my printed output file?

  - by Ryan

  I'm working with C# and Office 2007's Excel Interop API. I'm opening an Excel file, applying some formatting and then sending it to the printer. I've got a problem, though. The Footer text doesn't appear to be printing. If I check the PageSetup.RightFooter property, I can see the expected Page…

  Read the article

• How do you write multiple lists from Matlab to the same excel file?

  - by Ben Fossen

  I have several lists in Matlab that I want to write to the same excel file. I have one list xordered and another list aspl. I do not know the length of the lists till after I run the Matlab program. I used data = xlswrite('edgar.xls',fliplr(sortedx'),'A2:A3000') for the first list but…

  Read the article

• How to read a column in a tab-delimited Excel file in C#?

  - by janejanejane

  I have some data of an excel file below. At first, I figured that reading from the file could be done using the Excel Library then using an OLEDB connection. I managed to get the DocumentNo column data with the OLEDB approach. However, when the excel file is closed, I am unable to do the…

  Read the article

• Can you detect if and excel find and replace is active during worksheet_change()?

  - by John Griffiths

  Hi I've just crashed excel using amazon spreadsheet to update feed. When doing find and replace [replace all] with 2 cells selected after the first replacement the worksheet_change() function finished with the whole spreadsheet selected. This meant that the replacements took place…

  Read the article

• Is there a way to hide a row or column in excel without using VBA?

  - by AJ

  I know of several approaches using a macro (VBA) to show/hide columns and rows in Excel, but I cannot figure out or find a way to do this using either a formula or conditional formatting. Of particular interest is Excel 2007 - but I'd be curious to know if someone has managed to do…

  Read the article

• how do i set a value to a range using a function from module in excel vba?

  - by gadym

  hello all, i want to do a simple function in a module in excel vba, so i can use it as a custom function in excel. (i use excel 2003, or 2007 , it's doesnt matter) i create a function(!) in a new workbook and it's looks like this: Function a() Sheets(1).Range("A1").Value = 4 end…

  Read the article

• How Does a Touch Screen Phone Work? [Chart]

  - by Asian Angel

  There are three types of touch screen technologies available in today’s touch screen phones: resistive, capacitive, and infra-red. Learn about the different benefits and capabilities of each and make a more informed decision about your next mobile phone selection with this helpful…

  Read the article

• The Excel Column Name assigment problem

  - by Peter Larsson

  Here is a generic algorithm to get the Excel column name according to it's position. By changing the @Base parameter, you can do this for any sequence according to same style as Excel. DECLARE @Value INT = 8839,         @Base TINYINT = 26…

  Read the article

• Cloudcel: Excel Meets the Cloud

  - by kaleidoscope

  Cloudscale  is launching Cloudcel Cloudcel is the first product that demonstrates the full power of integrated "Client-plus-Cloud" computing. You use desktop Excel in the normal way, but can also now seamlessly tap into the scalability and massive parallelism …

  Read the article

• Export Gridview/Listview to Excel with Color formatting

  In this article, I explain how to export Gridview / Listview to excel with same color formatting using .net.

  Read the article

• Excel or Access: how to group several lines in a table and insert contents in columns? ("split column")

  - by Martin

  I have a table containing data of sold products (shown in the example on the left): Columns: Number of the order Product Name Attribute - specifies what is given in the following field "value", e. g. Customer Name or Product Variant Value - is the value of the Attribute Count -…

  Read the article

< Previous Page | 68 69 70 71 72 73 74 75 76 77 78 79  | Next Page >