Home / Tag Archives: excel

Tag Archives: excel

Excel 2016 and Windows 10 issue

Prior from having Win10, I was using Win7 with Excel 2016. I was capable of selecting a certain amount of Excel files at once, right click “open” and they would all open within the same Excel session, with observe of them all. Since Win10, per example, if I select 2 Excel …

Read More »

need to repair excel

I need to repair excel  but when i ask go to control panel and try to change the programme is says i am not connected to the internet but i am. Any ideas

Read More »

Complex IF, AND, SUM, FORMULA – MS Excel 2010

I inherited a worksheet Ex 2010 that will not handiwork.  It has (amongst other data) 3 columns of data headed Trivial, Medium, Large, in which each cell will only contain “1”, if other criteria is met (linked Radio Button).  My problem is that the results we want are as follows. Each …

Read More »

Excel online

I have an Excel Online spreadsheet, and have set up a link for people to open the spreadsheet. On the Spreadsheet, I have instructions on how to use the spreadsheet on line 1 to line 10. Initially, when people open the spreadsheet, line 1 to line 10 are at the …

Read More »

Microsoft Office Excel Display Problems

I upgraded to Windows 10 and now when I open my excel charts (and I have hundreds of them for my business) the charts are not aligned.  The middle of each chart is off to the left side.  Has anyone had this problem and if so were you able to …

Read More »

EXCEL 97 SPREADSHEET CONVERTER

WHAT LANGUAGE WILL MAKE EXCEL 97 READABLE AFTER IT HAS BEEN CONVERTED TO WINDOWS 3.  NOTHING LISTED HELPS.  I HAVE NOW LOST YEARS OF CHARTS AND CAN’T BEGIN TO REPLACE ALL OF THEM.  THE MOST IMPORTANT EXCEL SPREADSHEET WAS FILED IN "SHS" FORM.  WHAT DO I DO?

Read More »

excel

Hi I am using Excel 2010. I am trying to add a formula to count the number of times a cell is changed. For example, I have a date in C2, I want to footprint the number of times that this date changes in E2. I can put the below …

Read More »

Error bars in excel online

I’ve been using the online kind of excel and I’m trying to add error bars to a graph. From everything I’ve seen, a plus put your moniker on for chart options or properties should appear when I click on the graph. That doesn’t happen for me. I’m not sure if …

Read More »

Excel Keyboard Shortcuts

Hi, I’m wondering if there is a shortcut for activating the cursor in an Excel cell (Win. 7 Home Premium). If I have to correct a typographical error, I click the mouse in the cell, or should I try to correct the mistake in the Formula Bar, in which case, …

Read More »

Excel 2016 charts

When I select insert then any charts . I get a blank chart. The charts in the list are all black and ashen. when I choose one I get a blank screen .   

Read More »

Excel Online

How do I prevent the document to changing to US English, it’s driving me absolutely crazy as it changes all the formatting!

Read More »

Excel 2010

I have an excel worksheet that will not let me "merge and center".   It is not grayed out.  When I select two or more cells and click on "merge and center" – all the other cells direct black and some of the rows height changes.  It will not merge.  Any …

Read More »

excel macros clog effective in windows 7

over the last few weeks my macros in excel closed operational in windows 7 – i’ve solved this by ticking the "Trust access to vba project object model – but is it safe to leave this box ticked – the "Disable macros without any notification" is ticked?

Read More »

After being forced to fill in 1607, the charts and the book overlapped in Excel.

I have the same problem with William_Liu.  (https://answers.microsoft.com/zh-hant/msoffice/forum/msoffice_excel-mso_win10/%E8%A2%AB%E5%BC%B7%E8%BF%AB%E6%9B%B4%E6%96%B01607/6593688a-f97e-4645-aeef-a2d7c1986359?tab=question&status=AllReplies#tabs) The following article is quoted from William_Liu: After being forced to fill in 1607, the charts and the wording overlapped in Excel. Many colleagues’s computer from the 1511 was forced to fill in to 1607, Excel 2010 in use often appear on …

Read More »

Windows 10 1607 inform Excel activex controls problem

I opus with Excel 2016 and with activex controls on the sheet, these are resized and enlarged, then change the volume, but on other computers with Windows 8 or Windows 10 not 1607 look smaller. After reinstalling Office several times, including Office 2013, install the previous version of Windows 10 …

Read More »

JET Problems with excel and phrase

Hello Community! I have an issue with JET for excel. I know this is or was an issue as 2014 but i don’t know if it has gotten fixed or not since the information was from 2009. But as in the information i found i still get that same error. …

Read More »

Excel formatting differently on different copmuters

I have a guide excel document, perfectly formatted. However when my colleague opens it, two lines slant diagonally (they should be horizontal) and the row height is different so the pages coverage over more pages than normal, messing up the display. We’re using the same side of formulate and have …

Read More »

Saving excel file into mutual folders on ios

We can’t get it function. Trying to save a new file in a folder that was pool to me. But I am just getting an error that the file couldn’t download?! (But I won’t to upload the file). When I save the new file to my own folder everything moving …

Read More »

Files that I create in Excel are disappearing

I was told by the Party to post this question in Windows because it might be an inform question.  It might also be parallel to this problem: http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10/disappearing-excel-file/fbc98f19-35b8-4cf3-ba99-73e51ee50ef0 I created files in Excel in the past and saved them in Colleges-Education folder.  This week I went to look for the …

Read More »

How do I copy most visted file shortcuts to Excel ?

I would like to be able to copy two fields of data within the automatic destination files located at: %AppData%\Microsoft\Windows\Recent\AutomaticDestinations for the top eighty most visited file shortcuts (not most recent) to Excel:  (1) the Counter Value (which is located in the DestList entry positions 96-99), and (2) the file path …

Read More »

Excel keeps failing

After promotion to windows 10, excel keeps failing when function on excel (bring to an end function and pack up excel). I have lost so much composition!!! Bugs???

Read More »

Convert Contacts from Vcard to Excel.

Hi, 1. I have transferred contacts from mobile to sd card and all the contacts in particular vcf file. Now if i am importing that file in outlook in pc only one contact is coming.  2. I tried to convert it into Excel file but not able to do that.  …

Read More »

Link to excel consider does not perform

I developed a link to an online inspection, it is on Onedrive. The link does no longer labour and particpants can not fill in the inspection. The code that appear is:  9ed2a79d-f0bc-3000-a1e2-24a264732936 How can I resolve this problem??

Read More »

Using excel to find and code narration data

Hi Guys, I am hoping to find a way to use excel to find and automatically find and populate data into another excel if it matches. For example we have transactions come in one tab with a narration DFA AUSTRALIA. I know this can also come through as Dimensional on …

Read More »

Using excel to find and code narration data

Hi Guys, I am hoping to find a way to use excel to find and automatically find and populate data into another excel if it matches. For example we have transactions come in one tab with a narration DFA AUSTRALIA. I know this can also come through as Dimensional on …

Read More »