Search Results

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

Page 32/201 | < Previous Page | 28 29 30 31 32 33 34 35 36 37 38 39  | Next Page >

• How to export AD security list to Excel

  - by r0ca

  How can I export the security member's list from a security group to an excel sheet. I've found some code on the web but I would need an UI or a software that can do this. I'm open to Powershell tho... Regards, D.

  Read the article

• Excel to CSV Comma delimited

  - by mark

  Hi, when I try to save a long list in excel as a CSV comma delimited it works for the first 17 rows an then stops. does anyone know why and how I can fix it ?

  Read the article

• MS Excel - splitting a formula into individual cells?

  - by Nick

  I'm not sure if this is possible, or if I'll have to do it manually, but I have lots of cells in the following format: =87.12+56.52-16.50+98.21-9.51 If possible, I'd like to break it up into columns, like so: I have a data in excel in the format: 87.12 | 56.52 | -16.50 | 98.21 | -9.51 I've tried text to columns based on the…

  Read the article

• how to mail merge data from two sheets (in one excel workbook) to word

  - by nickjohn

  i have an excel workbook with this structure myexcelworkbook.xlxs course sheet with date and venue participants sheet with names and addresses how can i add date, venue, names and addresses from these two sheets of same workbook into word document via mail merge i tried but it uses only one sheet at a time. thanks

  Read the article

• Show cell selection in Excel when not in focus

  - by salle55

  It's really annoying that Excel (2003 and 2007) doesn't show what cell, row or column that is selected when the window is not in focus. I typically want to refer to the current cell or row while working in another application. Is there any workaround or fix that will make the cell/row highlighted when not in focus? I know that you can copy a…

  Read the article

• Resources about Excel tables and structured references?

  - by jtolle

  I'm new to Excel-post-2000, and I'd like to learn more about how to use tables (formerly lists) and structured references. Can anyone point me to some good treatments of this topic that go beyond the help? (For example, there are numerous full books about just pivot tables. Something like that for using table would be ideal.)

  Read the article

• Excel - pivot values in one cell (as comma-separated value)

  - by Chris

  Excel - pivot values in one cell (as comma-separated value) I have two columns of data: Supplier1|Product1 Supplier1|Product2 Supplier1|Product4 Supplier1|Product7 Supplier2|Product3 Supplier2|Product5 I want to 'pivot' around Supplier, and give the list of products in one single cell, comma-separated e.g. …

  Read the article

• Macro to open excel hyperlinks

  - by admintech

  I would like to know if anyone can help me do a macro to open a list of hyper links. I have a list of about 600 hyper links all in a column in separate rows, i have to open each one to see if the link works, yet it is boring and tedious as i have to wait sometimes for excel to catch up i would much rather…

  Read the article

• Excel freezes when copying / cutting to paste elsewhere

  - by Barry

  When cutting/copying some cells to paste them into another sheet/page, sometimes Excel freezes/locks up and fades out. At the top toolbar it says in brackets "not responding". Eventually, I must click 'X' to close the program. It offers to wait for the program to respond, but never does – it just…

  Read the article

• How to match against multiple value possiblities in Excel

  - by Henno

  I have list of person names in column A. I want to display "1" in column B for names which end with either "e" or "i" or "n". If there would be only one match to test against, I would write something like: =IF( MID(A1,FIND(" ",B1)-1,1) = "e", "1", "0") In PHP I would solve that like this: echo…

  Read the article

• How to get file extension in MS Excel?

  - by Nam Gi VU

  I have a column containing file paths. I want to make another column which contain the extensions of the paths only. How can I do this in Microsoft Excel?

  Read the article

• Excel 2007 time miliseconds operations

  - by Fork

  Hi there, I am using Excel 2007 and I am trying to subtract these two values: 11:27:55.428 11:28:09.813 I have tried to format both as time and as "hh:mm:ss.000" and every time I try to subtract them I get #VALUE.

  Read the article

• Full File Path in Reference to Another Workbook in Excel

  - by SHARIQ MUSANI

  I have two Excel files, one on D:\ and the other one on E:\. I reference one from the other, for example, using vlookup in the E: file to search from the D: file, like that: VLOOKUP(A1,'D:\SHARIQ\[FILE NAME.XLS]SHEETNAME'!A1:10,3,FALSE) As long as D:\SHARIQ\FILE NAME.XLS is open, I get…

  Read the article

• Calculate average gas prices by year in excel

  - by ghostryder111

  I have 3 columns, A=Date, B=Price, C=Grade in Excel. I want to calculate the average price of fuel for each year and an overall average of all years by grade. The data table looks like this Date | Price | Grade 2012-05-01 | $3.49 | Regular 2012-06-07 | $3.58 | Regular 2012-04-01 | $3.98…

  Read the article

• Open Source Excel training documentations?

  - by William

  I'm a trainer, basically. I'd like to find some sort of Excel-based training that's under the creative commons, or another awesome license. I want to use it to train others, and make it better. If this doesn't exist, I may have to write it. Because it should.

  Read the article

• Excel formula to compare single value in one cell with multiple values in other cell

  - by Raw

  I have a value in Column A, which I want to compare with multiple values of corresponding cell in column B, and depending on that value, put the answer in column C. For example, using the table below, it searching in column B for values which are less than or equal to 12 and put the answer in…

  Read the article

• Hashed pattern in bargraphs - MS excel

  - by user1189851

  I am drawing graphs for a paper that supports only black and white graphs. I need to show more than 3 histograms and want to have different patterns on them like hash, dotted, double hashed etc instead of different colors in the legend. I am using MS Excel 2007. I tried but dont find a way…

  Read the article

• Two Get-Requests for hyperlink in Excel 2007

  - by xCelUser

  Hi, When I click a link in excel I notice that it requests the same link twice, but only opens one browser. This is a bit odd. Another user has reported the sample problem here: http://www.excelbanter.com/showthread.php?t=117600

  Read the article

• C# Excel file OLEDB read HTML IMPORT

  - by Michel van Engelen

  Hi, I have to automate something for the finance dpt. I've got an Excel file which I want to read using OleDb: string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=A_File.xls;Extended Properties=""HTML Import;IMEX=1;"""; using (OleDbConnection connection = new…

  Read the article

• Excel 2007 PageSetup.FitToPagesWide problem

  - by adopilot

  For while I am trying to set Page Scaling of Excel page in Microsoft Visual Studio project for Excel2007 using C# Code looks like private void Sheet1_Startup(object sender, System.EventArgs e) { PageSetup.FitToPagesWide = 1; …

  Read the article

• SSRS export to Excel UNFORMATTED

  - by mjmcloug

  Hey, I'm looking into SSRS with intention of exporting a lot of the reports to excel. The problem is that when you export it changes cell sizes and removes borders to try and keep the original report format. Is there anyway to stop this happening? So that…

  Read the article

• Excel Interop: Range.FormatConditions.Add throws MissingMethodException

  - by Zach Johnson

  I am writing an application which uses the Microsoft.Office.Interop.Excel assembly to export/import data from Excel spreadsheets. Everything was going fine (except for 1 based indexing and all those optional parameters!), until I tried to use conditional…

  Read the article

• python win32com EXCEL data input error

  - by Rafal

  Welcome, I'm exporting results of my script into Excel spreadsheet. Everything works fine, I put big sets of data into SpreadSheet, but sometimes an error occurs: File "C:\Python26\lib\site-packages\win32com\client\dynamic.py", line 550, in…

  Read the article

• Migrating from VBA Excel 2003

  - by Diego Castro

  I have a series of big excel files that work like a program, but I hate beeing tied up (stuck in VBA for excel 2003), so... Whats the best way to implement a gui over a excel vba program (office 2003)? (are there any tools for that... I want to move away…

  Read the article

• JAVA Excel POI API: Problem

  - by Bilal

  Hi All, I am using the Java POI package to access the excel files. I have an excel file for which i am updating the cell values. those values are being used in some other sheets (within the same excel file) however, when i open the file, those values…

  Read the article

< Previous Page | 28 29 30 31 32 33 34 35 36 37 38 39  | Next Page >