• How to delete part of a Microsoft Excel cell

    Okay, so I have an interesting question. I was sent a Microsoft Excel spreadsheet and I need to delete parts of different cells. Meaning everything after this symbol '*' needs to be deleted (including the symbol). For example: JohnSmith*22101 This is how it should look after: JohnSmith It's too...

    ITKE1,055,480 pointsBadges:
  • Export batch files into Microsoft Excel spreadsheet

    I have roughly 20 or so batch files that I need to transfer to Microsoft Excel. MeaningĀ  - I want to transfer all of the contents of the files into Excel (which would make a list). What's the best way to do that? Thank you!

    ITKE1,055,480 pointsBadges:
  • Setup double-sided printing on Excel 2010 document

    Whenever I'm printing an Excel 2010 document (I used Ctrl + P), it's only printing on one side. I need to print on double sides. How can I set that up? This needs to be the default too.

    ITKE1,055,480 pointsBadges:
  • Stop recovery on autosaved files on Excel for Mac

    Whenever I open up Excel for Mac, I keep getting this message: Excel saved changes to the file before the application quit unexpectedly. And it forces me to go to the last saved version (even though my last session ended fine without any problems). So I've come to the conclusion that Excel thinks...

    ITKE1,055,480 pointsBadges:
  • Microsoft Excel keeps crashing when opening file

    A few hours ago, I saved a XLSM file (Microsoft Excel). When I just tried to open it, it's not working. I sent it to my co-worker and he was able to open it just fine. He sent it back to me and it's still crashing. We're still on Windows 7. Any reason why this would happen?

    ITKE1,055,480 pointsBadges:
  • Printing Microsoft Excel sheet in two different formats

    Hello, For my Microsoft Excel document, is there any way to print one sheet two different ways? Meaning print it on Landscape and also Portrait? I hope that makes sense. Thanks!

    ITKE1,055,480 pointsBadges:
  • Microsoft Excel won’t close without saving

    In Excel 2010, when I have a worksheet open and want to close it, often the sheet will not close unless I save changes. Sometimes it allows me to close without saving, and sometimes it does not.

    Contrain10 pointsBadges:
  • Command to set particular widths to Microsoft Excel columns

    I have assigned a command button that would assign a specific width to each column in a Microsoft Excel spreadsheet. But I sent it to a friend and when we tried to use the command button, the widths were all different. It's the same characters fonts too. What's wrong here?

    ITKE1,055,480 pointsBadges:
  • How to insert bullet point list into Microsoft Excel cell

    Hi, Does anyone if it's possible to add / insert a bullet point list in Microsoft Excel? I know how to add a line break inside a cell but I think a list would look much better for my presentation. Thank you.

    ITKE1,055,480 pointsBadges:
  • Word count in Microsoft Excel

    So in Microsoft Word, I'm easily able to count the words in a document. How can I count words in a Microsoft Excel file? I don't see it anywhere. Is there an easy solution for this? Thanks for the help.

    ITKE1,055,480 pointsBadges:
  • How to add data without using user forms in Excel 2016 for Mac

    Hopefully I can explain my issue clearly. I'm using Excel 2016 for Mac and I found out that it doesn't support user forms. Here's what I need to do: Add new rows to my table using an input field so I can only add new entries through that field and can't modify the rest of the sheet. Is this...

    ITKE1,055,480 pointsBadges:
  • How to sync data between two Microsoft Excel worksheets

    In my department, I'm resonsible for keeping our Microsoft Excel worksheet up-to-date for tracking reasons. Now, a co-worker from another department wants me to fill in his Excel sheet with all of the same information. Would I be able to sync my data over to his sheet? I don't want to maintain two...

    ITKE1,055,480 pointsBadges:
  • Copy and paste Microsoft Excel tables into Gmail

    I'm sure this question has been asked before but here it goes: How can I copy and paste several tables from a Microsoft Excel spreadsheet into Gmail? I don't want to lose the original formatting and borders. Can someone help me out?

    ITKE1,055,480 pointsBadges:
  • Convert date in Microsoft Excel

    Hello, I need some date conversion help in Microsoft Excel. Here's what I currently have: dd.mm.yy I need to convert it to this: dd/mm/yyyy How can I do that?

    ITKE1,055,480 pointsBadges:
  • Remove People Graph from Microsoft Excel document

    A co-worker accidentally changed something in a very important Microsoft Excel document and this 'people graph' showed up on the entire spreadsheet. I'm able to select it but can't seem to remove it. Can someone help me?

    ITKE1,055,480 pointsBadges:
  • How to Migrate from Outlook Express to Windows Live Mail on new Computer

    I have been using Outlook Express on Windows XP operating system. Recently I have upgraded to Windows 10. In this operating system I am using Windows 10 Mail. Which is quite impressive. But Outlook Express contains some crucial email from clients. So, I want to access Outlook Express DBX Files in...

    WarriorBhagat320 pointsBadges:
  • Add options to Microsoft Excel drop down menu

    My department works with Office 365 and, with Microsoft Excel, we have several drop down menus that our entire staff can access and make changes too. And now - I need to add an extra option for our managers so there are things that they can only select. Is that possible? Is there a macro I can use?

    ITKE1,055,480 pointsBadges:
  • Microsoft Excel: How do you group a list of companies/account numbers that are duplicated on several rows

    How do you group a list of companies/account numbers that are duplicated on several rows (separate purchases) to identify companies that purchased specific products within 2 code ranges (c50-c509, c18-c20.) and include ALL of the that companies purchase rows regardless of the product code in that...

    Csimon125 pointsBadges:
  • How to use formulas in Microsoft Excel text box

    Are there any Microsoft Excel experts here? I have an idea but not sure if it's possible or not. I would like to setup a text box in my Excel spreadsheet that would display the output of a formula. I can add an example if that's needed.

    ITKE1,055,480 pointsBadges:
  • Remove character limit in Microsoft Excel column

    When I'm importing from CSV to Microsoft Excel, one of my columns has data with over 255 characters in it. But when I run the text to column command, it cuts off the data in the cells to 255 characters. How can I prevent this from happening?

    ITKE1,055,480 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