• Microsoft Excel: Cannot choose rows to repeat at the top

    I have a Brother printer setup on my network and I'm working with Microsoft Excel right now too. When I'm about to print a worksheet, the 'rows to repeat at the top' isn't highlighted and I cannot choose it. What should I do?

    ITKE1,067,645 pointsBadges:
  • Microsoft Excel 2016 keep freezing after cell is modified

    I'm running both Microsoft Office 2016 and Windows 10. In my department, we have a shared Microsoft Excel document that I access a ton. But whenever I try to modify a cell, Excel keeps freezing on me. This will happen for roughly two minutes and then everything is fine. Why does this keep happening?

    ITKE1,067,645 pointsBadges:
  • Turn off autorecover on Microsoft Excel workbook

    My team has one large Microsoft Excel workbook and several other smaller workbooks. There really is a large amount of data on the one workbook so that's currently read-only (but I do need to edit it at times for filtering and other things). Here's what I want to do: I want to turn autorecover off...

    ITKE1,067,645 pointsBadges:
  • How to export Access file to Excel automatically

    Our department has a Microsoft Access database file that updates all of the time. We need to export all of this data to Microsoft Excel automatically. So whenever we need the newest updates, it happens automatically (not manual process). How can we do that? Would a Power Query work?

    ITKE1,067,645 pointsBadges:
  • Add up points in Microsoft Excel

    Say in examination you have A=1,B=2,C=3,D=4,F=0. Now I need a column where I can put total points. How should I go about it?

    mnyita5 pointsBadges:
  • Cannot resize Microsoft Excel column width

    I'm trying to resize my Microsoft Excel column width with my mouse but it's not working. It was working just a couple of days ago. Did I lock some setting on Excel? I don't have any hidden columns either. What should I do here?

    ITKE1,067,645 pointsBadges:
  • Delete non-English/alphanumeric characters in Excel workbook

    How can I delete non-English/characters, special characters, unnecessary spaces? I have a Microsoft Excel Workbook where I've 240 Thousand different type of  descriptions that are alphanumeric and Chinese characters. Examples: ???? ??? ?? ?????<?? ??(?? ? ?? ? ?/ ???????? ???? I need to be...

    EmyHazel5 pointsBadges:
  • How to set Microsoft Excel workbook name through PowerShell

    Hello, Would there happen to be a way I could set a Microsoft Excel workbook name using PowerShell? I'm not sure the best way to do this. I already have a script that opens a CSV file from Windows Explorer.

    ITKE1,067,645 pointsBadges:
  • Font flashes and disappears in Microsoft Word and Excel

    My department is running into an odd Microsoft Office issue. Whenever we start Word or Excel and select a font, it flashes for a second and then goes away. We've checked updates and everything and it all looks good. What can we do?

    ITKE1,067,645 pointsBadges:
  • Excel files have the original format but the data is not visible

    Somehow, I have done something and all of my Excel files have the original format but the data is not visible. What can I do to retrieve the data?

    rosiedh5 pointsBadges:
  • Oracle Reports 6i – Convert data in Microsoft Excel

    How do I convert Oracle Reports 6i data into a Microsoft Excel through coding on button?

    Sskhan35 pointsBadges:
  • Microsoft Excel: Count range of numbers with text in cell

    Microsoft Excel just did an update a few days ago on my laptop and I noticed a few features have changed. I'm currently trying to count the ranges with specific text within a cell. Here's the formula I usually use: =COUNTIF(range,"(asterisk)text(asterisk)") But that's not working anymore. I removed...

    ITKE1,067,645 pointsBadges:
  • Microsoft Excel GROUP BY

    How can I list the departments and the number of employees in each department?

    rajeshwari95 pointsBadges:
  • Find high value than look up value in Microsoft Excel column

    The VLOOKUP function in Microsoft Excel is great at finding exact matches or the value just less than the lookup value. I need the next higher value than the look up value from a list of  values in single column.

    Bikashgoon5 pointsBadges:
  • Importing CSV file into Microsoft Excel 2016

    This may seem simple but I feel like every version of Excel is getting worse with CSV files. I'm running Excel 2016 and I can't open a CSV file. I can't import the data at all. Can someone help please?

    ITKE1,067,645 pointsBadges:
  • Program that exported data to Microsoft Excel

    A co-worker from another department send me an Excel spreadsheet that has is exported data from another program. I need to find out which program it is. Can anyone help?

    ITKE1,067,645 pointsBadges:
  • Go to Excel worksheet by clicking on cell

    I have two worksheets - namely ABC and XYZ. In worksheet ABC, I have written XYZ in one cell. So now how to I go to the worksheet XYZ by just clicking on the cell containing XYZ in worksheet ABC?

    fkpwala15 pointsBadges:
  • Zero keeps disappearing in my Excel spreadsheet column

    So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example: 012345678 changes to 12345678 What do I have to do keep the zero as entered and not disappear.

    ITKE1,067,645 pointsBadges:
  • Lock specific columns in Microsoft Excel

    In my Microsoft Excel spreadsheet, I have three columns that I want locked (so no one can change anything). But when I clicked on format -> Lock Cells, it's protecting all of the columns. I just want these three locked. How can I do this?

    ITKE1,067,645 pointsBadges:
  • Add colors to Microsoft Excel template

    Hello, I'm using Microsoft Excel and I have multiple charts that I want in the same colors. I have a list of 20 or so colors so I'm looking for a template that I can implement these colors in (so I don't have to do it manually every single time). How can I do this?

    ITKE1,067,645 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.

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

Following