• Simple routine with If now does not work – help please!

    In Excel sheet I had macro for hiding and showing all rows that had a red cell in Column A.  It was working well but now hangs. Any clues as to why this is happening and how to get round it? This below is the Show routine which unhides any row with a red cell in Column A as well as showing Column...

    Madcap5525 pointsBadges:
  • VBA copying a range from Excel and pasting to a text file

    Do you know how to copy from excel and paste to a text file using VBA?

    TBone555 pointsBadges:
  • Microsoft Excel for Mac is not showing me cell content

    So I'm using Microsoft Excel on a Mac (version 16.15). When I'm looking at a specific cell, the formula bar is showing me the cell address (but not the cell content or formulas). I turned the bar on/off with no luck. Why is it not showing me the content?

    ITKE1,083,525 pointsBadges:
  • Lock Microsoft Excel rows and columns

    Hi everyone! In Microsoft Excel, how can I lock the rows / columns? I don't want any other employee changing anything (it's a shared worksheet network). Thanks so much.

    ITKE1,083,525 pointsBadges:
  • Microsoft Excel will not recover the contents of the workbook

    A friend of mine sent me a Microsoft Excel spreadsheet that I need to work on. But when I tried to open it, I got this message: "Excel found unreadable content. Do you want to recover the contents of the workbook? If you trust the source of the workbook, click yes. I clicked yes but everything was...

    ITKE1,083,525 pointsBadges:
  • Disable Microsoft Excel configuration popup

    So I'm still currently on Microsoft Office 2007 and particularly use Microsoft Excel a ton. But now every single time I open it up, the configuration setup pops up. It always completes and runs fine. But it's popping up every single time I open Excel. Is there any way to stop this?

    ITKE1,083,525 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,083,525 pointsBadges:
  • Microsoft Excel: Move and size cells option is not available

    Inside of the Microsoft Excel Developer Tab, I just added a form control checkbox. But, under properties, the option to "move and size with cells" is completely grayed out. I'm not sure how to activate it. Any suggestions? What can I do?

    ITKE1,083,525 pointsBadges:
  • Sending auto email for shared Microsoft Excel workbook

    Hello, We have a Microsoft Excel shared workbook for our department. There's one specific column that relates to a data validation list. When I select 'yes' on it, I would like it to send an email to everyone in the department so they can take a look. Would I have to setup a macro? Thanks so much.

    ITKE1,083,525 pointsBadges:
  • Download details of VK13 in Microsoft Excel

    Can I download/export details of vk13 (condition type- Slab Price with historical data) in Excel. Is there any T-code or table?

    Marmik5 pointsBadges:
  • Editing Microsoft Excel file using Linux shell

    Hi IT experts, Does anyone know of a tool (or even a process) to edit an Excel file (XLSX) using Linux shell? Basically I'm working on a worksheet and I need to remove the last three non empty rows. Any help is appreciated.

    ITKE1,083,525 pointsBadges:
  • Setup paste and match destination formatting on Excel 2016 for Mac

    Hello, I have Microsoft Excel 2016 on a Mac. Is there a keyboard shortcut to use paste and match destination formatting? If there isn't one, could I possibly set one up? Thanks again.

    ITKE1,083,525 pointsBadges:
  • Multiple chart options are hidden in Microsoft Excel 2016

    It seems that I'm missing multiple "chart" options inside of Microsoft Excel 2016. I need to add a statistics chart but it's not included in the options. Am I missing something here? Specifically I would like to add a Histogram. I'm not sure why it's hidden. Can someone help?

    ITKE1,083,525 pointsBadges:
  • Disable Microsoft Excel read-only mode

    I'm able to open an Excel file (and it's not in read-only mode). But when I work on it and try to save it, I'm getting the read-only message. It's happening every single time that I'm sent a file. How can I stop this from happening?

    ITKE1,083,525 pointsBadges:
  • How to split Microsoft Excel cell into two

    Does anyone know if it would be possible for me to split a Microsoft Excel cell into two smaller parts. I don't want to insert a new row or column. Just one specific cell (for example: A2). Any help would be great.

    ITKE1,083,525 pointsBadges:
  • How to pull data into pie chart from Microsoft Excel 2010 spreadsheet

    So I'm in the process of creating a pie chart in a Microsoft Excel 2010 spreadsheet. The data is getting pulled from drop down boxes. But it's not getting pulled into the graph. What am I doing wrong?

    ITKE1,083,525 pointsBadges:
  • Recover password for Excel VBA macro

    About a month ago, I set a password for an Excel VBA macro but now I forgot it. I can't download the Hex Editor. What should I do? How can I get my password?

    ITKE1,083,525 pointsBadges:
  • Conversion of .xlsx files into WordPad

    I deleted Excel from my PC. What are suggested programs that can convert a .xlsx file into a WordPad doc?

    sunkawinyan5 pointsBadges:
  • Fit all Microsoft Excel columns on one page without shrinking data

    I'm trying to print a Microsoft Excel worksheet and I was able to to fit all of the columns on one single page using the Scaling option. But when I'm printing, the cells are shrunk (making them unreadable). How can I print the sheet without shrinking the data? Thanks!

    ITKE1,083,525 pointsBadges:
  • How to open an Excel file

    My Excel file got corrupted and now has now a file extension .xlsx.wzzzpin. How can I open this file?

    Job40Auruku5 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.