• Add SQL Server Agent jobs to Microsoft Excel spreadsheet

    I have a list of SQL Server Agent jobs and I need to add them to my Excel spreadsheet. The problem is that I don't want to do this manually. Is there a T-SQL command that would create this list for me?

    ITKE372,080 pointsBadges:
  • First 0 of zip code drops in an Excel spreadsheet merge

    I use an Excel spreadsheet to mail merge mailing labels. Whenever I merge, the first 0 in any zip code gets drop in the final label. How do I prevent the zip code field from dropping that first 0?

    mdoyle44465 pointsBadges:
  • Microsoft Excel: Turn column into comma-separated list

    In my Excel spreadsheet, I have to take a number of rows and turn them into a comma-separated list in another cell so my boss can copy and paste the numbers into a different program. What's the best way to do that? Thanks!

    ITKE372,080 pointsBadges:
  • Join two worksheets in Microsoft Excel

    I have different Microsoft Excel worksheets in two different files. It includes names, IDs and other data. One worksheet is a master list that includes all information and the second sheet only includes names, IDs and an address. I need to use the second sheet to filter the first. Also, I need to...

    ITKE372,080 pointsBadges:
  • Limit to number of rows and columns in an Excel spreadsheet

    What's is the limits to the number of rows and columns that an Excel spreadsheet can have?

    Famous5 pointsBadges:
  • Create macro on a shared system that will work on different computer

    How do you create a macro on a shared system that will work on different computers? We have a workbook on our shared drive. It is an Excel 2007 with several tabs with 2 pages each. I need to create a macro that will tell the entire workbook to print double sided when opened on other PCs.

    MotorSafety5 pointsBadges:
  • Microsoft Word and Excel documents don’t open in Windows 10

    I recently updated from Windows 7 to Windows 10; and Word and Excel 2010 to 2013. I have Word and Excel in the Task Bar (as before) and was able to Right Click and (Pinned or not) open any previous document there. Now (in Windows 10 and Office 2013) they show there but they do not...

    Florenjm150 pointsBadges:
  • I can’t open two Excel files at the same time

    I can't open two Excel files at the same time. If one file is opened and try to open another file, the first will close without saving. Please help me. I can make view and arrange file vertical or horizontal to open two file but otherwise I can't. It is xlsx only.

    praise5 pointsBadges:
  • Drag-and-drop function in Microsoft Excel

    In Microsoft Excel, I have to do some manual reordering of rows and copying / pasting will take too long. Is there something like drag-and-drop that I can use? Thanks!

    ITKE372,080 pointsBadges:
  • Change .ods files to read as an Excel file

    How do I change an .ODS file so that I can read it as an Excel file?

    jan1ancaster30 pointsBadges:
  • Group by values in Microsoft Excel

    In Excel, I can't figure out how to 'group by' values. My friend told me to use pivot tables but I'm not sure how to do that. I would also like it on another worksheet too. Thanks for the help.

    ITKE372,080 pointsBadges:
  • Excel “Document not saved” message

    I cannot save my excel spreadsheet because this message comes up every time. I have tried a different name for the workbook several times but I always get the message. I have tried Excel Help but the search for this error message produced nothing. Any suggestions please? Thanks

    JoellaWheeler5 pointsBadges:
  • Mail merge from Excel to print labels

    I have gone through the step by step instructions of a mail merge from excel to print labels. When I print, only one page of labels shows up and prints. The rest of the names that are checkmarked to be included does not come up in view document or prints. Only one page. What am I doing wrong?

    karenryen5 pointsBadges:
  • Microsoft Excel: Get distinct values from a column

    In Excel, I have a column with different values and I need to find out what distinct values are in there. Is there a way to do that? Here's what I came up with in SQL Server: SELECT Distinct(MyColumn) FROM MyTable. Is there something like that?

    ITKE372,080 pointsBadges:
  • Saving Excel spreadsheet to multiple locations

    Is there a way to save my excel spreadsheet to both my computer file and the evernote file without the extra save as step?

    jerrydavisvybranz5 pointsBadges:
  • How to fix this error in SQL and Excel?

    When I execute the T-SQL, I want to copy result and paste Excel sheet but the numbers had problem. For example in SQL, 4.2900 but when I copied Excel 42.900. Can you help this problem please?

    edwinjhoffer3,045 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:
  • Passwords on exported Excel spreadsheets

    Can CR export to Excel and put a password on the exported file?

    bferrell5 pointsBadges:
  • How to create an Excel file from C#

    Is there a way I can create a Microsoft Excel spreadsheet with C# without having Excel be installed on the machine that's actually running the code

    ITKE372,080 pointsBadges:
  • Advanced Page Numbering in Word and Excel

    I want consecutive Word pages to have even numbers (2, 4, 6, etc). Same problem with Excel.

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