### excel tag

Topic | Replies | Last post |
---|---|---|

Learning Excel Does anyone of a good class to teach Excel, I know the basics, but need to learn the harder stuff, especially for business applications. was hoping for some classes that are on the weekend or weeknights. in Auckland |
2 | |

MS Excel help i would like a formula to count the number of "Y" in a range of cells. ie A1, A2, A3 all have a Y and the answer is 3 |
4 | |

Generating a rolling invoice number in Excel? Evening all, is someone able to please give me instructions or direct me to instructions (easy ones! ) that tells me how to construct a formula in Excel (2003) to generate a rolling number for invoicing. Many thanks |
2 | |

Excel date calculations Is there a formula for calculating the number of days/weeks between dates entered into Excel? Lets say start date in cell A7 and end date in cell B7? Thanks |
7 | |

Excel and Math gurus formula help I am hoping to create an excel formula (well not me as it way beyond my capabilities but hoping someone can do it for me :) ) to be able to work out the distance between two shaft's with different sized pulleys (which could change) on each shaft along wit... |
14 | |

Excel IF statement ok ive found a different way to fix my issue but im keen to know why this one wont work, any excel whizz`s here? or anyone know the best site for me to go to. to ask, cheers =IF($C$2>=$D$4,"Range(-$C$2).Font.ColorIndex = 3","Range($C$2).Font-.ColorIndex =... |
6 | |

Excel formatting cell with formula and text Hi all I'm sure there's a simple solution. Cell c1 has 400 in it. Cell b2 has 13 in it cell c2. =($c$1/b2)-10&" msw" The problem is when I add the &"msw" it treats it as a text cell so takes away my formatting which as a result gives me the decimals I don... |
8 | |

Excel 2010 Problem You will guess from this post I am a computer novice so I hope this will be easy for you experts to solve for me. I am using excel 2010 I have cut and pasted a couple of rows of information from one spread set to another and now inadvertantly have done so... |
4 | |

Excel 2003 populate cell on certain date Sigh, Dr Google isn't helping. Have a spreadsheet with date at the top of the page which auto calculate, {=today()-1}. Each day I need to automatically grab data from say cell F5 and place it onto a cell worksheet #2 page. So if date for example is 1-4-20... |
16 | |

PDF to Excel converter Can someone suggest a (preferably free) down load to convert / export data from PDF files to an Excel accessible format (xls, csv, etc). Looked at Tucows doesn't seem to be Win 8.1 version on there. Have tried one of their offerings on an old XP machine b... |
5 | |

Excel 2013 Question - x axis change in time line Hi all, I've tried to google the answer but I'm not using the right words. I have a line chart that shows past dates from 2010 until now, and continues in to the future to 2020. The info in the past is relevant, but takes up too much space to the left of ... |
2 | |

Treasurers cash flow template? Excel I have googled but have not found what I am looking for. I need to replace the manual book keeping system used by a small non-profit organisation. Income in income out Bank reconciliation Can anyone suggest a site to find a template? Thank you |
8 | |

Excel 2010 freezing I have put up with problem ever since I installed Excel 2010. I have downloaded Microsoft updates, without success. I use macros from time to time and question whether there is something still hidden that is causing this problem. What is the correct metho... |
3 | |

MS Excel, Macros, Printing, hitting pf key, repeat I want to write a macro to do the following Print F9 repeat Don't know how? |
3 | |

Excel help - sorting using a macro? My Excel 'skills' have hit a block wall - It sounds like an easy thing to do but its well beyond me! All i want to do is 'sort' 3x cells i.e. column A has 3 numbers below it ( in 3 cells) but i need them sorting high to low, the numbers may be 3.14, 3.45,... |
13 | |

Help with Excel VBA Userforms Hello all Im having a small issue with a vba userform im making on Excel. I have a userform which adds data to a worksheet. There are 2 text boxes, which input data into Collum A and Collum B When it reaches row number 20, I would like the next entry to s... |
1 | |

Text to speech MS excel Well what do you know. I'm indexing in excel and was wondering how to check it. After a bit of fiddling around (windows installer was hiccuping), I got text to speech working for excel and now the program can read back to me as I follow the original. I'm ... |
1 | |

Are there any excel experts lurking? At work we have an excel spreadsheet that the entire business needs to access. Obviously we can't all edit it at the same time, so when someone else is using it, it goes into 'read only' mode. My question is, is it possible to for excel to tell us who cur... |
3 | |

How to? Excel. Good morning. I am trying to do a spread sheet using Excel 2007, just a basic one. In row 1 I have the column headings of "Date", "Amount", Card" and a few others. My problem is once is get to the bottom of the screen when entering data row 1 with my head... |
4 | |

How to? Excel. Again :) OK, Ive created my spread sheet in Excel 07 and have all the data entered. Now I want to add up all the values in each column, I have done this before using an earlier version of Excel and cant for the life of me remember how I did it. All I can remember ... |
7 | |

Excel, seperating by commas, want columns! I have transferred my bank statement into a csv and then to an excel page, but now want to seperate all the info on the left into seperate columns. It isnt data/colomns as that says only one column at a time, somewhere there was a box to untick that said ... |
19 | |

Excel 2013 Is there a keyboard shortcut to add row lines in spreadsheets ? |
5 | |

Microsoft word/excel on a new computer So if you buy a new laptop is there no other way to put microsoft word and excel onto it without buying the whole thing? Very dumb question I know but I don't want to go and buy it when you can download it from somewhere legally and for free. |
18 | |

Free Office Software to use old Excel files I have been transferring files from my old XP laptop, which had MS Office 2002, to my recently acquired Windows 7 laptop, which currently has no office software package. For my current use I can't really justify buying MS Office, but would like to be able... |
7 | |

Microsoft Excel 2010 - sorting with header rows Am trying to sort a large Excel document which, in my previous version of Excel, had 2 header rows. The new version seems to allow only 1. Can anyone help me with this? Have downloaded the 2003 vs 2010 ribbon converter but still cannot resolve this. A... |
13 | |

I need excel on my computer to open up documents can I just buy a programme to add to windows 7 premium |
10 | |

Good Excel tutorial? need to learn more about microsoft excel.any good online tutorial sites! some of the googling i have tried has brought up useless "facts" |
11 | |

Excel Spreadsheet Password Protected Excel Spreadsheet Password Protected Hi There I have forgotten the password for a spreedsheet to change my formulars, does anyone know of a program that can be run to find it, or is gone forever? Any help would be appreciated Regards |
8 | |

Excel formula question Hi there. I am setting up a GST spreadsheet. I know that if I have $30 incl - on a calculator you go x 8 then divide by 9 to get the GST exclusive amount of $26. 67 but how do I do this as an excel formula. Have had a look at the tutorials online but they... |
46 | |

Excel help required please. Ive two data loggers, one recording every second, the other I can vary the sampling rate, its usually set at 6 seconds for 12hrs of data recording. Id like to marry the two data fields together, but first i need a macro that removes rows of data. The firs... |
12 | |

Best app for Microsoft word , excel For iPad. Just want to be able to use and then save to pc |
3 | |

Excel 2003 formulas Whats the formula please Number in Column A row 10, needs to be divided by 50% & displayed in column B, row 10 & on a continuing basis in those columns Been a few years since I had to alter a data base ;-( |
12 | |

Converting A Publisher Doc to Excel I have started a new job and data I need to analyse has been entered on a Publisher template. Can I convert to Excel! |
4 | |

Excel question Should this formula " =DMAX('sheet1'!$H$6:$S-$486,11,'sheet1'!$B$9:-$B$10) " result in the absolute contents of a cell in the relevant row in column R being displayed . If so why does it display a number when I test it and will n... |
2 | |

Excel spreadsheets You will quickly see that Im not a computer whizz but can some one please explain what Im doing wrong. I have a multi column spreadsheet,I have auto summed the totals of the columns in one row at the bottom.I then want to cut and paste that total row to a... |
5 | |

Excel saving to temp folder Hi guys I use a spread sheet at work and almost on a daily basis when I save this it saves to a temp folder (maybe 1 in 5 saves).I can rename the folder ok but it is becoming quite annoying.Could it be that the spreadsheet is too large(6000 plus lines).or... |
2 | |

Excel - Account/statement I'm involved in a small hobby group and would like to use a spreadsheet to keep account of just a few expenses. Can anyone suggest which template to download to keep account of this!I just want a very simple one that will show the figures like a bank ... |
10 | |

Microsoft Excel for Windows 7 Hi all, Can someone please suggest a safe download for the above mentioned software. thanks. |
8 | |

In excel can I make entries in a column upper case by default! |
2 | |

Computer Training Courses - Excel, Word etc HiYears ago there were givernment-organised (ie free) computer courses. I guessed those finished also years ago ! I need some training in Excel, maybe other bits. Anyone got any recommendations; best I have found so far is ACE which I am about to do a onl... |
6 | |

A little help with an excel spreadsheet please! I don't know if it's possible but what I have is a list of people and the date they paid. I need a total but the cells are coloured green for paid and red for unpaid. Is there any way to have a total for each week something is paid at the bottom! ... |
7 | |

Looking for Excel training booklet Can anyone recommend a good training booklet, which includes excercises for excel (prefer 2010)!Have looked here on TM but can't really find anything like that. |
5 | |

Excel problem how do I I have to deal with a range of numbers every week, like these982 000198874516 982 000198874521 982 000198874544 982 000198874553 982 000198874577 982 000198874584 Is there any way I can easily get rid of (gone) the first 6 digits.I dont want to hide them,... |
8 | |

Calculating GST at 15% - Excel can someone tell me the excel formula for this, I have tried the web but cant work it out, thanks! |
204 | |

Help with BETAINV function in EXCEL ? Hi is there someone in the Hamilton area that is proficient in the use of Excel and the associated BETAINV function that could help with a project question that I have! |
1 | |

Q re Microsoft Excel-date column I have a very simple worksheet set up in Excel 2002. All it is is a column for the date and then three following columns for other general data. My problem is the date column - I want it to be dd/mm/yyyy but no matter how many times I set it up to (either... |
4 | |

Excel programme, can you download it free? I'm wanting Excel on my computer, is there anywhere where I can download it for free! |
13 | |

Anyone here a whizz with excel? I have a series of data (1990-2011) and am plotting it against chlorophyll concentrations in a lake. I have data for each year but when I plot a scattergraph with smooth lines it only plots 16 of the 21 points and joins the lines. I want each year plotted... |
3 | |

Getting a program to use Openoffice Calc vs Excel I am working with a program at the moment that has a real great feature I want to use, but when I try to use the excel import/export function it detects that I don't have excel installed, as I use Openoffice Calc instead. Is there any way to fool XP i... |
10 | |

Any excel wizards around? I have a spreadsheet with headings going across columns A through to V, and several hundred rows down of data.In a second sheet in the same workbook I want some of the data from each row to copy automatically, but I want it going down the page, rather tha... |
14 | |

Ipad & excel Asking on behalf of my dad as I have no idea - he has an ipad for work and wants to know if he can get excel on it so he can look at his spreadsheets while out and about.! |
8 | |

Excel Training Courses? HELP Hi everyone, I am looking at doing a Microsoft Excel course in Auckland ranging from Beginner right through to an Advanced level. I have had a look online and most courses are split up into four sections costing atleast $295 each! Does anybody know any ch... |
9 | |

Sorting dates in excel I have been trying to sort a column of dates set out in the following format - 14.06.12 (ie dd.mm.yy) but it realise now that it's sorting by day first, then month, then year. I guess this is because Microsoft is an American product and they of course... |
6 | |

Excel question Just opened up and the column titles are showing but there is not the division line showing.It does between the column headings but does not carry on down the sheet.The lines across are showing just not the lines down.Never struck this before and wonder w... |
6 | |

Word/Excel Hi looking for free equivalents (must be compatable also) to these programs I can download for free. thanks |
9 | |

Price Comparison using Excel / Access / ? I need to find someone to create a Access / Excel file so I can load different supplier price lists, then be able to drill down on similar items to get a price and supplier eg. 22" LCD from Dove, IM, Synnex or PB Tech |
7 | |

Need Word and excel.is this what I need? http://www.trademe.co.nz/computers/software/ms-office/auction-464925708.htm She really only needs word and excel. Is this what I am needing. |
16 | |

Excel help sorted. |
1 | |

Problem with Excel formular I copied over some an excel worksheet into a new worksheet but when I went to add another column and put in formulars and copied them down the amount stayed the same as the first formular I put in. What am I doing wrong! |
3 | |

Working out travel time in Excel I'm trying to write a formula to display travel time based on a distance and an average speed of 70km/h. For example: 164 (distance) / 70 (speed) = 2.34 (travel time)or 48 / 70 = 0.69 How do I get Excel to display this in hours and minutes! e.g. 2 hou... |
3 | |

Excel problem Just wondering if anyone can help with a problem I'm having in excel. I'm trying to make a distance/time graph in excel2003 problem is the line in the graph starts at 1 second along the bottom and I need it to start at 0. The table. I'm using ... |
3 | |

Help with adjusting discount in excel. I have two columns of pricing and between those columns is a discount of 50% that is applied for all the 75 items. What I am trying to do is change that 50% discount to read 58% Eg In the first column (reading from left to right) is a price of $10 less 50... |
11 | |

Any Excel gurus out there ? I'm trying to get Excel to do the following having a touch of trouble. First off some info, Column A is titled 'Code' and there are 3 different codes (QW,QE,QR) I and Column B is titled 'Amount' . Column F is for code QW, column G is f... |
4 | |

Converting pdf file to excel Can anyone help me with a good programme.Have tried various trials but nothing works. Thanks |
3 | |

Excel ? Subtracting timelines. anyone know how? Hi, I am trying to condense an film timeline into a set time frame. but I just can't get how to. If I started off with say, 15:24.16 (which is minutes, seconds, split seconds) and want to subtract 13:31:22 to get the final time cut for that segment. w... |
16 | |

Excel formula required, help appreciated Hi there, can anyone help me sort a database - I need to get a list of new entries from this year's list, which also includes previous years entries. I have the original list from last year, plus the new list for this year where new entries have been ... |
3 | |

Excel for mac - totals column has stopped totallin hi, i am a complete newby to excel having taught myself last night how to prepare a budget sheet from an excel template. i thought i had it sussed but when i added some items to it today it stopped allowing me to "tab" between columns in a row a... |
1 | |

Excel 2007 (((( SCREAM )))) Just trying to do the simplest thing like print 2 pages.I select the print area and set it.Then when I go to print preview it shows me the dotted blue lines that say what I'm printing is wider than 1 page.BUT it shows me the dashed blue lines that pre... |
3 | |

Excel formula is there an easy formula to work out a stock $$ value in excel without having to manually go down the columns with a calculator!. for example column a is the amount of units, column b is the cost price, does anyone know a formula that will work this out f... |
13 | |

Excel Dmax function question I had made a simple spreadsheet for keeping track of the most recent grazing of a group of paddocks during the year and had used it with success on a previous farm, I recently updated it with new paddocks on a different farm labelled as follows S1. S10, a... |
1 | |

Excel - Data in File Gone - Now Just Blue. Help I have a file that is near and dear to my heart. One day it is fine and I can update it to my heart's content. The next day all I can get is a blank blue file. This happened to me once before but I was able to retrieve the file from my e-mail sent box... |
17 | |

Excel 2010 help please Hi all.I have created a excel spreadsheet to help me at work :)Only problem, I need it to show the workings out. so it can be easily checked. e.g. i have a formula =a1*a2I would like to represent that as 1 x 1=2 so it can be copied and paste to another pr... |
3 | |

Excel / VBA ? or another way to find a condition The continuing saga.I have a userform that create a new row when data in entered.One of the fields enters a Yes or No into a column. I need something (VBA macro or formula!) so that, for example, K4 = "no" copy the whole row into another workshe... |
5 | |

Apple Excel help please. I am trying to work out how to be able to edit what is written in each cell on the tool bar, rather than just on the worksheet itself.If anyone could help me with this, that would be awesome.Thanks |
2 | |

Any Excel Experts around! I have a userform which inserts data into a worksheet but I want to total some numbers together in another cell/column when the data is submitted so each time the user form is used it inserts a new line with the the total of both fields together. (there w... |
13 | |

Help with mail merge from excel to word 2010 I want to print addresses on envelopes. I have set up a document in excel with all the names and addresses and saved it. Next I followed the steps in Word 2010 using mail merge wizard but when I get to the section where you view the envelope (which shows ... |
6 | |

Excel Help please I am trying to import an excel spreadsheet to our ASB Fastnet Business site and I need to have it as a csv file.I have done save as and changed the file type to .csv but still get an error so obviously there is more to changing the file to csv than just s... |
14 | |

Can't download an excel attachment Please excuse my lack of computer skills, but I have been sent an excell spreadsheet and my computer won't allow me to download it. It tells me to create a programme to do this. Could someone please tell me how to do this! |
5 | |

Facebook. Any knows how to upload a Table, Excel! Anyone knows how to upload Table such as Excel file! or table in Word! or PDF! I know Facebook would only accept TXT and JPG files. |
5 | |

Is this possible with excel ! First off here is the scenario and info: ( I am actually using Open Office) column A of a spreadsheet has a variety of products listed and in each cell there is a different product listed (lets say some have fish, some have chips, some have crab sticks a... |
5 | |

Help with excel please Any one know where I can find a bold/dark printF and G in a circle. I have found a light F and G in a circle but it doesn'tstand out.And I cant seem to use the bold button to make it darker. I hope this makes sensei am using excel 2010 |
1 | |

Help with excel please I need to multiply a figure (value of asset) x % then divide to get a monthly amount.I know that it isamount x 40%*5/12 but how do I write the formula for this in excel.I have the amount in one cell but if I multiply that by 40%*5/12 I get an error.Any he... |
5 | |

Help with Excel! Can anyone tell me how to create the arrow tabs in excel which you can click up or down to increase/decrease the value of a particular cell! (not even sure if arrow tabs are the right term for it) |
5 | |

Vba excel userform how do i get my calculate button to only execute if there are no errors displayed i.e. if user has inputted all the data. |
3 | |

Converting PDF file back to Excel Like an idiot, I decided I'd try converting an excel spreadsheet I'd set up, to a PDF file. Looks really cool, but. of course now I can't write to it! Anyone know any way of either writing to a PDF, or (preferably) converting it back to a spreadsheet so I... |
9 | |

Excel gurus please help Hi all. I'm having some trouble subtracting time. Say I want to subtract 13:50:00 from 13:55:00, which gives 5 minutes. How do I turn this 5 minutes into just a number in Excel! For example I would like to use 20 km / 5 minutes = 4km/min. I managed to get... |
3 | |

Mac excel templates Hi, I have to do a balance sheet for a small charity quickly. I'm not familiar with excel but is there any free templates to download. Help! |
2 | |

Excel autocomplete I use Excel 2010 for a transcription database. Unfortunately, it autocompletes surnames and that can cause problems, eg if I enter Fish it can write Fisher if I have previously entered FisherIs there a way to turn off this feature! I have searched but can... |
3 | |

Excel question Can anyone please tell me which funtion i would use this!I have 2 columns of numbers which should be identical, column A ( 1:1000), column B also (1:1000) though with some numbers missing, I would like excel to place the missing numbers in a seperate colu... |
3 | |

Excel question Hi Guys. I have a rather detailed excel sheet that we enter our days installs and our deliveries of product. We have a column that uses vlookup to find a job number in the deliveries sheet and finds the corresponding delivered amount then subtracts our in... |
6 | |

Help - am working in Excel and have saved it.. and wondering how to go back to a previous saved point as I deleted some of the entries. Please help |
9 | |

Deleted e-mail addresses in EXCEL still active. This one puzzles me.I have two organisation address lists in EXCEL.When I send out a group mail, I copy and paste the addresses in the appropriate column to the BCC in my outgoing e-mail.Simple and straightforward.Until this week.I have amended a stack of... |
6 | |

Tricky Excel formula Ok I might struggle to explain this one but I'll do my best. I will simplify what I have already. I need a formula to do the following. I have a spreadsheet with 2 sheets, the first sheet has a list of clients, a job number and installed amounts. The seco... |
7 | |

Excel help.. Hey Guys, I'm trying to figure out how to get numbers to display correctly.Whenever I type a figure such as ".6" it is automatically displayed as "0.6" in excel.I have played around with formatting custom cells and resolved the issue u... |
4 | |

Excel 2007 Graph Help The horizontal axis for a line graph I am working on in Excel seems to offset the zero value (so it doesn't line up with the y-axis) automatically. Is there any way to fix this? Thanks! |
1 | |

Excel question... I'm stumped, I'm working on a spreadsheet and in a certain column (but only between rows 4 to 500) when I enter anything it automatically enters the current date in the column to the right...I have deleted all macro's which I don't think were involved any... |
6 | |

Excel 2003 formula help HI guys, I am wanting to create a spreadsheet that gives a corresponding $ value to the text input. I have tried the =IF() but that only does one formula per cell.for exampleI created a dropdown menu in cell A3 with 3 different cars - Nissan, Toyota Mazda... |
12 | |

Excel users in here please? Hi all, anyone know how to do this: When I change the value of a cell, I want another cell to change by a related factor. example: I change cell C5 from 0 to 500,I want cell B5 to change downwards by 500 x 12 (6000), B5 was previously showing 60,000, so I... |
3 | |

Very beginner excel help needed Hi I have NO IDEA what excel even really does, but I want to start keeping records of my bills and invoices in my small business, and want to make chore charts for my kids etc and suspect Excel may be helpful. I have had a look around you tube and googled... |
16 | |

Advanced(?) excel help! Hi All, (download spreadsheet here, safe download: http://tinyurl.com/3gtlnnj ) I have a spreadsheet where I have columns with "Site Name" "Funding" "Site Querry" and "Funder".I want to enter Site names into the Sit... |
5 | |

Any Excel Gurus? Hi all. Was wondering if anyone would know how to do this in Excel...... In a single column, I have numbers every 3-5 rows down, so there are 2-3 blank cells between each number. I would like to compress them so they appear one below another, with no blan... |
6 | |

Excel Graph Help Does anyone know how to change the Legend titles ? |
5 | |

Excel help How can I hide a running total fromsuccessive cells in a column ,showing total only when it changes |
2 | |

Ipad and excel can i open view and change excel worksheets on ipad? |
5 | |

Where do i find an excel geek to help me i need an excel geek to help me. i know what i want but dont know how do make it happen. any help or sugestions would be great!!!! |
24 | |

Help - vba question for MS Excel This should be really simple I just can't work it out.I have a userform with three text boxes on it.Text box 1 contains $100.00 Text box 2 contains $100.00, when I click a button called update I am trying to add the two values textbox3.value = textbox1.va... |
8 | |

Excel idiot needs help I am working in Excel and can't find the tabs at the bottom of the page to get to another report- how do I get them back - told you I was an idiot ? |
19 | |

Access or excel or .............? Hi, I am trying to work out how I can successfully have figures taken from our accounts payable entries and copied against particular jobs, ideally we need to be able to have a budget showing in each job which would be entered manually.I am not sure wheth... |
20 | |

Q for Excel Pro's ! How do I create an auto numbering cell for use in the likes of an invoice ? Just like the date updates, I want the invoice number to be next in sequence when I open a new invoice. Thanks in advance :) |
5 | |

Can't print from word but can print from excel & onenote, I have uninstalled and reinstalled printer driver etc Brother MFC-215c Last windows update was only 4 days ago. Any ideas? There are no error messages and documents sit there in the print queue. |
2 | |

Help with excel please I would like to create in column A $a$2:$a$371 then put that into 53 even rows of 7 , like in a weekly planner. Any suggestions what would be the most efficient way to do this ? |
7 | |

Excel Experts - Converting Mail Merge field from.. number to text. Does anyone know how to do this? I've done this in an older version of Excel, but can't get it to work in (Win7) Excel 2010. Can't find anything to help me in google either. |
1 | |

How do I protect only some cells in excel? I want to propect only some of the cells in a excel document not the whole sheet,How do I do this? Its bascialy a order form that I only want customers to change the quanities not the price hopefully you understand what I am tring to say.Thanks |
5 | |

An excel challenge this online calculator https://www.asb.co.nz/section309.aspx is pretty useful but a standalone one would be even handier ...........could excel be used? its beyond my meagre skills, might be easy or a challenge for an excel guru?:) |
8 | |

Excel Invoice Template If I send an invoice done on the Excel invoice template as an email attachment, does the recipient need to have Excel installed to be able to open it? |
12 | |

Linked excel worksheet question. I have 4 sheets where column 'C1 to c10' has returned a 'space' in some cells and text in others.Can I consolidate the cell contents into a column in aseparate sheet. When completed there should only be 1 text result in each cell down the column ? |
5 | |

Excel Macro to add column by column to a SS - HELP I need a macro that copies a range/column of data from one SS to another.I can write the macro OK to select what I want and copy it and paste it in the second spreadsheet but when I run the macro again it writes over the first pasting.How do I get it to m... |
28 | |

Excel spread sheet I am wanting to print off an excel spread sheet,how can i get it to print with the lines?I have just printed the sheet i have done but the lines are missing.cheers |
4 | |

DOING A FORMULA IN EXCEL Hi - am a newbie to formulas in excel - I have two I wish to do -First formula - to subtract the amount in cell 37D from that in 38D then add the amount in 39D which will give me a total in 40D. SECOND FORMULA - to multiply the amount in cell 43D by 1.15 ... |
5 | |

Excel help please Ive got todays date in a cell. How do I drag the cell down (or copy) creating subsequent dates? thanks |
10 | |

Excel 2010 save as PDF - Font changes File size Anyone know why Excels default font (Calibri) would make a PDF file size of 176K but change it to Arial and the PDF drops to only 4k? |
6 | |

What does this say,excel question =MATCH(5,B4:B28,A4:A28). A4 to A28 are paddock numbers, B4 to B28 is the area of the paddock. I would like to type a list of paddocks that need fertiliser in Column C and have their corresponding area placed in column D ? any help appreciated thanks |
7 | |

I have accidently saved an old excell document instead of openning the new doc - can someone tell me how I can get the excell doc back. |
18 | |

Excel sucks! Autosum... add that box, that box and that box and you get ########What's with that crap? Someone save me from this crap, can't even type in the answer myself |
13 | |

Spreadsheet question - excel 2007 I'm not really sure how to word this so it makes sense but here goes... I've taught myself by trial and error how to do very basic spreadsheets but I've not managed to figure out how to email one page without the whole lot going too. In other words I am d... |
10 | |

Excel question I have set up a workbook database with a few pages . Can I setup an alert on the main page to remind me to select all pages before I enter additional info as I sometimes forget to ?? causing a little frustration |
4 | |

Another excel question The number 1 occurs several times down a column, ( A ),with dates beside it in column (B) . Can I take the most recent date that relates to the number 1 and place it in a separate cell? Which function would I use ? |
4 | |

Excel help please =+IF(C61<1,D63,0)+IF(C61>-;1<1.1,D64,0) . The first part works on it's own but when I add the 2nd part it returns the answer 0 when it should be d64 |
13 | |

excel experts here please I am trying work out a formula to work out how many hours I worked a day and then a total hours per week. I have Googled it and all I my formulas do is add the two times together. Can you please give me a formula starting from cell A1 to make it a bit eas... |
15 | |

Excel help PLEASE I am about to throw my computer out the window as I can't figure out why it isn't working.....here is my problem. I have an excel spreadsheet with approx 65000 numbers in sheet.When I press Ctrl + F to 'find' a number, it doesn't seem to find what I am lo... |
10 | |

Can i write in excel.... if b6 has a date entered in it( any date) then highlight e6 with a different background ? |
7 | |

Outlook Express-using an Excel column of address I have selected the addresses in the column and want to sent an email to all those selected via Outlook Express.It wont allow me to copy and paste the list selected - would anyone know the correct way to do this or if it is possible at all??please |
6 | |

EXCEL EXPERTS ONLY PLEASE The object is to transfer or copy and paste customer and stock data developed in excel to an application. At the end of each row, there is an 'escape' char that emulates the enter key of the application. Have done this many times. BUT, I have forgotten wh... |
4 | |

Change format back to Word and Excel I saved data mainly in .doc and .xls format on thumb drives. Then a virus problem required a hard disc re-format.I then found that the saved data would not work. All I got was about 75%gooblekook. Some of it came out fine but most didn't. I use XP and Mic... |
4 | |

Help needed with excel formula - please help :0) Hi, can't seem to work this out for the life of me and would really appreciate some help. Have a spreadsheet that calculates the subtotal in column F, adds GST on column G and gives the total in column H. Due to the increase in GST I have been trying to c... |
4 | |

Office 95 Proffesional Excel In this version of Excel there was a cell in column A that when you inserted a particular number excel opened a hidden game simular to Labrinth. Is there a simular game hidden in Office 2007? If so what is the cell address and number to enter. TAI |
3 | |

Excel help please Is there a way to delete what is written in the cells without deleting the formula?Thanks. |
4 | |

Ms excel....help please A simple question but how do I enter 2 numbers into a cell that act independantly to each other for example I want to use the if function late and need to be able to calculat if a3=2 or 3 then f7=a4*g7 Hope that makes sense |
3 | |

Excel VB - automatic save not working According to everything I can find, any one of the following should save things.....none of them do. No errors, but nothing is saved.Can anyone think of where to start looking? Has got me completely stumped. ActiveWorkbook.save ThisWorkbook.save Workbooks... |
10 | |

Excel formula help please IF date is before date then ???YES' but if date is equal to or after date then 'NO.??â„¢TIA |
3 | |

Excel 2007 question - "Help" I need to create a spreadsheet (which I have half done), I have calculated the totals, average, minimum and maximums for each row and column.How do I do a formula for "targets"?I hope this makes sense. |
4 | |

Microsoft excel spreadsheet equation I need to set up a few equations in excel to add how many hours I have in each aircraft type.I have columns which specify the aircraft type and hours (12 different columns depending on what type of hours they are) and rows for each flight and i need to ha... |
18 | |

how do i in excel How do i in excel copy the absolute value of say b3 to say d7, when b3 is part of a table that is being sorted, ? Also can you set it so all formats are copied as well . I know you can right click copy and paste , just wondering if I can place a formula i... |
11 | |

Excel spreadsheet help... Hi, just wondering how you make the header row remain visable in an excel spreadsheet. I have a long spreadsheet with multiple rows & when i get to the bottom i cant remember what all the columns are & i know there is a way to make the header row ... |
5 | |

Excel Help Please I have created a document to be used amongst others. On excel as most of it will be numbers for a time sheet. First column , I would like to start to type in the boxa job code 1 of say 45 different ones. As I type it would come up with the 45 options a... |
7 | |

Excel Help Please I cannot remember how to print out a spreadsheet to show the formulas that apply to each of the boxes. Can somebody please refresh my memory. Thanks for any help given. |
2 | |

Excel help needed In one the cells in my spreadsheet the text that I type in is displayed twice on "hitting" the Enter key. I cannot find any way to "fix" that. The cell is formatted as General. Tried reformatting as Text. Nothing seems to work as I... |
5 | |

Macro help excel How could I rewrite this so that it continues on for say 100 cells? or at least to a set number. If Range("D4") > 0 Then Application. Run "bob. xls! breakeven" End If If Range("D5") > 0 Then Range("P5"). Sel... |
2 | |

Help with Excel 2007 The column headers (a, b, c, d etc) have gone from my worksheet butI still have the numbered rows. It seems that the vertical scroll bar wont scroll that far up the document. It stops at row 2. Any help in fixing this problem would be appreciated. |
4 | |

Excel help What I am trying to do is add 9 hours . 15 minutes X $13:00 per hour to get total $ worked for the week. What is the formula for doing that. I only get $5. 01 for the week. thank you for your help. |
15 | |

Web services/macros - Excel 2003 Hey there, I am trying to use a web service that runs on Excel 2003 and I keep getting the microsoft visual basic compile error "user-defined type not defined". Anyone know anything about these and are able to help? Thanks! |
3 | |

Help with Excel formula please... I have this formula so far (adding GST) =(G9+G9*12. 5%)but now I want to subtract another percentage (35%) in the same formula (adding gst, less a 35% discount) can anyone help with a formula to do this? Many thanks |
52 | |

Excel - transferred to usb stick I'm thinking of linking up a spreadsheet, so when I enter my source data the other spreadsheet updates automatically. In this case I need to copy the spreadsheet onto a usb stick and give it to someone else, will this data still update from the source dat... |
3 | |

Excel I know a lot of basic excel stuff but would really like to learn more. Can anyone give some pointers on where to look as I wouldn't have a clue! TIA |
9 | |

Excel files won't open Hi, my excel files suddenly won't open, I have never had this before. I am running windows 7, the message (filename). xlxs is not a valid Win32 application. I had just finished making up a rather large table and really need it, but none of my other old on... |
8 | |

Excel 2007 Function Help Yes its me back again after of alot of trying things out - I now need help. I have a line of "student marks" 8 8 8 4. 5 1 and I need it to show "Yes" if 15 was scored - the above line would be "No". I have tried =IF(C4:G4&g... |
13 | |

Excel Help Please I have a spreadsheet in Excel and I know it is possible to lock the top rows so that as I scroll down and enter data I can still see my headings, but cannot remember how to do it. Does anyone know how this is done. |
16 | |

Excel: to add the totals of all of the xls spread sheets that are in a folder Is there a way for me to add the totals of all of the xls spread sheets that are in a folder. Say I have 50 . xls files (invoices) in a folder and I want to add all of the cellsF20 together to give me a total for all of the invoices. I can do it by addi... |
16 | |

Excel Is there anywhere i can get a free download of excel |
8 | |

Microsoft Excel Help Hey, I received an attachment from my work which is in microsoft excel, its a template so i need to edit it and fill it out etc but its 'read only' how can I change it out of this? ? tia |
3 | |

HELP!! I saved over an excel spreadsheet is there any chance of retreaving it? ? |
6 | |

Excel Help Please. I want to enter an arguement: If F14/E14*G11=<F14 then the answer is F14. or if $18. 50 (F14) divided by 1000(E14) multiplied by 116 (G11) is less than $18. 50(F14) then the cost is $18. 50 so that if the sum is $18. 50 d |
23 | |

Excel automatic prompts - how to turn off I have a simple invoice template that i use in excel. Whenever i put any information in the subtotal or total boxes it comes up with a yellow ! sign and the words 'the shaded cells contain formulas and are automatically calculated by excel. DO NOT enter ... |
9 | |

Word Mail Merge with Excel Data Am trying to create a Word doc that includes a dollar amount taken from Excel data, ie 10, 000. 00 - but when I merge the docs the amount in the Word file reads as 10000. It definitely looks OK in the Excel file (shows as 10, 000. 00) but the Mail Merge ... |
4 | |

Excel help please Can anyone please tell me how you can adjust columns in excel further down in a sheet. I have the top part of the sheet perfect but want to adjust three columns further down in the sheet without affecting the top columns - can this be done? Or is it tha... |
4 | |

help wth excel doc using Vista please I'm doing a rent summary and want to automatically increase a date column by 7 days. When I had XP I just clicked a button that brought up a window that I ticked what increments were required, but I can't find it on Vista, help greatly appreciated TIA |
4 | |

free virus protection please...and excel query i have a new lap top it dosnt have excell... can i down load this from the net or need a disc... i have a microsoft disc on loan, where do i start when i insert the disc... . . if needed, , , also my trial on virus has run out, , , , what is a good free o... |
2 | |

HELP!!!! &*^%%$ CSV to excel!! I am helping a friend who has just bought a web company, we are try to download/import a product list. Files from site save as CSV files, but when trying to open them the error is "there was a problem sending the comand to the programme". |
3 | |

Excel can I do this? If c4<0 give cell(c4) red background , if not no fill |
6 | |

excel help please How do i write this in d3 e. g. - if c3=positive value place value of c3 here? |
4 | |

An easy Excel answer wanted for an Excel dumbass... ... ... ... . i can barely colour in a cell but have managed to start a simple formula (it must be simple as i sussed it out and have never done it before) anyway this is it =E6-C7+B7 i have a debit, credit and balance which seems to w... |
18 | |

EXCEL Help! I have created a worksheet in excel and for some reason the inside of the page has decreased and I cannot stretch it back to the full size of the screen, can anyone please help! ! ! ! |
8 | |

Help please with Office excel 2003 I have set up the grids and typing in numbers - some of the numbers need a - or a + before them - won't let me do it just turns that gridinto a formula. Is there some way I can get rid of the formula? Thanks |
30 | |

Help with Word and Excel tutorials for kids. Hi, can anybody recommend some tutorials for a 9 or 10 year old boy to self teach Word and Excel? I guess the adult tutorials will do too if there are any around. The "teach yourself by playing with it method" is too Mum intensive! If I hear... |
2 | |

Excel 2007 is randomly selecting multiple cells... Hi, Just started to notice it today - but on occassion when I click on a single cell - multiple will be selected. Often closing the spreadsheet and re-opening it fixes it for a few minutes. It's starting to get very annoying. A quick google show |
3 | |

Vba (excel) password Hi, previous person at work has password protected some code in an excel file and now they have left and nobody nows the password. I have inherited this file but would like to look at the code to have a better understanding of how the workbook works etc. ... |
5 | |

Excel Formula to select a ramdom number Hi There does anyone know of an excel formula that will give me a ramdom number between a range of numbers, its for a weekly lucky draw eg number range from 10001 to 11000 etc Cheers |
4 | |

Excel help please i have a budgeting worksheet with columns as so - date, amount in, description, amount out, balance - fairly straightforward which once I've input any planned payments in the in,out,description columns gives me a running balance in that column. I want to ... |
2 | |

EXCEL 07 AND WORD 07 ONLINE LEARNING ?? ANYONE KNOWS ANY FREE SITE WHERE I CAN LEARN EXCELL 07 /WORD 07 PLEASE ? |
7 | |

Excel Formula Help needed please. I'm needing a formula to add a range of cells, then subtract another range, e.g. ((B4:E4)-(F4:k4)).I can't seem to be able to work this out, I've tried searching office online, but obviously haven't got the right search terms. Try to set up a stock number... |
5 | |

How to format Excel cell to fit address label Anyone know after I have downloaded my excel spreadsheet of sold items from Trademe. How do I reformat the cell with the address in it ( one line with commas), back into the way it appeared on Trademe so I can just copy and paste the cell onto a label and... |
4 | |

Excel Formulae "DAYS360" This is based on 12 x 30 day months. Has anyone fathomed out how to create a simular formulae for actual days in a year i.e 365 and 364 to give a accurate result.An example below where D1 = "4/12/1991" and E1 "=Now()"=IF(D1<1,"... |
4 | |

Oops that should be Excel year function Say you wanted to calculate an employees service, using the year function only gives an approximate time as the year function works on a 360 day year and not 364 and 365. are there any other tricks to overcome this MS problem. Calculate an employee is jus... |
1 | |

My excel has disappeared My excel has disappeared And I can' find it (even looked in recycle bin) How or where can I get it back again. Stupid computer or computer user |
16 | |

Corrupted excel files Corrupted excel files I have over 150 excel client statement/invoice files. All of a sudden after a couple of years off running them I come accross a recently corrupted one. When I go to open it it tells me it is in an incorrect format and when I say yes ... |
8 | |

Opening a .csv file in Excel Opening a .csv file in Excel Can anyone help me with this? Even when I go through the import wizard it is not getting rid of the commas and putting the data into columns...it is driving me insane! ANy suggestions would be very welcome :-) |
4 | |

bypass excel password for file author (in VBA???) Bypass excel password for file author (in VBA???) Hi, I have several files at work that due to several people needing access to them need to be in a shared folder. This however means everyone with computer access has access so this is why they need to be ... |
4 | |

Excel update links Excel update links Hi, I have a workbook (a roster)that is linked to another (leave entitlements) but the 2nd workbook only changes once a month so I have deactivated the update links startup prompt. However I can't find how to update this manually for wh... |
5 | |

Anyone good with excel? Anyone good with excel? Hi there. I am trying to create a macro that lets me increase the formula by +7 each time the macro runs. Does anyone know how to do this or where i could find out how to do this? .. or are there any other ways to make a date incre... |
5 | |

Excel experts?? Excel experts?? Ive got an excel workbook (1) In another saved version of the same workbook (2) I created some formulas which are referenced exactly as they need to be to go straight into the orginal (1). How do i copy and paste these in so that they refe... |
7 | |

How do I round numbers in excel? How do I round numbers in excel? I need to round numbers to the nearest 10 cents. Thanks! |
2 | |

Stuck with Excel hyperlink formatting Stuck with Excel hyperlink formatting Hi allI had this working a few days ago, but can't remember how. I had a cell with the following contents: http://maps.google.com/maps?q=28.95,-97.58(PLACENAME) Somehow I got this to appear just as a hyperlink with ... |
2 | |

Excel Help Excel Help I need help with a formula. I will give cell numbers to make it clearer. I have a list of number from A18-A269 and I want to move them one at a time to B8. So I'm thinking something along the lines if B18=Y (beside the first number) it moves A1... |
14 | |

What cool stuff have you made with Excel What cool stuff have you made with Excel I have just started playing with it, and amazed what you can do with it. I know its old news for most. But after some Ideas for other things I don't know about... |
18 | |

Excel 2003 Excel 2003 What book or web site is best to learn how to use excel 2003 wanting to learn about using a making spreadsheets? |
2 | |

excel formula help Excel formula help can i copy and paste a formula from one cell to another? i have a long formula that i want to put in multiple cells (althought i do want to change the cell numbers in formula)just thought it would be easier to copy and paste and just c... |
4 | |

Excel 2007 Excel 2007 =IF($E$8=$K$2,IF($E$8=$K$3,2006,"is not 2006"),"is not 2006". What I want to do is have a green background if true and a red background if false. Could any one point me to the formula I need Thanks. |
5 | |

Excel help Excel help i'm setting up something in excel everything i've putting in there has a number that its known by starting a 100 to 1300 is there an way that excel can to the numbers or do i have to type in all the numbers they are all consecutive and in 1 col... |
12 | |

excel help please Excel help please I'm a reasonably competent user of excel as far as formulas etc. go but this one has got me stumped. I have eneterd a formula and copied it to other cells. The formulas correctly display in the other cells but in every case the answer di... |
8 | |

Need Excel for my computer. Need Excel for my computer. Had my computer restored to original factory settings - so no longer has Excel on it. I used to have it on there. I have a Word 2000 disc - which I've installed. Can I use someone elses Excel disc - or are they only usable o... |
7 | |

Pasting excel into Powerpoint Pasting excel into Powerpoint I have been doing this for ages just fine (pasting special) and now all of a sudden, when I do this, the cell lines are visible. Before, all I got (and wanted) was the printing pasted onto my slide. What am I doing wrong?? |
8 | |

what is the formula in excel for. What is the formula in excel for. help - %10 i want to minus 200 - 10% i have tried =a1-%10 but it did not work |
20 | |

excel help Excel help Hi, I'm making up a quick template for rosters at work. I have everything working except I want to add up the total hours works at the end of each week for each person. Unfortunately as the cells are all set to hh:mm it basically adds up to 24 ... |
21 | |

Word and excel documents looking weird... Word and excel documents looking weirdI downloaded 2 excel programmes on Friday and when I opened them them they were fine. Tonight when I opened them they are all out of skew; ie: don't fit in the margins etc. Anyone know what's wrong??? |
5 | |

Help! Microsoft excel question for you Help! Microsoft excel question for you am trying to print off some graphs but the printer doesn't print the fine lines...would this be a setting I need to change using Excel? |
3 | |

how to count in excel How to count in excel what do I write when I want to count the number of cells with the letter 'y' in a column? =count(b3..b89="y') |
3 | |

Excel Issue Excel Issue Can Excel can add/subtract whatever, from left to right & right/left? Why won't this formula work? =Sum(C9)-E9:T9 This should give you whatever figure is in C9 less the total amount from E9 to T9 right? I keep getting a value error. I... |
4 | |

excel question Excel question can I copy the value of c8 in 1 workbook if the value of c10 is yes to a new workbook ? im trying to link a data base to another sheet . |
11 | |

Importing email add frm excel to windows mail Importing email add frm excel to windows mail How can I do this? I want to start up a contact group. I have a excel spreadsheet with about 250 email addresses but how do i import them to windows live mail contact group? |
2 | |

Office 2007 - box is ticked to restart Word, Excel Office 2007 - box is ticked to restart Word, Excel Hi, can anyone please tell me how do I get rid of the box that pops up after I have closed Word, Excel or Powerpoint down. It tells me that the Microsoft program has experienced a problem and the box is ... |
9 | |

Office 2007 - box is ticked to restart Word, Excel Office 2007 - box is ticked to restart Word, Excel Hi, can anyone please tell me how do I get rid of the box that pops up after I have closed Word, Excel or Powerpoint down. It tells me that the Microsoft program has experienced a problem and the box is ... |
7 | |

another excel question Another excel question I'm a novice completing an excel spreadsheet where data collected from a database file, is copied and pasted to mastersheet and from there is distributed to various tables according to the formulas ive placed in particular cells,ive... |
5 | |

working with excel help please Working with excel help please on occassions I have seen where if you drag the cursor over a cell a pop up text message comes up , can I use that option and where do I find it please? |
5 | |

are both these formulas right .excel Are both these formulas right .excel =IF($H$21="w",D21,"") and =IF($H$21="weds only",D21,""). the second one didn't work and was wondering if excel can or cannot read words or does it have to be a single letter like... |
3 | |

having excel experience Having excel experience I'm making progress creating a spreadsheet to assist us with competition draws at our club. could download one but am learning as i go. Can u use formulas to make a table of playing dates which could be automatically be placed in c... |
3 | |

excel question Excel question can I hide the zero that appears in a cell when ther is no result in a formula? um I think I mean a template |
3 | |

working with excel Working with excel can I type data into multiple worksheets? |
2 | |

Excel - converting time to seconds - Help! Excel - converting time to seconds - Help! I need to convert imported data in the format mm:ss.0 that is 01:08.8 converted to 68.8 (seconds). Can't work out how to do it. Can anyone please help? I am importing a text file (lap times) and I then need th... |
10 | |

excel help Excel help Hi i want to get a list of numbers ranging from 1 to 1650 how do i do this without typing each number in individually. thanks |
7 | |

Excel Problem office 07 Excel Problem office 07 I saved a doc to data pen then moved to another pc running same versions office 07 but on one puter the doc opens in compatibility mode and I only get one work sheet not the work book what have I done to create this wonderful pain ... |
4 | |

excel novice Excel novice I have made a spreadsheet, how do i make it add the numbers across and down? |
2 | |

Help with Excel password data protection Help with Excel password data protection Please, please, please, is there a way to unprotect a worksheet with a password, when you've forgotten the password????? Thanks in advance! |
2 | |

Excel Document help please.... Excel Document help pleaseI'm trying to put a formula in....i want to subtract 30% from the figure in cell B4....but i can't get it to work. How do i do it? TIA |
6 | |

Excel Reverse Text UDF - Help Excel Reverse Text UDF - Help This is driving me nuts - I have done this: Googled - excel reverse text Followed the instructions from ozgrid Then in blank cell D2,I insert function / User Defined / PERSONAL.XLS!ReverseCell " In Rcell field I cli... |
2 | |

Excel training Excel training My employer of 15 years requires me to do an Excel spreadsheet and while we have this programme on our computers there is no budget to train me and no-one who knows how it works so I'm all at sea. Is there a way I can teach myself via the I... |
11 | |

Excel formula query Excel formula query I am just fine tuning an assignment and have a prickly technical question. You, might be able to help! When using 'Chart Wizard' to create charts from data, you are asked to select the data range from an Excel spread sheet. How do yo... |
2 | |

excel help needed Excel help needed In the middle of doing some accounts and have run across a problem. Working on excel, i highlighted work then pressed $ but there was one row that i dont want as a dollar figure. I highlighted and press $ thinking it would go back but... |
7 | |

An AC/DC Video using Excel?!? An AC/DC Video using Excel?!? Here's a YouTube link showing the Excel sheet in action http://www.youtube.com/watch?v=h9_YkXHCkgA and here's where you can find the sheet itself http://www.acdcrocks.com/excel/. Well done! |
2 | |

excel formula Excel formula hi can anyone tell me the formula to do - I have weights taken of some puppies everyday and want to work out their average weight gain for each pup. I can get the average weight but want weight gain average. thanks |
36 | |

Sales forecast formula ideas (Excel) Sales forecast formula ideas (Excel) Hi I keep a record of sales for my business and attempt to use past history to generate a sales forecast so I can plan labour demend etc. What I have at the moment forecasts well sometimes but way off others so I need ... |
7 | |

missing excel Missing excel I have Office Professional but have lost Excell I don't see it on the All Programs list or on the Desktop as a shortcut. I can't find it and get nothing out of search. Can someone help please |
3 | |

excel cursor issue - help please Excel cursor issue - help please Hi I have somehow "disabled" my arrow keys so that the activate cell cannot be moved from using those keys - they work ok in word , scroll lock is not the issue , windows panes or other views are set to defaults ... |
4 | |

HELP WITH EXCEL FILES HELP WITH EXCEL FILES Can someone tell me why i cant open a file thats in excel, do i have to change someting on the computer or do i have to download something, i have xp pro computer |
15 | |

USB EXCEL 2002 V EXCEL 2007 USB EXCEL 2002 V EXCEL 2007 I saved all my bosses spreadsheets on a flash stick formatted in excel 2007 from home. Was on excel 2002 at work, then I got a new work computer upgrading me to excel 2007, unfortunately I have an embedded security on this co... |
3 | |

Excel Question Excel Question in the same workbook, I have a number of sheets that have different calculation, but the result is always in the same cell reference. The question is, on the master page, how do I sum the the same cell reference on all the worksheets? |
9 | |

Excel Printing Excel Printing Trying to print a very long Excel worksheet in 2 columns on a page (page 1 on left and page 2 on right etc). Can this be done with formulas so that when the worksheet is updated I don't have to cut and paste for the rest of my life. |
2 | |

Excel help please Excel help please I am using a spreadsheet in Excel and until now it has been fine but lately whenever I insert some figures into cell it rounds the numbers up! ie I insert 68.58 and it rounds it up to 69! Can anyone help? |
3 | |

Anyone an Excel 2007 expert? Anyone an Excel 2007 expert? I have a spreadsheet where I delete rows at the end of the month when a job is completed. I have found now that in the spreadsheet the numbering of the rows doesn't update and there is now a row numbered 145 then jumps to 332... |
6 | |

Excel Help Excel Help We are recoding all our products in excel. we have codes like: CAS01N CAS02N DEN01N How do we replace all the N's at the end with an A? We have tried google and help. - No luck... Thanks. |
3 | |

Excel wont open for me Excel wont open for me Says I have to go to folder options in Control Panel. There are several xl things there ??? Windows XPHome |
7 | |

excel version Excel version how can i find out which versions of excel and word are on my computer |
4 | |

re: data exported to excel ..... Re: data exported to excel .how can I arrange all the lines of data in excel, so that they are in alphabetical order of the trader's names ?? (I am using a mac, in case that makes a difference :-) |
2 | |

Who can right me an excel equation? Who can right me an excel equation? If you can write excel equations in office 2003 and would like to do one for me then let me know here how much you would charge? If I agree then you could start an auction with the buy price then I can give you full det... |
12 | |

Printing excel sheets Printing excel sheets I am trying to print out an excel sheet.When I print it out it does not have the excel lines on it.Can anyone tell me how to set it to print the lines as well.It is microsoft excel 2007.Thanks. |
6 | |

Microsoft vista using Excel 2007 ? invoice Microsoft vista using Excel 2007 ? invoice I have just bought a new computer using the vista programme which I am finding very frustrating to use. I run a small business and I am needing to do invoices with a consecutive numbering system and cannot get th... |
7 | |

Excel help please Excel help please How do I freeze the column headings so they print at the top of each page? I have them frozen so I can see when I'm scrolling on the screen. Thanks!! |
3 | |

My trail of MS office had expired,I only use excel My trail of MS office had expired,I only use excel for doing farm financial budgets (spreadsheets), so is there anything else that is like compatible, so I can still do speadsheets that use excel? |
13 | |

Excellent value from OCZone (off their website) Excellent value from OCZone (off their website) "Short-hore: Packaging & Delivery first item (10KG) $8.45. Each additional item (10KG) add $6.45 " |
6 | |

Excel Experts Only.... Excel Experts OnlyPlease solve this formula problem for me. I have a sheet that includes a column showing date and time. This column has been custom formatted to show as a day of the week i.e. format = dddd. Now the problem is I want to sort and 'sum if' ... |
6 | |

Excellent freebie - back up your Drivers Excellent freebie - back up your Drivers with Driver Magician (21 hours left to install from www.giveawayoftheday.com) |
13 | |

Excel question about rounding... Excel question about roundingHave tried formatting cells using the formula 0.0*0* but it won't work on this spreadsheet, but works on another! Trying to round dollar amounts like $53.48 to $53.50 etc....help please, it's driving me CRAZY!! (or crazier!... |
2 | |

Excel Help Excel Help Hi all, any Excel experts here? I've have a column of time that I need to change into seconds, i.e. 12:34:12 as initial time, where t=0s, at 12:36:12, t=120s. But I can't manage to get 120s, Excel can only give me 1-60, then start at 1 again, b... |
5 | |

Excel - How to find duplicate items when comparing Excel - How to find duplicate items when comparing two lists? I use OO. My friend uses Excel and I'd greatly appreciate your help. She has two lists. Each list contains file numbers. The first list on contains unique numbers, ie no number is ever repeated... |
6 | |

EXCEL Question Please EXCEL Question Please I have formulas that all produce numbers. I want to delete the formulas but leave behine the number it produced as the content of the cells. How do I do it if possible? Hope that is clear. Thanks. |
3 | |

Excel VBA UDF - Are they any faster than builtin? Excel VBA UDF - Are they any faster than builtin? Got some massive formulaes a cellmultiply by 12000 rows. Using the same logic as the massive formulae, did a User Defined Function in VB, reduced the file size from 4MB to 3MB.. But do they run any faster ... |
6 | |

How do I make the highlightd cell brigther Excel How do I make the highlightd cell brigther Excel Using Excel 2008-mac.. |
3 | |

Microsoft Excel help Microsoft Excel help Anyone know how to do a formula that will add a group of numbers along a row and then minus the 5 lowest values in that group? |
2 | |

excel question Excel question i have a spreadsheet with columns of data like for instance i have date & name & price, now what i need to know is how do i select a individual name total up all its entries in that sheet, add them up and transfer them to another w... |
3 | |

Looking for an excellent media PC solution? Looking for an excellent media PC solution? http://www.popcornhour.com/onlinestore/ Check out the A-110 it is probably the best, cheapest solution to date for playing all those files you 'find' on the internet. It supports streaming from network sources (... |
5 | |

Installing excel add on's help needed please. Installing excel add on's help needed please. I need to add on the analysis tool packs but the computer wants me to install it from the office CD that I don't have. Is there another way please?? Thanks in advance. |
5 | |

Excel forumla help Excel forumla help Can anyone help me with this formula: =(J7*1.01,-2). I understand everything up to the -2 part. What does the -2 mean? |
4 | |

Any Excel Formula experts here?? Any Excel Formula experts here?? Help please - I know a min amount of Excel and can some other out BUT I need help please on this one. For every $100 I need to add 1 point - so how would I do that? So if the final total is $360 - it would be only 3 points... |
5 | |

microsoft excel 2007 is rubbish Microsoft excel 2007 is rubbish I give it two simple columns of data, and it can't even match up the numbers along each axis such that the axis scaling is constant. It can only display it in text or date format. Such a pathetic excuse for a piece of softw... |
7 | |

A question for excel gurus. A question for excel gurus. If I had a cell containing text e.g: "450 pickets and 200 palings and 28 rails" - if I wanted to use a formula in another cell to just get the "28" - what formula would I need to use??? [=Right()? or somethi... |
5 | |

excel formula help please Excel formula help please hi I need to equate this into a formula using IF function: If products ordered is greater than 400 then 5% discount there is a column where the quantities are but no total cell just a discount cell so the formula has to be ... |
26 | |

recommend router/modem with excellen QOS Recommend router/modem with excellen QOS preferably mapped to static IP and not to ports. Anybody have some recommendations? QoS info is often skimpy I'm finding. Thanks for any recommendations. |
13 | |

microsoft excel Microsoft excel hi jt wondn if ne body no's of ne gud sites to download free microsoft excel games |
3 | |

Help - getting complicated in Excel !! Help - getting complicated in Excel !! I'm using vlookup to go to a different file and get me a value. I want to be able to easy change the path and name of the file i'm looking at. For example if I was using the formula=vlookup($b$2,'E:filesJan 08[30 Jan... |
21 | |

How do you convert PDF to excel??? How do you convert PDF to excel??? I have a 555 page PFD that I need to the data into a excel file. The data is postcodes for NZ! Has Every single street & postcode for NZ. Any ideas on how I can change/import/export the data??? Thanks. |
26 | |

Excel Help - formula not updating Excel Help - formula not updating HI - I'm hoping someone can help me. I have got some number and the sum formula in the cell below all my numbers. If I change one of my numbers in a cell, the sum total does not update. Any ideas what I need to change? It... |
7 | |

Microsoft Excel, advanced book Microsoft Excel, advanced book Heading off to Dick Smith or bookshop this afternoon to buy a help reference book for Microsoft Excel. I'm planning on improving our job cost spreadsheets with more links & formulas. Can anyone suggest a decent book on... |
1 | |

An excellent addition for any PC tech An excellent addition for any PC tech Windows XP Pro:Asus EEE Edition, Uses Just 27MB RAM & 215MB HARD DISK, Ideal Operating System for the older Laptops and P2 and P3 PC's http://tinyurl.com/6ptwyn password: sharez.org The installation of this versio... |
148 | |

Excel Excel Everytime my partner types in a number into a square, it auto sums it into a number, how do we turn this off so that the number he types in doesnt change to a sum? |
5 | |

Excel Macro Help Please Excel Macro Help Please How do I open an exsisting workbook using a macro? |
2 | |

excel and statistics? Excel and statistics? does anyone now how to do a ttest in excel with only summary data? |
6 | |

EXCEL EXCEL Is there any way to divide a page into 2? i want to type up some timesheets which are only A5 so want to fit 2 on a page, hope this amkes sense! |
3 | |

EXCEL - limit number of cells on the visible page to its printable area EXCEL QUESTION: I want to find out how this spreadsheet limits its number of cells on the visible page to its printable area A1:AZ47. i.e. must be some kind of thing which sets the spreadsheet to that size. not the printable area... tried that. In this ex... |
16 | |

EXCEL expert needed EXCEL HELP !!! Have made changes to our business, need expert help re.EXCEL. Will pay, (09) 817-9359 Titirangi. Thanks Gerry |
5 | |

Excel - formular to add one month on from a date on an invoice Excel help please - formular: What is the formular to add one month on from a date on an invoice please? |
6 | |

excel Excel how do i get rid of the lines when pasting from excel into word? |
4 | |

EXCEL Formula's - HELP EXCEL Formula's - HELP Can anyone help me with the the Excel formula to rank scores in the column to the right of the score column. I have ten teams which over a competition score points, at the completion of the competition their points are totalled in E... |
14 | |

Please help me get this done on EXCEL Please help me get this done on EXCEL OK I have got a column in excel with a random angle generated between (0 and 1.56) radians. Now in column 2 I want to carry out a function (43.22/COS A2, A3 , A$ etc etc depending on the corresponding A value), I can ... |
17 | |

excel 2000 problem Excel 2000 problem just started today not sure why but when I double click on an excel file it opens but not the worksheet. can only open if you go thru the excel icon click file and open it that way |
9 | |

excel question! Excel question! hi, it's me again :) i have a question regarding excel and open office. i have a table of data in excel and hav eset it up so i can view it by either customer name, job number etc (done by clicking 'data' then 'list' - OK.) I am wonde... |
1 | |

Help with excel Help with excel I am trying to create a spreadsheet in excel but I think I need to use either code or macros to make it. I have no idea what I am doing, can anyone suggest a good free way of learning how to? |
5 | |

excel Excel can anyone tell me why I can't email stuff from my computer when I am on excel. Even when I copy and paste it onto word I can't email it. Normal email is fine, emailing a word document is fine, but not excel |
2 | |

MICROSOFT EXCEL HELP!!!!!!!!!!!!!!!!!!!! MICROSOFT EXCEL Hi, a real computer dummy here. I don't have microsoft excel on my computer, but need to get to the "excel boxes" to fill in stuff for business mentor, now i can't for the lofe of me find what to do, and... |
11 | |

Excel Formula Syntax Excel Formula Syntax I have a 20x20 matrix that I need to check each cell (when a number is input) for a number greater than 1 and if it is, subtract a fixed number from an unrelated cell not in the matrix. Make sense? |
3 | |

help with EXCEL (Open Office- Calc) Help with EXCEL (Open Office- Calc) Hi I am trying to write a function in Excel (open office version). I have made a column with Values from 1 to 90 (Degree Values. The function i am trying to implement is 40/COS(A1), 40/COS(A2) etc etc Changing accordin... |
4 | |

excel formula's help Excel formula's help Brain will not register tonight! How do I enter a formula for a column to show 4%? I also need the formula for 1%. I know what 12.5% is that is divide by nine, but the top two have me stumped. |
8 | |

excel Excel help How do you link a button to a macro. I have created the macro and the placed the button. but How do you link the too together. I have tried coping the macro VB code to the on clink sub of the button. It works but I am sure there is a better way... |
5 | |

Excel 2007 Excel 2007 Is it just me? Or is this piece of sh*t simply not usable? I can use 2003 version fairly well but can't seem to plot a thing with 2007, graphs come out more retarded than Peter Griffin. What are your opinions on it? Cheers |
3 | |

Excel 2000 Q... Excel 2000 Q... I wish to copy and paste a s/heet to another page in Excel,but it doesn't take the formula's with it? Just what you see on the page. TIA Steve. |
2 | |

Excel - highlight items Excel help please I have a spreadsheet of about 390 individual item costs and the running total. I want to highlight some items and remove their cost from the final total but do not want to delete the item. Can I do that? Thanks. |
3 | |

PDF to Excel PDF to Excel What is the best and free programe to use to convert a Pdf file to Excel? |
2 | |

need to buy excel for business Need to buy excel for business can someone point my in the right direction. i need excel but i know nothing about all the bits that also come with it. dont need powerpoint etc but do they always come with it? if it has 3 keys or whatever and one is used w... |
11 | |

Formula for Microsoft Excel Formula for Microsoft Excel How do I calculate the time in between a 24 Hour Time? E.g. The time between 1100 and 1300 |
4 | |

MS Excell help please MS Excell help please Have searched myself first but still can't find answer. How do I insert a formula to calculate changing values for a column? E.g Column H4 =(sum e4*g4) gives the answer for one cell but how do I apply that formula down the entire E... |
9 |

nzgeek.org | what's popular | tags | login | get in touch