excel
44960 TopicsAuto fill cells depending on another cells content
I'm OK with Excell, but by no means an expert. I'm creating a sheet that will calculate gas purge volumes, and I've got most of the cells sorted with calculations based on other cells, but one of them is giving me a headache. It's probably simple for those with experience. So... I have cell E2 which contains a drop down list (linked to another sheet) which gives options (which are meter sizes) E6, U6, G4, U16, etc. What I'm trying to do is get the column F2 to auto fill depending what is selected in E2. So, if someone selects meter size U6, cell F2 will auto populate with the number 0.0028, if they select meter size E6 then cell F2 will auto populate with the number 0.008, etc Sorry if the use of E6, U6 etc complicates things, those are the actual names of the meters. Any help is greatly appreciated.26Views0likes1CommentOdd pasting of things as images
This just started on specific page of one specific workbook, but now happening on completely new workbook. If I select a cell and copy and paste it puts it as an image in the cell. If I right click to paste I dont get the usual choices of test, formula, format etc I just get paste picture in cell or paste (which pastes an image) I've done a full reinstall and now it seems to be alternating between normal copy and copy as image if I do Ctrl C. The clipboard shows an image and then text in the history. I've disabled all com addins except dropbox. Driving me nuts as been getting slowly worse over last few months. Any ideas appreciated44Views1like3CommentsHELP WITH EXCEL
Struggling to do a simple transition in Excel if anyone can give some advice: I have 3 items I need to run up & down instead of across... is there any easy way ??? So I need the Name and two of the xx Boxes to run from top to bottom... I did the first two but I did them cell by cell.... is there a formula that will take the entire thing and create what I need? Adriana Zaragoza Lopez Alejandro J Escobedo Alyssa Christina Amber H McCord Ana C DePaz xx xx xx xx xx xx xx xx xx Adriana Zaragoza Lopez xx xx Alejandro J Escobedo xx xx34Views0likes3CommentsWhy is Excel suddenly calculating much slower than before?
I've noticed that one of my workbooks has become significantly slower over the past few weeks. It's around 20 MB, contains several PivotTables, XLOOKUP formulas, and conditional formatting. Simple edits now take a few seconds before Excel responds, even though my PC isn't under heavy load. Has anyone experienced something similar? Are there any common settings or features that typically cause this kind of slowdown? Any suggestions would be appreciated.9Views0likes0Commentsseparate columns in excel (imported from .txt file)
Hi all. I have a a table to bring in from a .txt file lots of lines with an excerpt below. I have tried to import data and copy paste etc and then tried to separate columns using delimiters and also number of characters but there is no consistency in the numbers in the columns, it keeps separating different rows differently (ie if i use space the title of the object on the 2nd row may have two or three words so using space as a delimiter is out, same for the number of characters and position). Any suggestions - is too much data to try and clean up by doing one of the above then trying to tidy it!17Views0likes0CommentsChart plotting values in wrong place according to axis?
I have this chart in excel that is being produced from a table in another tab in the same workbook. It has simple date in one column and values in another. When I hover over the plots for the MailChimp line the value displays correctly (e.g. 1344 in the screengrab for 25/6/26 datapoint) but the plot is between 2500 and 3000 on the graph according to the axis. This isn't happening for any other lines on the graph for any other values, only for the Mailchimp line. Any ideas how I can rectify this or what could be going wrong?Solved52Views0likes2CommentsHelp needed to filter in Excel please
How do I filter our spreadsheet to populate a list with only lines containing the search word? For example: 18598-Ensign, 6 - 3 POSITION TIE LUGS, RIG 141 18599-Ensign, 6 - 3 POSITION TIE LUGS, RIG 143 18600-Savanna, REPAIR JACO CATWALK SKATE ASSEMBLY, 653 18601-Savanna, REPAIR BAIL TILT CYLINDER, 653 18602-NS Modular, 8" LTC, 6PCS And I only want to see "Ensign" jobs. Thank you6Views0likes0CommentsHow to edit an embedded textbox
Years ago I made an invoice form (actually I used an Excel template and modified it) that has an embedded text box containing 3 lines: address, city - state - zip, and a phone number. I want to change the phone number, but for the life of me I can't remember how I entered the info to begin with, nor can I figure out how to edit it. When I click on it the address bar reads =EMBED("Forms.TextBox.1", ""). Can anyone please tell me how to change the phone number in this textbox? This has gotten very frustrating. Thanks in advance.25Views0likes1CommentExcel worksheet protected but can't use text to column function
HI I have a worksheet that several people use that I need to protect. There are formulas and a pivot table. I have been able to lock what I need and am able to refresh the pivot table but I can not use the "text to column" function in the raw data as its greyed out. The area in question are not locked cells but the function is still unavailable. We need to be able to use the text to column function but I also need the sheet locked to protect the formulas.34Views0likes2Comments