My zero always disappears in Excel spreadsheet column. Please help.
How do I copy and rename the same Word file from a list containing the names in an Excel database using VB6 Code?
What's is the limits to the number of rows and columns that an Excel spreadsheet can have?
I'm using SSMS 2014 and I'm able to link an Excel file as a linked server. But here's my question: Now I want to link multiple Excel files. Can I link all of the files on a linked server or do I have to do them separately? Meaning one linked server for one Excel file.
I have Office 365 on my desktop. I just received an email in Outlook from a co-worker with an Excel file attached. But I can't preview the file at all. Here's the message I'm getting: This file cannot be previewed because there is no previewer installed for it. I tried just to open it with no luck....
I can't currently export from SAP to Excel. Can someone help?
This is probably an easy question to answer but here I go. I'm a teacher and my students enter data into an Excel spreadsheet. But every single time, the value they put in changes. For example: 2.14 changes to 2 How can I format it in a way that it keeps the numbers behind the decimal point?
So I'm trying to work on an Excel spreadsheet and I've run into an odd issue. These so called Excel 'tooltips' are popping up all across my screen. And popping up over each other. Is there anyway to stop this? I can't get any work done at all.
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...
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...
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!
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.
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...
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?
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!
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.
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?
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.
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.
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...