Why 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.
Auto 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.
HELP 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 xxDefault White Gridlines
I have the oddest problem, could not find anything like it online. After some recent update to Windows (i think it was after that) my Automatic Gridline - the default for Excel has turned to "white" See attached screenshot. It changed the existing as well as all new excel workbooks. And it has to be fixed for every sheet. This is annoying and cumbersome. I even tried Repair and Repair online but no difference. Please can someone assist in changing the Default back to black.
Odd 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 appreciatedseparate 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!Chart 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?
Help 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 you
