Tagged Questions

0
votes
1answer
30 views

Unintelligible result opening csv in excel

When I open a .csv file in excel this is what is showing up: Maxtor Encryption ver 2.0.1.1.0 ³§o rkDV’)cÿA®T7B‡LôŠì£\% i¼r1 ØÕë—„×½é¿wjd ´Íâ¿…Öö?HÐ)vM!W«Va<žÒ LåRpµI©ô ...
0
votes
1answer
22 views

Excel 2010 Formula Bar - autofit?

In Excel 2003, the formula bar would autofit the height of the active cell. In Excel 2010, this doesn't happen. Is there a way to revert the behavior to the Excel 2003 functionality without trying ...
1
vote
1answer
35 views

Exporting Data into a form type format from Microsoft Access query to Microsoft Excel Worksheet

Thanks for any help you can provide. I would prefer not to use VBA if possible, but will if necessary. I have MS Office 2007. I have a query which holds information for products that need user ...
0
votes
1answer
58 views

Microsoft Excel value lookup, return result in an undefined number of row above

I know how to use the vlookup function to search my worksheet to return the value. However, what if the value that I want is in an undefined number of row above. Example below, if I were to search ...
0
votes
1answer
44 views

Unable to add, create, or remove drop downs on an Excel 2003 spreadsheet

In Excel 2003 the Validation option under Tools is grayed out for a specific workbook. The sheet is not locked or protected, but it is shared. Even the author of the sheet has the Validation grayed ...
3
votes
2answers
54 views

Excel cell formatting

I want to insert numbers in an Excel cell (ex. 01-00), but the formatting wants it to default to a date (ex. Jan-1). How do I delete this formating so I can enter simple numbers?
1
vote
4answers
159 views

How do I align a column of numbers by decimal point in microsoft excel when some of those numbers are negative?

Let's say I have a list of the following numbers: 0.02 -0.25 -0.04 -4.13 -1.12 5.24 -2.12 -11.36 40.61 -141.20 -1.82 -6.48 How would I align them in a column such that they are ...
1
vote
1answer
50 views

Excel_macro_pivot table_analyzing data

I have two problems with my data in Excel. I have this table, so for every day in the year I have got 24 values, that´s 365 columns. I need to write a macro, that transform the data vertically, ...
2
votes
2answers
73 views

How do I stop Excel from checking the validity of hyperlinks before it opens them?

If you open an Excel spreadsheet containing external hyperlinks, when you click the link, Excel will check that the link is valid (i.e. doesn't return a 404 error) before actually opening it in the ...
0
votes
1answer
70 views

How do you use conditional formatting in Excel to format based on previous cell information?

I have a document that is created to monitor complaince. I would like to have the following rules: Highlight the cell if it meets a goal - I've figured this out and the formatting works. Highlight ...
0
votes
3answers
77 views

Multiple “If” answers in one cell

I am trying to make a fishing tournament spreadsheet.... I would like to perform in once cell that if their position was first, they get 100 points. if their position is second, they get 90 points, ...
1
vote
1answer
165 views

Macro to Move Columns Based on Header Criteria MS Excel

I'm starting a new position in 8 days and I'm quite new to visual basic. I was able to job shadow a current employee and in 1 of the reports, the individual was sifting through 100 or so columns ...
0
votes
1answer
52 views

Can I get the properties of the color of a Microsoft Excel cell in numbers/text?

I want to count the yellow, red and white (no color) cells in a column (range) within a Microsoft Excell sheet. The colors are equal (i.e. only one RGB value of yellow is used, not light/dark yellow ...
-3
votes
1answer
16 views

windows vista non f-disk non-linux [closed]

i read the article on the person who tried mendind partitions 1 and 2. my computer had the same problem. also my computer went blank and i tried to use msconfig to mend it. also i applied user ...
0
votes
2answers
80 views

Entering text value representing a sum in Microsoft Excel

Please see this image: Under "Monday" where I have typed rent, I would like that cell to display the text "Rent" still, but to represent the value of rent on row 4. For the formula in "balance" ...
1
vote
3answers
1k views

Excel: Change all cells with one character to something else

Is there a formula I can use that will change all cells with one character to something else? For example, I have cells with single letters and no matter what the letter is I want that cell to ...
0
votes
0answers
61 views

work with huge 15000 lines excel files containing formulas

We work on a huge excel file. it contains a sheet setting 22000 lines We use Excel 2011 on Mac and Windows on Intel i7 with 8Gb Ram. We have disabled the automatic computation of the file the file ...
3
votes
1answer
146 views

Automatic LaTex document generation from Excel spreadsheet

I have some data in an Excel file from which I have to generate a report. I repeat this task fairly regularly and am looking to automate it. I have a LaTeX project into which I usually just copy data ...
1
vote
1answer
607 views

How to insert a table into a header in Excel 2010?

Is it possible to create a table in the header of Excel 2010?
3
votes
1answer
438 views

Importing specific date format to Excel from Microsoft SQL Server

I've already asked the question at: StackOverFlow and got sent to this place here. I'm importing dates from a German SQL Server table into a German Excel file via the built-in Excel connection tool. ...
1
vote
1answer
50 views

Excel working with mouse

I am using excel 2007. When I have put dates in the "A" column, I have to write all the dates way down to 31st of the month. While using the mouse, one can write the first date of the month & then ...
1
vote
1answer
508 views

Sorting two non-adjacent columns without affecting any other column

I have two different columns on Excel. I want to create a script that will sort Column F, (Have a header) and will sort Column B based on where Column F's sort worked out. (Without affecting any ...
1
vote
2answers
300 views

Using Activecell in a VBA formula

I am a newbie @ VBA. I want to use the value of a formula in the active cell to feed into another formula (a sum where the active cell sets the limit of the colum rows to be included in the sum). ...
1
vote
2answers
3k views

How to sum within a date range, Microsoft Excel

I am very conversant with pivot analysis but I do not want to use it for this for my table. I want to be able to make calculations between a date range. For instance, sales of a particular product ...
1
vote
2answers
150 views

Reading macros in an Excel file?

I've got an Excel file (supplied by someone else) that opens with the message This file contains Visual Basic macros. I'd like to look at the macros within the file - they contain code that I ...
2
votes
2answers
65 views

Is there a formula in excel to allow a search in one column? (we're trying to pull specific cities from one column)

Okay, so we have an email database with the home address for each person in it and we need to know if we can enter a formula to search the database to find the specific cities. The column for cities ...
1
vote
3answers
352 views

In MS Excel 2007, replace numeric value with same value plus function

For example, if Column A contains: 123 456 789 I want to replace values with: =(123/60) =(456/60) =(789/60) I know I could create another column to do something similar, but would rather know ...
0
votes
1answer
510 views

How to password protect multiple Excel 2007 files with multiple passwords using a Macro?

I'm new here so please let me know if my post is incorrect or anything like that. I currently have a macro that splits out one excel file into multiple files and saves them separately. This step I ...
2
votes
1answer
1k views

How to return first non-blank cell and if it's already a value before it, return the third non-blank and so on?

How to make a function which would return the first non-blank cell value but if it's defined in the left cells next to it, it would jump 2 cells and look for the next value. Table: 1 | 2 | 3 | 4 | ...
1
vote
3answers
630 views

Hide cells when printing in Excel

I'm using Excel 2007. I have an estimate sheet, which I will use to keep track of client information. There is some low level information that the client shouldnt see on their version of the document. ...
0
votes
1answer
115 views

What is the best way to set up an impressive front page for a Microsoft Excel Workbook that references specific data within the individual worksheets?

I have created a very quick CMDB (Configuration Management Database) within excel and it has different worksheets that refer to laptops, desktops, printers etc. I want a front sheet that I can brand ...