• 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:
  • 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:
  • Do you have a favorite construction estimating software tool?

    What is your favorite construction estimating software tool? Are you using Microsoft Excel? What about Sage? HeavyBid? HardDollar? Something else entirely? What makes the software so appealing to you -- was there one feature that made you shout, "I need that now!" or was it the whole package that...

    Beastwood1,105 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:
  • 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:
  • Download software

    How can I download a program which only runs on Microsoft Excel 32 bit when my current operating system is running on Windows Home Premium 7 64bit?

    Learning050 pointsBadges:
  • Filters

    How do you remove the filter arrows from an Excel table?

    ericanjung5 pointsBadges:
  • How to assign a numerical value to a word in Excel

    I want to be able to select a material from a drop down list in column A, then type in the time in Column B and in a third column have the cost appear. What I need is to associate eg. VHS as having a rate card of £30. I can make lists and I can write the simple equation in the cost column to...

    Dontgetit105 pointsBadges:
  • How to protect an Excel sheet from printing?

    How can I protect my Excel sheet from printing so that if anyone tries printing it, they're not able to get a printout?

    Jaideep Khanduja9,100 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