Excel

How can I open Office files (Word and Excel) that I copied from my desktop to my Lenovo PHAB model PB1-750M

Windows 10 updated a few days ago, and my files remained intact except the most important folder on my computer. It got deleted, and I could not find it in windows.old. After that I proceeded to use a recovery software, which successfully found the folder, and all of the files. However, they...

Question about excel function, which one to use and how. If I have four columns ( family_id; father_name; mother_name; child_id) in sheet1, and sheet2 I have two columns(child_name; child_id). For example: sheet1: family_id/father_name/mother_name/child_id 111 father1 mother1 01 222 father2...

problems with hyperlinks in excel spreadsheets

Hi guys, As the title says I am trying to figure out how to do a distribution curve for some data from my calculations. This here the finalised data: http://imgur.com/j3nQMtv And what I am wanting to do is a curve of dt (in micrometers and rounded) vs fm (wt%) distribution curve similar to...

When i open Excel file which generated from my java based web application in IOS devices some columns are blank. Can you please help me with this? Is there any existing issue with IOS devices with Excel files ?

I have been exporting a report to Excel and then copying it into an email. Today I used the same process, the first thing I noticed that was different was that I had to save the report which I do not need,then when I pasted it into the email, the font was larger and the grid lines appeared...

Microsoft provides an inbuilt security feature in MS Excel so as to prevent unauthorized access to Excel documents. With this remarkable feature, you can set passwords on Workbook which in turn protect your Excel file by asking for password every time MS Excel file is open. In this tutorial, I...

Hello guys, I have a workbook and I need to find the NO values on ROW G (Row 7) and then copy the line that NO belongs to a new sheet (TAB) called summary, in my case it is listed as sheet 18. I need to search on all sheets though from Sheet 1 to Sheet 17 in their G Rows for NO's. I have a...

Yesterday I could printed a variety of spreadsheets. Today, I can't. I have no idea why. I've tried: - uninstalling and reinstalling the printer - tried to save & resave the document - after driver reinstallation, copied to a new document - looked at the registry entry for the printer, but...

I am running a x64 Windows 7 Home laptop, and I am trying to install Office 2016 Pro on it. The installer freezes around 85% every time I try to install it. I have tried literally everything I can think of with nothing changing it... stopped printer spooler service, sfc scannow, AV scans...

Hie all, Basically i am creating a excel sheet where i would be required to have random numbers in a particular range and in multiples for 5 and all the numbers generated should have the total which is entered. Let me elaborate Input Number- 136400 Random Numbers Range- 12000 to 15000 (Range...

Ok i know there is a whole range of different to consider when saying what the best is but my needs are simple looking to play wow on something besides low on everything, will also be used for some word processing and excel. I have a 1 tb external hd so storage isn't a massive concern 3...

One of my users in our Sales department showed me an Excel file today that when saved is excessively large. All the rows (approx 30) and columns (approx 15) are all using simple formulas (add left to right, top to bottom, summarize at the end kind of stuff). There are 5 tabs in the spreadsheet...

Currently, each email address in the document is behind a hyperlink that's represented by a small white envelope icon (I've attached a picture). I need a contact information sheet that I can print; I need to keep the same text and formatting, and replace the icon with the email address in plain...

Hi all, I am looking to replace my old Dell Latitude E6430 (i5 3320M with 4 GB Ram) and i need your opinions. I usually have opened several programs like Outlook, Skype and Skype for Business, OneDrive, 4-5 Chrome tabs, one virutal machine, and several excel files that goes from simple ones...

I am drowning in school work tonight and have two simple projects due tomorrow, one for Access and one for Excel. This is an intro to computers class, so the projects are very easy. I will pay someone who can finish these two projects for me, for someone who has experience with these programs...

Hello, We have MS Surface Pro 3s for work, but we are finding that these machines are not very good at running large (500k rows of data) Excel calculations (v-lookups, sorting, pivots, etc). We are looking into getting a laptop to assist with the number crunching, do you have any suggestions...

Hello you wonderful people, I am a bit stuck on an excel formula if someone could help me out it would be much appreciated. I need a way to calculate the min and max for each product, as I do with the average formula (=AVERAGEIFS(E:E,B:B,B3,C:C,C3,D:D,D3) (=AVERAGEIFS("Value...

For simplicity's sake, I will be using basic titles and information for an excel workbook, i.e. Sheet1, Sheet2. Background information for the sheets: Columns A will contain parts numbers on both sheets. Sheet2 contains all parts numbers possible for the given assembly. Sheet1 displays the part...