Questions tagged [microsoft-excel]
A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function. Also add the the specific version tag (e.g. [microsoft-excel-2019] or [microsoft-excel-365]) as features and functions may vary between them.
8,888
questions with no upvoted or accepted answers
2
votes
0
answers
2k
views
How do I "Use Destination Theme and Link Data" in PowerPoint (MS Office 365 Business)
I want to select a table from an Excel file and paste/link it into a PowerPoint presentation with the destination theme, so that if the Excel file is updated, the corresponding PowerPoint presentation ...
2
votes
1
answer
2k
views
Excel - Insert rows by shifting cells down - without format loss - Change default shift operation
I have an excel sheet as shown below. As I don't have privilege to paste image, it is uploaded as link
I would like to insert the highlighted records on top of the rows shown.
When I select all the ...
2
votes
2
answers
107
views
Extract Array Formula from data with multiple criteria
I have the following table containing Laptop details
(Laptops)
Name | RAM | CPU
===========================================
Laptop Example 1 | 4 | Intel® Core™ i3-8130U ...
2
votes
0
answers
38
views
Pie showing % spent with overlaid line showing % of timeline elapsed
I give a regular budget update to a customer that prefers a pie chart. The chart indicates how much of the total budget has been spent (full circle=total budget, slice 1 = expenses to date. Thus the ...
2
votes
0
answers
585
views
Strings turn to gibberish when opening excel
I'm working at a company that have a running web-app for accounting management.
I've recently received a complaint regarding exporting a report via email in excel format (the report contains ...
2
votes
0
answers
37
views
Connect additional column in excel to a Data source table
I have a PowerApp which I use to add items (rows) (from an inspection) to a list in Sharepoint. This sharepoint list I import in Excel using "Get Data" and the whole sharepoint URL, etc. In Excel I ...
2
votes
1
answer
357
views
Excel error charts and drawings
I'm experiencing an odd issue with Excel. Whenever I open an Excel file (both xlsm or xlsx, Office 365) I receive back an error message about drawings and I cannot see any chart or drawing inside, ...
2
votes
0
answers
999
views
Why Does Excel ReCalc on Open
I am trying to determine what causes a workbook to calculate when opening. I know the basics:
volatile formulas
closing workbook without calculating
I have a 15MB workbook that we have used for ...
2
votes
2
answers
102
views
Excel: Formula that supports more than 15 digits
My formula is follows:
{=TRUNC(SUM(IFERROR(LEFT(A1:A600,FIND(" ",A1:A600)-1)*10^(MATCH(RIGHT(A1:A600,2),{"KB","MB","GB","TB","PB","EB","ZB","YB","BB"},0)*3),0))/(10^(INT((LEN(SUM(IFERROR(LEFT(A1:A600,...
2
votes
2
answers
2k
views
Linked pictures are duplicating themselves almost like a mouse pointer trail when I move the group they're in
My linked pictures are duplicating themselves almost like a mouse pointer trail when I move the group they're in. I have them grouped with some charts (15 on the sheet) I have a few pivot tables on ...
2
votes
0
answers
2k
views
Office 365 Excel crashes when copying worksheet to new workbook
I need to make reports by copying multiple worksheets to different files using Office 365 Business Excel. I can't use Office 2010 or 2013 because of organisation's policies.
Configuration:
Windows ...
2
votes
0
answers
1k
views
Insert data to database using Excel VBA is not working
I have a macro that will upload data from multiple workbooks to the database. Table will differs based on what type of value/data being inserted. I have there tables. I can insert value in the first ...
2
votes
1
answer
2k
views
How to change default format of Excel which apply to all new Excels Workbook
Basically There are two settings which I want to change from default behaviour of Excel.
Changing Default Column width
In Excel, Currently default column width is set to "8.43" for every new ...
2
votes
0
answers
46
views
Sane way to edit with Excel formulas?
Is there any sane way to work with large and complicated Excel formulas?
For a simple =IF(A1>B2);C3;C4 or something similar, just having it chained behind each other is OK, but if we are getting ...
2
votes
1
answer
706
views
Need Auto Increment number beginning with Alphabet in Excel
Suppose I have a number ED000071, I want the next numbers to be ED000072, ED000073, ED000074.........ED999999, EE000001. Could someone please help me to write a formula for this in Excel?
2
votes
1
answer
468
views
Excel: formula to find a date between two dates based on some cell value
I'm working on a huge data and I need to fetch data based on a cell value and a date. I do realize that my task can be done through a macro but I want a simple formula rather.
Problem: I have two ...
2
votes
4
answers
6k
views
How to more efficiently use Tortoise SVN diff for large Excel files?
I was pleasantly surprised to find that Tortoise SVN diff lets me find the diff between two excel files. The cell which is different is highlighted in red. It works for small excel files.
But I have ...
2
votes
0
answers
1k
views
Excel for Mac conditional formatting not working (at all)
My Conditional Formatting button stopped working (MacBook Air, MacOS Mojave 10.14.2, Excel 2016). This is true for existing files with the formatting done previously, and new files. None of them are ...
2
votes
0
answers
374
views
How can I reload an Excel spreadsheet using a different encoding?
Someone shared an Excel file with me (.xlsx, not .csv). Looking at the data in Excel it's obvious that the file is encoded using UTF-8, but Excel is interpreting the data as Windows 1252 encoded text. ...
2
votes
2
answers
254
views
Stuck in the excel formula for duplicate removal
=IF(COUNTIF('PRDA Data'!S$2:'PRDA Data'!S2,'PRDA Data'!S2)=1,'PRDA Data'!S2,"")
This formula is used to eliminate the duplicate from another sheet. Now the issue is Duplicates are removed from the ...
2
votes
1
answer
957
views
Excel Character Encoding - Cell showing one thing, while text export includes new character
I have an interesting situation in Excel 365.
I one column I have phone numbers of my contacts. By looking in a cell it looks like this:
+xxx31417728
But when I export file as text file TAB ...
2
votes
1
answer
164
views
Excel: How to automatically store data gathered from a website scrape?
I have set my workbook to retrieve data from a website which gives prices of stocks.
It refreshes hourly. I then have some cells that make calculations based on the stock prices using a simple ...
2
votes
1
answer
4k
views
How to disable a macro, with another macro in Excel VBA?
I have 7 macros that prevent a user from copying and pasting in a workbook.
However, now and then I want to be able to copy and paste. Is there a way to disable these macros with another macro ?
I can ...
2
votes
0
answers
652
views
Excel 3D Flat Map
I am trying to display some data on the flat version of the 3D map. But unfortunately the map cuts off down the middle of the pacific ocean so half my data is on one end of the map and the rest on the ...
2
votes
1
answer
602
views
Convert large data set to rows of comma separated lists
I have a large amount of data (41k+ rows) that is exported by the company's sales management system, assigning each salesperson to a zip code in the United States. It looks like this (every column has ...
2
votes
1
answer
3k
views
Find position of first uppercase character in excel string
I need to find the position of the first uppercase character in an Excel string. There are lots of resources on the web that have the same (or effectively the same) solution for this:
=MIN(IF(ISERROR(...
2
votes
1
answer
60
views
Excel for Mac Version 16.18 is dividing my numbers by 10
Excel has just started dividing my entries by 10. If i type '2' in a cell it writes 0.2 and so on. I have no idea what i changed that caused this to start but would love some help to fix this?
2
votes
0
answers
59
views
Prevent MS Word Linked Tables from using Sharepoint Link
When I shift+F9 on a table in a word document I've linked to a local excel document, it seems to prefer to use the sharepoint web address rather a local or relative address. How do I force MS word to ...
2
votes
0
answers
280
views
Excel prepends extra line (but not carriage return) in mult-line cells
Sometimes I use ALT + ENTER to make multi-line cells.
However, Excel often appears to prepend an extra line for some reason, even though it's not an actual carriage return. Usually, you can adjust ...
2
votes
1
answer
88
views
It is possible to create grouped charts in Excel?
I have many variables with the same time scale, Is there any way to create a grouped chart in Excel?
Something like this:
2
votes
1
answer
509
views
Format chart colours based on series values
Is it possible to format the colours of a bar chart with a single series based on their values, i.e. anything over 50 would be green, anything below would be red?
What I currently have to do is a ...
2
votes
1
answer
862
views
Annoying warning message while doing Ctrl + c on Excel
It's been a while I have been getting a warning message that pops up on Excel when I do Ctrl + c or right click + copy
The message says:
There's a problem with the clipboard, but you can still paste ...
2
votes
0
answers
652
views
Excel Mobile (Office 365) equivalent of CELL("filename")
I'm trying to create an excel workbook that can work on all platforms including mobile and web. The only problem is the following: I want to use the sheet name in a formula. Is there a way to access ...
2
votes
2
answers
294
views
Excel VLOOKUP function giving the incorrect value. Can somebody identify mistake?
I have been using the VLOOKUP function a lot in Microsoft Excel but these last two days have been rough. I have been trying to "match" the state population with the state name. I was able to use the ...
2
votes
2
answers
2k
views
Is there a way to mark/tag an excel cell?
So I'm trying to build a C# program that reads data from excel cells. I thought it would quite efficient if I could implement a mechanism that searches an entire excel file and only reads from the ...
2
votes
1
answer
1k
views
How do I make Excel tab through merged cells in a protected sheet?
I am having a problem with how tab selection in an Excel sheet behaves on merged cells when the sheet is protected versus when it is unprotected.
I have a merged cell that is two rows high. When the ...
2
votes
3
answers
1k
views
How to prevent deletion of cell content in online Excel?
an office clerk asked me if there would be a way to prevent deletion of a cell in online Excel. (Ms Office running from her workstation). I have no clue but the question appears interesting.
Context: ...
2
votes
1
answer
50
views
Sort datetime data by time only
I have an excel document with hourly energy consumption. They are listed in order but I am trying to group them by each hour. Right now it looks like
5/1/17 0:00
5/1/17 1:00
5/1/17 2:00
5/1/17 3:00
5/...
2
votes
0
answers
37
views
Excel - updating linked cells from the clone
I work with a pricing spreadsheet, which has hundreds of inputs, but in reality I only tend to work with 5 or 6.
I want to create a summary worksheet where I only have the inputs I want to ...
2
votes
1
answer
570
views
Pivot Table won't show correct data relating to the row names
I'm trying to create a pivot table to tell me how many people are coming to different parts of a bachelor party. When I select the "Row Labels", I select that of "Coming Zorb" as they are the same ...
2
votes
0
answers
3k
views
Excel highlighting selected cell
I'm currently working in Excel a lot (MS Excel 2016) and searching for values.
In the search result if I'm clicking on an entry, in the background automatically the cell is selected.
Unfortunately ...
2
votes
1
answer
741
views
Excel: referencing a table cell
In Excel I have a table, with the first column acting as a unique identifier (I make sure there aren't duplicates). I want to be able to reference a cell of this table's first column so that:
- if I ...
2
votes
1
answer
4k
views
Conditionally display decimal point (not places) in Excel
I'm trying to mimic the way a "general" cell shows a decimal point only if there are decimal places, but I want thousands separators which "general" doesn't provide. I'm using a custom number format ...
2
votes
1
answer
199
views
VLOOKUP() to a Table on a different worksheet returning an #N/A error
I have 2 tables, daily entry
and summary
My formula in BQ20 of the summary table is currently:
=IF(VLOOKUP(BQ5,Table11[DATE],1,FALSE),VLOOKUP('SUMMARY (NEW)'!B20,'DAILY ENTRY'!A:H,8,FALSE),"")
...
2
votes
0
answers
147
views
MDS Excel add-in multiple entities in one xls file
We have a couple of issues that might be bugs. At least we cannot find any fixes or help on the web.
We have an Excel sheet with a sheet per Entity. All data comes from the same MDS.
First problem
...
2
votes
0
answers
289
views
How to paste HTML headings into Excel
In a previous answer (vba - html table to excel worksheet) about parsing/pasting HTML table contents into an Excel sheet, wbeard2 shared this very helpful, illustrative piece of code. He/she notes ...
2
votes
2
answers
3k
views
Replace WORD text for specific cell value in Excel using VBA
I am kind of new here and I am also new to VBA.
I need to replace a specific cell value in a WORD document.
I have the replacing part of the code done, but only for a specific text. I need to replace ...
2
votes
1
answer
2k
views
In EXCEL, How to automatically fill a cell with the same color from another cell, combined with an IF/THEN formula?
My template involves three cells, but only one cell needs help (the 3rd).
The first cell will equal either $0 or something greater.
The second cell will be greater than $0 or be blank.
The third cell ...
2
votes
2
answers
431
views
What is the easiest way to insert data with the wrong decimal separator into Excel?
I have a lot of situations where I need to quickly insert/import numeric data into Excel. I have no personal preference for either ',' or '.' as decimal separator. However, the data I import sometimes ...
2
votes
1
answer
5k
views
Auto-update Excel cell size in response to dynamic content
Context: I have a sheet with a drop-down with different categories. The sheet also has a table whose information updates depending on what category is selected from the drop-down. Some of the ...