• Export Outlook 2007 calendar to Excel spreadsheet

    How do I export Outlook calendar 2007 to Excel spreadsheet?

    Cwessner5 pointsBadges:
  • Excel compact or compress utility?

    Microsoft Access has a repair and compact utility built into it. I'm looking for something similar for Microsoft Excel -- mostly to reduce the size of bloated spreadsheets. Any suggestions (other than manually copying the important data from the large spreadsheet to an empty and clean new...

    DKoch675 pointsBadges:
  • Excel formula to find and replace letters in a word

    Hi, I have a cell that has a word written in it ex. damascus. Now with this formula, I need to be able to find the "a" and replace it with "A" so it will become dAmAscus. Is this possible?

    Microbert25 pointsBadges:
  • How do I change a single cell size in a spreadsheet

    I have a spreadsheet and I have set column widths. I would like to change one cell in that spreadsheet without changing the width of all of the rest of the sheet. Is this possible? Also, is there a way to set the page sizes separately i.e. page 1 legal, page 2 letter?

    Cat1005 pointsBadges:
  • Conditional formatting

    Hi there. I want to change the cell colour shading of range A10:F10 to one of three colours, depending on the contents of another cell outside this range (J10). Can this be done please?

    Twiggy196510 pointsBadges:
  • Compatibility mode

    My Excel documents are saving in compatibility mode. How do I change this?

    jlynkett75 pointsBadges:
  • Excel equation

    When working out an equation in Excel, if I use a comma, it will work out the equation for me, but if I use a full stop or point the formula comes up with a #value error sign. eg. =4,5*5=22.5 but =4.5*5=#value Is there a setting I need to change?

    littlebiscuit25 pointsBadges:
  • Export to Excel

    Why does Crystal add blank rows and columns when I export to Excel?  How can I export without blank rows and columns?

    RicksterS5 pointsBadges:
  • Transaction web page using MS Excel

    How to develop transaction web page using MS Excel as database?

    ramki19805 pointsBadges:
  • Change a field in a file

    I created a file using qry400, to hold the position of a field I used spaces '    ', now when I try to download to an Excel spreadsheet the info in that field comes out looking like HEX instead of what is in the field. Is there anyway to correct this? *** note - I must fix the file, I can not...

    hydr15 pointsBadges:
  • Microsoft Word or Excel

    Why when I double click the created small Word or Eccel files, the program won't open the document anymore?  The program only opens the first page of the program as we click the Word or Excel icons.  I now always need to go to Word or Excel main program or icon to select the created document...

    paul180815 pointsBadges:
  • Filename error in VBA

    I created a macro to run with my daily reports in Excel. The only issue is the names of the report change every day respectively as Mat1 mm-dd-yy. I have tried to maneuver with the code but it always leads to a dead end. How can I change the code to be able to run with any date? Mat1Macro Macro ' '...

    ambershantae5 pointsBadges:
  • Scrolling

    In working with MS Excel 2003, there are darker scroll lines vertically & horizontally on the worksheet. When I try to scroll the page down below the line, only those cells scroll, not the whole sheet. How do I fix this?

    nccoolmom10 pointsBadges:
  • Opening Excel

    We use a shared workbook. As I understand how Excel is supposed to open, it should be at the same place where I last saved it. Instead, it opens at that location and then jumps to a weird place on another sheet. I cannot figure out why or how to make it go back to opening normally.

    tlsanders11,340 pointsBadges:
  • CVTPFXLS command options

    Hi people, I need some help with formatting Excel spreadsheets within the IFS. My program currently prepares a physical file on the iSeries and uses the CVTPFXLS command to create a Excel sheet. However, this sheet is pretty bland and I wish to add some formatting before the user gets it. The...

    tjgm88995 pointsBadges:
  • Creating a chart for alphabetic data and date ranges

    I am trying to put together a chart that reflects application deadlines for roughly two dozen clients for the company I work for. Some of these clients have two or three different deadlines to reflect the multiple testing windows these clients have throughout the year. Essentially, I am trying to...

    dharvey111315 pointsBadges:
  • How do I remove rows from an Excel page

    I have an Excel spread sheet with a lot of data. However, between the rows with the data there are many rows that are empty. I want to remove the rows to make the data more compact looking. How do I remove them? There are too many pages for me to take the time to delete them one by one. Can anyone...

    Barrymore10 pointsBadges:
  • Which drive is Microsoft Excel located in?

    Microsoft Excel should be located on the computer C drive (the computer hard drive). The computer comes with Microsoft Windows 7 64 bit and Microsoft Office Starter 2010(preloaded). Why can't the accounting product I am trying to set up locate any Excel templates?

    Learning050 pointsBadges:
  • Chart drilldown for multiple Axis field pivotchart

    The solution that Hatmaker shared in this forum to drill down on a pivot chart created from a pivot table works fantastically. I was so happy to find it and got it working for my pivot chart which has one Axis field and one Legend field. However when I added another Axis field to that chart, the...

    RunningDog15 pointsBadges:
  • Microsoft Office Starter Excel

    The Accounting software I want to set up is Excel based enabling the production of Statutory Accounts. It is called VT Accounts. It runs on Excel 32 bit for Windows desktop. So far I have not been able to set it up. Is it because I am running Microsoft Office Starter2010? Do I need a full version...

    Learning050 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following