Topics: excel

excel Feed    excel Open Questions Feed    excel Email    Open Questions via Email

Please sign in or register to post.

Please sign in or register to post.

• unknown format

  Asked by Mike10 : 07 October 2012 - 09:08 AM

  Tags:

  • formats
  • data
  • excel

  0Answers

  0Comments

  ---

• how to combine excell file into one using java.

  Asked by antzrambo : 14 February 2012 - 05:48 PM

  

  Answered by Michele Milesi : Mar 20 2012 11:15 PM
  You may try to use Apache POI (poi.apache.org) that works both with XLS and XLSX formats. You can create a new workbook with three sheets, then open each of the original excel files and append the re... full answer >

  Tags:

  • excel
  • sheet
  • workbook
  • java

  1Answer

  0Comments

  ---

• Conditional text format based on date and time

  Asked by Eeor : 28 October 2011 - 06:04 AM

  Tags:

  • Hacks
  • Excel
  • Conditional
  • Format

  0Answers

  0Comments

  ---

• Complete Guide to Microsoft Excel Macros, Published by Microsoft Press, 1993

  Asked by pkryzsko : 04 February 2011 - 08:27 AM

  

  Answered by rachel.j : Mar 16 2011 01:44 PM
  Hi, Thanks for writing us about this, and I'm sorry for the delay in responding. It looks like we're not distributing this book (and it's out of print), so that's why it can't be ... full answer >

  Tags:

  • excel

  1Answer

  0Comments

  ---

• Self-updating week-based schedule with coloums. Is this possible? Many questions within.

  Asked by Inforiel : 03 February 2011 - 03:05 AM

  Tags:

  • excel
  • 2010
  • excel 2010
  • week
  • schedule
  • weekly schedule
  • self-update
  • coloum lock
  • week-update
  • self-moving coloums

  0Answers

  0Comments

  ---

• How to Reassign Key Combinations in Outlook 2011 for Mac

  

  By ChrisGrover : 19 January 2011 - 05:23 AM

  Pressing a staggering number of keyboard shortcuts can trigger an equally staggering number of Office commands. The only problem arises when you discover that Microsoft has chosen something bizarre (l...

  Tags:

  • office 2011
  • microsoft
  • macintosh
  • word
  • excel
  • powerpoint

  0Votes

  0Comments

  ---

• What's New in Office 2011 for Macintosh

  

  By ChrisGrover : 11 January 2011 - 03:12 AM

  Microsoft gave Office 2011 significant improvements over its predecessor, Office 2008. You can’t miss the new ribbon and Spotlight search box—but there’s also an array of less obvious enhancemen...

  Tags:

  • word
  • mac
  • microsoft
  • office 2011
  • excel
  • powerpoint

  2Votes

  1Comment

  ---

• How to Export Customer Information from Quickbooks 2011

  

  By BonnieB : 12 November 2010 - 04:40 PM

  QuickBooks lets you do lots of cool things with customer info, but say you have a mail merge already set up in FileMaker Pro, or you want to transfer all of your customer records to Access to track pr...

  Tags:

  • quickbooks
  • accounting
  • excel

  0Votes

  0Comments

  ---

• How to visualize an Azure table in Excel, using OData

  

  By JonUdell : 21 September 2010 - 10:57 AM

  Introduction The elmcity service makes extensive use of the Azure table service. Why use this cloud-based key/value store instead of the corresponding SQL-based offering, SQL Azure? The standard ...

  Tags:

  • elmcity
  • azure
  • odata
  • excel
  • powerpivot

  1Vote

  0Comments

  ---

• Is there a way to automate worksheet names in Excel?

  Asked by SUPERNOVIA : 15 September 2010 - 12:39 PM

  

  Answered by Alanle [MS} : Sep 17 2010 07:17 AM
  Hi, There is, the article that describes how to do this is on the Office site at Running a macro when Excel starts You can then add the code that renames and creates the sheets with the right names ... full answer >

  Tags:

  • excel

  1Answer

  0Comments

  ---