891 posts tagged with excel.
Displaying 751 through 800 of 891. Subscribe:

Strip HTML from Excel

I have a large excel spreadsheet that contains various html tags, mainly bold and anchor tags (in upper case and lower case). How can i automagically remove them? [more inside]
posted by anonaccount on Oct 27, 2006 - 9 answers

Excel cells as input AND output?

Excel wizards: is it possible to create a temperature conversion calculator (Celsius, Fahrenheit, and Kelvin) using only 3 cells for the interface? I have the conversions and know how to do conditional formulas, but what tricks would be involved in having each cell handle both output and potential input?
posted by Tubes on Oct 24, 2006 - 15 answers

Excel: Connecting the dots between inconsistent data

Excel: I am trying to create a line graph of last year's workload versus this year's workload. Problem is, I don't have consistent data and my graphs have numerous gaps between data points. How can I best fill these gaps? [more inside]
posted by Ziggy Zaga on Oct 15, 2006 - 6 answers

My Mac(Book) Sucks

Any advice for my MacBook Word / Excel / Powerpoint woes? [more inside]
posted by roofus on Sep 29, 2006 - 17 answers

Help me optimize a list in Excel.

Help me optimize a list in Excel. (Excel gurus welcome!) [more inside]
posted by pealco on Sep 28, 2006 - 3 answers

How do I COMPLETELY turn off Excel autoformatting?

How do I completely turn off all autoformatting in Excel? [more inside]
posted by EndsOfInvention on Sep 28, 2006 - 6 answers

Help for Excel

Excel help please: Is there a keystroke for Insert->Name->Define? Can I make one? How? I use this a ton in my work.
posted by eatdonuts on Sep 25, 2006 - 6 answers

I need a fix for an excel formula recalculation error.

I can't get a formula in excel to recalculate when copied and pasted to another cell. Help! [more inside]
posted by batcrazy on Sep 21, 2006 - 6 answers

Oh. My. Code. Excel VBA Needs

I've created a button in Excel 2002 that runs some VBA when clicked. Works great. I've emailed the spreadsheet home and opened it with Excel 97 and clicking does nothing. When I run the subroutine from VBA editor, it works fine. So, what gives? Why won't this work in Excel 97 and what can I change so that it will run in Excel 97 and beyond? I've pasted the subroutine into the Extended box. Oh, and I'm really an infant with this, so please try and communicate on that level. [more inside]
posted by kc0dxh on Sep 8, 2006 - 11 answers

Comparing names in excel

How do I compare lists of names from two excel spreadsheets? [more inside]
posted by drezdn on Sep 7, 2006 - 9 answers

Excel pop-up won't leave

There's a little pop-up menu beside a cell in Excel. I cannot click it open to see what it's trying to offer, and I cannot "clear all contents" in that cell to get rid of it! [more inside]
posted by umlaut on Sep 6, 2006 - 11 answers

Split up my file! Argh!

I need help reformatting a .lst file for use in Excel (I think)... [more inside]
posted by knapah on Sep 6, 2006 - 6 answers

Lots of data

Dealing with a big Excel database. [more inside]
posted by salvia on Sep 1, 2006 - 13 answers

Champagne scheduling app on a beer budget.

OfficeApp Filter: How can I seamlessly convert lists of project assignment names and deadlines to a calendar view that can be shared? Or can I? [more inside]
posted by Marnie on Aug 22, 2006 - 4 answers

Excel master needed...where to find one?

I run a computer service. I have an issue that is a bit outside the bounds. I have a client who has been using an Excel spreadsheet to track his portfolio. It is pre-formatted for him to enter data and the formulas are all there. Just recently, it started calculating some things incorrectly. The person who originally set it up just passed away earlier this year. We need an Excel expert that can look at the file and don't know where to begin to find one. Checked the local community college but no dice. All ideas or pointers are appreciated.
posted by titans13 on Aug 17, 2006 - 11 answers

Excel: moving data from multiple columns to a 2-column format

Excel / VBA help needed: moving data from multiple columns to a 2-column format [more inside]
posted by blag on Aug 17, 2006 - 9 answers

Understanding external references in Microsoft Excel?

It's very clear in Microsoft Excel how to calculate formulas using external references, but what isn't clear is how, in several worksheets, to have the same data in certain columns. How do I do this? [more inside]
posted by arimathea on Aug 8, 2006 - 9 answers

Way to automate string creation from values in an Excel spreadsheet?

Way to automate string creation from values in an Excel spreadsheet? [more inside]
posted by mhaw on Aug 5, 2006 - 6 answers

Break Excel password?

Is there a way to break/uncover/crack/hack an Excel spreadsheet password? [more inside]
posted by jckll on Jul 26, 2006 - 10 answers

How to search an interior matrix/array and lookup a corresponding value in Excel?

Excel Powers Active! Vague Excel spreadsheet lookup problem inside. [more inside]
posted by brettcar on Jul 21, 2006 - 8 answers

File listing help

How can I easily get all the music files on my computer listed on to an excel spreadsheet? [more inside]
posted by Todd Lokken on Jul 21, 2006 - 9 answers

Excel Hours Mins

Excel Filter: I need to convert a wallop load of cells that are in decimal format to hours & minutes format. Please. More Inside. [more inside]
posted by kev23f on Jul 21, 2006 - 15 answers

Pre-1900 dates in Excel?

Is there any way to make Microsoft Excel recognize dates before 1900? [more inside]
posted by marxchivist on Jul 19, 2006 - 10 answers

Excel help needed

How do I work with (merge) these 2 Excel Spreadsheets? [more inside]
posted by valleys on Jul 15, 2006 - 5 answers

How to fix the number format of an Excel file

Is it possible to stipulate that a Microsoft Excel file will always display a specific number format e.g. the Anglo-American decimal point, regardless of the local settings of the computer where it is viewed? [more inside]
posted by rogerh on Jul 13, 2006 - 3 answers

How to highlight cells in excel with a keystroke.

MS Excel XP: What is the keyboard shortcut to highlight a cell? My searches turn up no answers.
posted by bigmusic on Jul 8, 2006 - 8 answers

Data Organization Software Anyone?

DataOrganizationFilter: I am looking for software that will allow my market research team to efficiently store and access information from PDF and Excel files. [more inside]
posted by drkrdglo on Jun 28, 2006 - 6 answers

Point plotting problems!

Excel 2003 graph woes. My friend is looking to make a simple x:Date; y:Value chart but with one problem. [more inside]
posted by jedrek on Jun 22, 2006 - 6 answers

How to change poorly formatted text into a usable database.

I have a directory which is swell for printing, but I need it in a database. [more inside]
posted by Classic Diner on Jun 22, 2006 - 3 answers

I just wanna hide!

I have an Excel worksheet populated with data from columns A through IS. I’d like to hide columns but I am getting the following error: “Cannot shift objects off sheet.” Why? [more inside]
posted by phoenixc on Jun 19, 2006 - 5 answers

Excel - Concatenate fields through Vlookup...or something

Excel Filter: Concatenating fields through VLOOKUP. Is it possible? What I'm trying to accomplish inside... [more inside]
posted by bwilms on Jun 9, 2006 - 10 answers

Excel: How to write a formula that calculates weekly pay?

Excel: How do you write a formula that calculates weekly pay? [more inside]
posted by dabradfo on Jun 7, 2006 - 13 answers

How to correctly export columnar labels from Word into Excel?

A friend has a large list of address labels in column format which were created in Excel, then exported to Word. He no longer has the original Excel file. [more inside]
posted by empyrean on Jun 6, 2006 - 6 answers

Excel text hacks?

Stripping out extra text in Excel? [more inside]
posted by Gilbert on Jun 2, 2006 - 8 answers

Visual data organization.

I would like to make a chart like this to track my daily computer usage. Any ideas on how I could do this? Any free software you can recommend? Any way of doing it with Excel? [more inside]
posted by bubukaba on Jun 1, 2006 - 6 answers

Tracking UPS Packages in Excel?

Is there a way to import UPS tracking information into an MS Excel document? [more inside]
posted by dripdripdrop on May 29, 2006 - 6 answers


I need help with an Excel formula. Warning: this may venture into the realms of calculus. Maybe. [more inside]
posted by thecjm on May 21, 2006 - 7 answers

Rolling Averages in Excel?

Excelfilter: how do I compute a rolling seven-day average for something that happens at sporadic intervals? [more inside]
posted by jessamyn on May 21, 2006 - 21 answers

Excel Help for Pie Graph of Frequency of Appearance of Values in a Column?

ExcelFilter: I need help creating a pie chart as a separate worksheet in Excel that counts how often values appear in a column and creates a pie graph based on that data. I'm stumped, I'm not using the right Google terms, and my company's help desk couldn't guide me through the process, either. (That sounds awkward, so I describe it more comprehensibly inside.) [more inside]
posted by WCityMike on May 19, 2006 - 9 answers

What's the best way to make an ellipse (rather than bubble) chart in Excel?

Let's say I want to make a chart that's like an excel bubble chart, but I don't want the size of the bubble to vary depending on a third variable. Instead, I want the width of each bubble to vary by some amount, and the height of each bubble to vary by a different amount. [more inside]
posted by sentient on May 15, 2006 - 2 answers

Excel- conditional data copy

Excel use question: what's the term (and usage, if you don't mind) for the concept of "copy only the rows with (special indicator here) from that worksheet"? [more inside]
posted by Steve3 on May 15, 2006 - 3 answers

Working with Excel 95 files

How can I convert Excel 95 to at least '97 when uploaded to a server (iis) or... [more inside]
posted by Mick on May 2, 2006 - 7 answers

A really simple Excel question, except for someone like me

MS Excel question. [more inside]
posted by Mr. Justice on Apr 28, 2006 - 6 answers

I hate Visual Basic

MSExcel: how to place data in one cell from an ODBC source based on data in another cell? [more inside]
posted by randomstriker on Apr 26, 2006 - 1 answer

Help me set Firefox as the default browser. No, really.

I installed MS Excel after Firefox and now Excel is convinced that URLs need to open in Internet Explorer. I tried the suggestions in Excel's help file to change it back. They didn't work. [more inside]
posted by Tuwa on Apr 24, 2006 - 9 answers

Missing Formula Bar

Excel for OSX Filter: My Formula bar disappeared and I can't get it back! [more inside]
posted by crapples on Apr 23, 2006 - 3 answers

Can I get a hybrid text file/spread sheet?

I'd like a word processor that mimics Excel sheets. [more inside]
posted by oddman on Apr 14, 2006 - 10 answers

Best Fit Ellipse?

How can one create a best fit ellipse around a cluster of (x,y) points in a scatter plot within Excel? [more inside]
posted by geonags on Apr 12, 2006 - 33 answers

How to run a SQL Query on an Excel Spreadsheet

I have an Excel Spreadsheet (using Excel 2003). Rather than creating formulas to answer ad hoc questions that I have, I would like to be able to quickly type in a SQL querty against the data in the spreadsheet. So, I could scroll down to the bottom of the sheet to see how many rows I have, OR I could type" select count(*) from data_table" instead. I prefer the latter. Any suggestions? [more inside]
posted by apark on Apr 7, 2006 - 6 answers

“Eventually, all things merge into one, and a river runs through it.”

Complex Excel to Word merge question is the [more inside]
posted by anastasiav on Apr 6, 2006 - 10 answers

Page: 1 ... 11 12 13 14 15 16 17 18