I'd like something like conditional formatting, but that works the other way - a cell's value changes depending upon the colour the cell is filled with. [more inside]
I have a question on how to set standards for an ambiguous process. Part of my job involves having my directs "body-shop" powerpoint/excel charts - i.e. organizing things on the page, making tables look nice, filling in / fleshing out commentary, etc. (I'm in consulting). How can I help them do this better? [more inside]
I need some guidance in writing a macro that will parse a glossary Word document and reformat it into an Excel spreadsheet with the term in one column and the definition in a second column. [more inside]
I often (upwards of 15 times a day) need to select some of the text within a cell or textbox in Excel, and format it bold and red. Not all the text in the cell/box -- just the text I select. Is it possible to write macros to do this task? And where should I go to find someone to write it? [more inside]
How do I fix this? I "imported" a table from a PDF (big mistake). In the pdf, the dates were formatted as AA-BB, where AA was the month and BB was the year. Excel interpreted that as AA is the month and BB is the day, and gave them all 2013 as the year. So now the date reads as 11-Jan instead of Jan 2011. I no longer have access to the original dataset because I only just noticed the mistake. I am using Excel 2010 on Windows.
How can you merge and combine imported and converted .pdf to Excel 2007pages? [more inside]
I need help copying a table from Word to Excel in Office 2007. Where there are hard returns within a cell in the Word table, Excel splits the table cell into multiple rows. I need Excel not to split cells in the Word table into multiple Excel rows. At the same time, I need to retain the paragraphs that appear within the Word table cells - that is, I can't just get rid of all those hard returns; the formatting must be preserved. My Google-fu is failing me rather seriously. Is there any way to do this?
Excel 2007 conditional formatting help! [more inside]
I'm trying to paste some text from Excel into Word. Normally when I do this, I select Paste Special > Unformatted Text so my stuff doesn't display as a table. But this time, the Excel text is already formatted with a ton of bold, italics, and underlining, and I don't know how to retain that formatting while still ditching the table. Help? [more inside]
Is there a way to force MS Excel to always give you four significant digits when rounding a number? [more inside]
I once used a web-based spreadsheet tool that let me copy data from pretty much any webpage into a properly formated spreadsheet. Upon pasting an entire page worth of HTML-formatted search results, for example, it prompted me for the desired cell arrangement in the spreadsheet and applied it to the entire set of data. I can't remember what it was called, I can't seem to google the right terms and this will save me (not to mention my employer) countless hours copying and pasting data this week and next. Alternatively if you have another solution, please share.
Is it possible to automate a citation style change on an entire column in Excel, or do I need to do this by hand? [more inside]
I have an xls file I got from a survey I created on Google docs. Now I want to make it pretty without copy-pasting every bloody cell into an Indesign document… [more inside]
What formulae do I need to cause Excel to highlight a cell on one worksheet if the data is found in a different worksheet? Formulae I have attempted (using named ranges) under the cut. [more inside]
How to bypass Excel macro warning or alternative to macro. [more inside]
How can I conditionally format an entire row in Excel based upon the data in one of the columns in that row?
How can I conditionally format an entire row in Excel 2007 based upon the contents of a particular column in that row? [more inside]
Probably ridiculously obvious Excel question: how do I set it so that a URL is never turned into a hyperlink? [more inside]
Excel Experts: Is there a way to apply a custom formatting template to an unformatted worksheet? [more inside]
It's not how I'd choose to spend my Friday evening, but for the last few hours, I've been trying to replace carriage returns that have turned up in an Access and Excel file, and drawing a blank. [more inside]
How do I format cells in EXCEL to accept numeric values in the form: -26:32 (or +26:32 ... that is, mm.ss but including the pos/neg sign)? I'm trying to compile a simply list of Messier Objects (astronomy) and can't figure out how to include declinations.