Search results for query: *

I have a spreadsheet with data in each row (as an example) from row 1 through row 500 and I want to add a blank row between each of the 500 existing rows. Is there an easy way to complete this task without having to use VBA? Thanks

Sample Data = Zip Code Address Directional Donation / Land Income 123456789 123 Main Street South 100 / Bus. 10,000 987654321 12345 Oak Bar Ave Northside 10000 / Resd. 100,000 I have a PDF file of over 10,000 rows with a string of data as listed in...

In Power Point, how would you go about establishing an icon or link on a ppt slide where I can click an icon or link to go to an excel or MS Word file and then return back to the same ppt slide. I want to do a presentation where I want to reference data in other applications and be able to...

i currently have a cell that is formatted as time and date as follows: [$-4409]h:mm AM/PM - mmm dd;@ example >>> 2:30 PM - Sept 08 What I would like to do is to only change the font size of the date "Sept 8" but NOT the time. Also, is it possible to change the color of the...

I have a data base that containes 10 columns with over 5,000 rows. The data base has aready been sorted (when I get it) by column # 1 which has the same 10 different names in column # 1. What I am trying to do is to test data in column # 8 (i am looking for the MAX number for each of the 10...

Using Excel. In column a, I have a number on every 10th row(i.e. 10 in cell A10, 20 in cell A20, 30 in cell A30, etc). I want to have a formula in cell B25 that says look in column A and give me or insert the first number I get to when I look at the cells above the current (formula) row...

I am experiencing a problem when I paste data from excel to Power Point. Data I have borders around each cell with data on / in each row and column. Issue The lines ending on each row (on the right hand side) end with an “arrow head instead of a straight line (like this “?”). The same issue...

How do you control the font size in the Data / Validation / "List" dropdown box in Excel without changing the "zoom" percent from the menu bar and without using VBA? Note: I do not want to change the cell font size, just the display of text font size from the dropdown box.

I have created a number of pivotcharts (line graphs) on the same file using raw data located on sheet 1. #1. My question is when I select "Format Data Series" to change the size of the entire line, it will only complete a change for the single selected item (Page selection) and not the lines...

When identifying a table_array in a vlookup formula, must the range be the exact start and end row/col? In other words, can you set the row number to be an additional (extra) number of rows beyond the existing data range to take into consideration a larger data base (table_array) in the future?

I am attemtping to create "two" different types os "SUMPRODUCT" formulas in excel using the DATA BASE below for each problem / formula RAW Data Base Col A Col B Col C Col D Col E 1. Sales State Date Apples Oranges 2. 100 CA 1-Jun-10 100 300 3. 200 TX...

In Excel - I have a file containing over 2,000 rows which has "within column "A" on each row a number of data elements that are not the same length which I need to separate. Note: The data within each row is listed in the following order - 1. the address (differnet length/number of...

I have a file of data that is pulled down into Excel in a sheet that I will call "Raw Data Sheet". This file contains data with approx 10 columns and up to 1,000 rows which could vary. I have 4 other tabs (i'll call Sheet-1, Sheet-2, Sheet-3 and Sheet-4) which I need to pull data from the...

Can anyone provide me with a link to a free web site that covers the initial learning stages of coding VBA for Excel 2003. I am trying to increase my Excel knowledge through VBA coding and I need an understanding on how to write this code. Thanks

In Excel - is there a way to create a pop-up calendar in a range of cells that is triggered when the user placing his cursor in any one of the cells within that range? I would like to simplify the process of external users selecting dates by allowing them to see and select a date from a pop...

When data from a supplied data base is moved to excel, the dates in cell (A1 through A100)is TEXT and left justified in each cell.(ie May, 25, 2009 is listed as May-25-2009). I believe the data is from a CSV file. When I try to save the file; the Save As (pop up window) shows the Save As Type as...

I have a large spreadsheet that I currently have a “vlook-up” formula that is providing me results, however I need to further test another set of conditions that require me to test within the results of the original vlookup function and I am not sure how to code this formula. I want to say, if...

Is there a way to use the countif function like you would use the “count” function in the “subtotal” option in excel? I have a list of data (over 10 columns and over 2000 rows) that I need to test a condition in “one column” and count those cells that meet that condition within each primary...

I have users entering data in column A1 thru A1000. I use these "time" entries HH:MM elsewhere in the spreadsheet that looks for a time value. The problem is that some users will enter the time "incorrectly". I want to discard and/or show a blank if the entry is NOT a time value (HH:MM)...

I am creatng a graph with data for 10 weeks (cell A1 thru J1, however I will continue to add data after each week. I want the graph to automatically update to the last 10 weeks of data. Is there an easy way to do this without me manually changing the data range? Thanks