• How to autofill Microsoft Excel column with series

    In Microsoft Excel, I can't autofill a specific column with a series. For example, this is out I want it set: Jan17 Feb17 Mar17 I'm doing a right click and drag but that's not working. Any idea on what I should do?

    ITKE1,011,420 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:
  • Find max of visible Microsoft Excel rows

    Sorry if this question is confusing. I'm in Microsoft Excel 2010. I have several rows of data. I would like to find the max for each specific row. But here's the catch: My formula should only take the max from visible data (not hidden). How can I do that?

    ITKE1,011,420 pointsBadges:
  • How to convert a .SHS file to Excel?

    How can I convert a .SHS file into a Microsoft Excel file as with .SHS. My computer is not able to decode it? Please tell fast its an emergency, I have to work.

    daaku35 pointsBadges:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 pointsBadges:
  • How to convert Numbers file to Microsoft Excel file

    Not sure if this is possible but I thought I would give it a shot. I have both a Windows and Mac PC. I have a spreadsheet on my Mac that's a Numbers file. Would I be able to convert to an Excel file for editing on my Windows PC?

    ITKE1,011,420 pointsBadges:
  • Autofill PDF form using Excel data

    I am a Visual Basic newbie and I need some help with the following code. Basically, what I am trying to do, is to autofill a PDF form using data in an excel worksheet. I did some testing and the program seems to be reading the required data from the excel cells but not writing it in the PDF form....

    shawnturner10 pointsBadges:
  • Set Microsoft Excel 2016 document as read-only and password protected

    I used to run Microsoft Excel 2010 and what was great about it was that I could set my documents as read-only and if one of my co-workers wanted to make any chances, they would need to put a password in. But now our company upgraded to Excel 2016 and I can't find that setting at all. Does anyone...

    ITKE1,011,420 pointsBadges:
  • Adding tax data in Microsoft Excel

    I am trying to move tax data from one Excel sheet to another, organized by zip code. In one sheet, which has the tax data I need, the data is organized by AGI. This means there are 6 data cells for each zip code. However, In the Excel sheet I am moving this data to, there is only one line for each...

    caseyp75 pointsBadges:
  • Text file format is taking up more space than Excel file format

    In my Microsoft Excel spreadsheet, my data is in roughly 10,000 rows. But when I stored the data as a text file, it's taking way too much space. Why is it different as a text file than an Excel file format?

    ITKE1,011,420 pointsBadges:
  • Microsoft Excel: Round two decimal places

    Sorry if this is a basic question. I'm a Microsoft Excel newbie. How can I add two more decimal places without rounding it off? Basically, if I have $50, I want it to show $50.08. Thank you.

    ITKE1,011,420 pointsBadges:
  • Needs to pass data from Excel to host on demand

    I need to pass data from Excel to Host on demand 3270 mainframe and vice versa using VBA.

    Kavithagowda5 pointsBadges:
  • Create random sample of Microsoft Excel data

    I'm looking to do some random sampling on my Microsoft Excel spreadsheet. Basically, it has over a thousands rows on it and I want to sample around 100 of them randomly. Would this be possible? If so, what's the process?

    ITKE1,011,420 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,011,420 pointsBadges:
  • Importing Excel to Access auto populating data

    I have imported an Excel spreadsheet into Access (2016) and am trying to figure out how to populate data. For example, I imported a spreadsheet containing employee name, ID, Department, Supervisor. If I select the employee name, I want my form to automatically populate with the rest of the data....

    motogirl15 pointsBadges:
  • Update changes to Microsoft Excel file in Dropbox

    Hello, At work, I have a Microsoft Excel that I'm always updating. Would I be able to upload / update it in my Dropbox account every few hours so I don't lose any data?

    ITKE1,011,420 pointsBadges:
  • Cannot delete Microsoft Excel macro

    I have Microsoft Excel 2013 installed on my MacBook Air. I'm trying to delete a macro but I keep getting an error message: Cannot edit macro on a hidden workbook. Unhide the workbook using the unhide command. My worksheet is already unhidden so I'm not sure what to do here. Can someone help?

    ITKE1,011,420 pointsBadges:
  • How to import Microsoft Excel data into existing SQL Server table

    We have a SQL Server table that currently has data in it. Can we import more Microsoft Excel data into this existing table? We already tried using the export wizard but we got a ton of errors.

    ITKE1,011,420 pointsBadges:
  • Selecting largest number in Microsoft Excel

    Hi, in my Excel sheet, I have 1 Part procured 10 times with different prices. I have to select largest price and also I want to get the latest date when I procured. Please help me out.

    tanmay0485 pointsBadges:
  • How to estimate work hours for a typical data profiling and cleansing effort? Any Estimate calculators in Excel can be shared?

    One of my known acquaintance asked a question to help him with an estimator to logically estimate person hours required for data profiling and cleansing. His company is assuming their data quality will be bad. Now that there is a necessity to check and cleanse data, how to arrive at the man hours...

    swamis5 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