##
19 posts tagged with excel *and* formatting.

Displaying 1 through 19 of 19. Subscribe:

## Manager question: excel formatting

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]

## Writing MS Word macro to convert glossary formatting to Excel table

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 need a simple excel macro and I'm willing to pay.

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]

## Excel imported my dates as day-month instead of year-month. How to fix?

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 to merge & combine .pdf to Excel pages

How can you merge and combine imported and converted .pdf to Excel 2007pages? [more inside]

## Copying Word tables into Excel without splitting cells into multiple rows

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

Excel 2007 conditional formatting help! [more inside]

## Help me help Word and Excel play nicely together.

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]

## Excel rounding of number

Is there a way to force MS Excel to always give you four significant digits when rounding a number? [more inside]

## How do I bring HTML data into Excel?

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 do a global change-style in Excel?

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 me an xls table, I do!

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 Excel formula to achieve desired result?

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 get around Excel macro warning.

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]

## Eliminating Hyperlinks in Excel X for Mac?

Probably ridiculously obvious Excel question: how do I set it so that a URL is

*never*turned into a hyperlink? [more inside]## Is there such thing as an Excel formatting template thingie?

Excel Experts: Is there a way to apply a custom formatting template to an unformatted worksheet? [more inside]

## Carriage Returns in Excel

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 can I include declinations in an Excel spreadsheet?

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.

Page:
1